Tagged: SCCM


0

SCCM SQL Query – Google Earth Installs

We have recently been asked to report on Google Earth installations within our SCCM environment. So, as we were already collecting the EXE file information within our hardware inventory, we could make use of the...

0

SCCM SQL Query – Spotify Installations

We have recently been asked to report on Spotify installations within our SCCM environment. The reason is that the IT policies state that users should not be installing Spotify on company machines but a...

0

SCCM – Delete a Device using VBS

If you are using SCCM and you want to delete a device from your database (for example if you are using OSD and only deploying to Unknown Devices) then you would normally have to...

0

SCCM – OneDrive Next Generation Sync Client

If you want to deploy the new OneDrive Next Generation Sync Client using SCCM, then there is a excellent guide available detailing how to do this over at scconfigmgr.com You can see the guide by...

0

SCCM WQL Query – All Windows 10 Installs

If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this WQL query below:

You can change the “%Microsoft Windows NT...

0

SCCM SQL Query – Count Computers by Model

If you are using Configuration Manager and want to run an SQL query on your database to count the number of different models you have in your organisation, you can use this SQL query below...

0

SCCM WQL Query – No ConfigMgr Client Installed

If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, then you can use this WQL query:

0

SCCM WQL Query – Clients without latest version installed

If you want to create a collection in Configuration Manager to show you all the devices that are not up to a specified version, then you can use the WQL query below:

Where...