If you want to identify machines with a specific piece of software installed, you can utilise the Add/Remove Programs software inventory to do this by […]
Tag: Query
Report on Dell Warranty Statuses for all machines using SCCM & Dell Client Integration Pack
Dell have an excellent tool freely available called Dell Client Integration Pack. Included in this tool is something called Warranty Status. What this part of the […]
SCCM – WQL Query for machines with a valid Hardware Scan in the last x days
If you would like to identify the machines that have had a valid hardware inventory scan within the last x amount of days, you can […]
SCCM – WQL Query for MAC Address Prompt
If you would like to search for a machine based upon its MAC address, you can use a WQL query to do this. The WQL […]
SCCM – Query for devices in a specific Active Directory Organisational Unit (OU)
If you are looking for a SCCM query query that will return all machines that are in a specified organisational unit (OU), then you can use […]
SCCM – SQL Query for newly discovered devices in last 24 hours
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 […]
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 […]