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