If you wish to run a SQL query against your SCCM database to find all machines with SQL installed, then you can use this SQL […]
Tag: SQL
SCCM – WQL Query for machines without Endpoint Protection installed
If you need to identify machines that have the Configuration Manager client installed but do not have the System Center Endpoint Protection client installed, then […]
SCCM – WQL Query for machines with 4GB RAM or more
If you have a requirement to identify machines with 4GB RAM or more, then you can use the following WQL query to do this. select […]
SCCM – WQL Query for devices with specific software installed
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 […]
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 ConfigMgr clients not upgraded to CM2012 (v5)
This is a query for ConfigMgr 2012 and it will return the machines that do not have the 2012 client installed on them. This is […]
Server Information SQL Query for SCCM
The below SQL query can be used against your SCCM database to return information about your servers. You can edit this query to bring back […]
SCCM – WQL Query for devices with Google Earth installed
If you want to identify machines with Google Earth software installed, you can utilise the Add/Remove Programs software inventory to do this by using this […]
Nitro PDF Serial Number Collection using SCCM
Sorry but we have been forced to remove this page as NitroPDF believe that we are giving out serial numbers illegally. Although this is just […]