SCCM 2012 SP1 CU1 Client Version Queries

sql2016

With the release of CU1 for System Center, you will notice that your Configuration Manager clients version will have changed to 5.00.7804.1202 from 5.00.7804.1000 If you would like to identify which of your clients have updated to the new version, you can use the query below: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System … Read more

SCCM – SQL Query for newly discovered devices in last 24 hours

sccm logo

This query for SCCM will tell you the devices that have been discovered by Configuration Manager in the last 24 hours. This query can be amended to change the amount of days you wish to look back at for newly discovered devices by changing the last digit in the code. SQL Query More Queries Our … Read more

Find last logged on user by NetBIOS name – SCCM Query

sccm logo

I’ve been asked a lot of questions about the various ways of using queries and there are almost no limits to what you can do with a query and of course, you can then go on and use these queries for creating collections or just to supply you with the information you require. I have … Read more

SCCM – Last logged on user query – All Systems

sccm logo

If you are looking for a query that will display all machines and their last logged on user, the below will do this for you without any prompts. This allows you to search on the data to find what you would like across the information provided by the query. The query below is the full … Read more

SCCM Query to create collection for x86 & x64 machines

sccm logo

We have been asked on a number of occasions how to create Configuration Manager Collections for machines on x86 or x64 Windows Operating Systems. To do this, you should use the two collection queries as below: Instructions Query to create collection for x86 machines Query to create collection for x64 machines More Queries Our full … Read more

SCCM – SQL Query for showing number of different Operating Systems

microsoft black logo

If you would like to create a report to show you the number of different Operating System’s you have, you can use this script below which should provide you with the information for Servers and the various Windows OS’s. Query SELECT CASE WHEN Caption0 LIKE ‘%XP%’ THEN ‘XP’ WHEN Caption0 LIKE ‘%Windows 7%’ THEN ‘Windows … Read more