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 […]
Tag: SQL
Find last logged on user by NetBIOS name – SCCM Query
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 […]
SCCM – Last logged on user query – All Systems
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 […]
SCCM Query to create collection for x86 & x64 machines
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 […]
SCCM – SQL Query for showing number of different Operating Systems
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 […]
SCCM Collection Queries
We have been building a number of collections within SCCM lately so we thought we would start to build up a reference here of various […]
SCCM – Find system by Last Logged on User Query
If you need to find a machine for a particular user in your business using SCCM, one way you can do it is to use […]