Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Three questions in SCCM 2007

Posted on 2009-05-16
1
Medium Priority
?
279 Views
Last Modified: 2013-11-21
Dear All,

I have three questions in SCCM 2007:

1- How we can make a query in SCCM to know all clients which they have SMS 3 client installed?
2- How can I know which SCCM version that I have (RTM, Released, Evaluation, SP1 or R2)?
3- In SCCM client side, how can I know what are the client version installed (SMS 3, SCCM, SCCM SP1)?

Thanks

0
Comment
Question by:Arabsoft-ACS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 31

Accepted Solution

by:
merowinger earned 1500 total points
ID: 24429802
Question Nr. 1
You mean the ConfigMgr Client?!?
Create a query with the following sql query:

select Name, ClientVersion, ResourceDomainORWorkgroup, LastLogonUserDomain, LastLogonUserName, ADSiteName, IPAddresses, ResourceId, ResourceType from  SMS_R_System where Client = 1 and ClientVersion > "4.00"

Question Nr. 2
ConfigMgr Console --> Site Database --> Site Management --> right click your site + Properties
Then check in the internet for the version which is listed.
For RTM, it is 4.00.5931.0000
For SP1, it is 4.00.6221.1000

Question Nr. 3
On the Client goto Control Panel -> ConfigMgr Properties -> Tab General -> Configmgr Clientversion
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is my 3rd article on SCCM in recent weeks, the 1st (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html) dealing with installat…
Remote Apps is a feature in server 2008 which allows users to run applications off Remote Desktop Servers without having to log into them to run the applications.  The user can either have a desktop shortcut installed or go through the web portal to…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question