Solved

Three questions in SCCM 2007

Posted on 2009-05-16
1
271 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
1 Comment
 
LVL 31

Accepted Solution

by:
merowinger earned 500 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

After having deployed hundreds of thousands of Terminal Services seats worldwide, I still see all the time people asking me that same old question: "If TS/RDS is that reliable why are you telling me I should reboot it that often? My DC/SQL/Exchange/…
Issue: One Windows 2008 R2 64bit server on the network unable to connect to a buffalo Device (Linkstation) with firmware version 1.56. There are a total of four servers on the network this being one of them. Troubleshooting Steps: Connect via h…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

785 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