Solved

Three questions in SCCM 2007

Posted on 2009-05-16
1
276 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 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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

On a regular basis I get questions about slow RDP performance, RDP connection problems, strange errors and even BSOD, remote computers freezing or restarting after initiation of a remote session. In a lot of this cases the quick solutions made b…
Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip is around source server preparation. No migration is an easy migration, there is a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

732 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