To inject Windows Updates into custom-built images that you are using in your Configuration Manager OSD environment, you may find that keeping them up to date is a real problem. If you are happy with the image itself and do not want to make any changes to it, why should you need to rebuild and … Read more
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 SoftwareFile data in the SCCM SQL database. Also, having spent some time Googling a query for Google Earth, we found that … Read more
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 go into the SCCM Console, Devices, search for the device and then right click and delete the device which would remove … Read more
We have recently been using a new script that we came across which allows you to run a PowerShell script on your SCCM environment and it looks for all the Dell hardware models that you have and then automatically downloads all the latest drivers and BIOS’s for each machine found. This is an excellent way … Read more
If you are using SCCM for the deployment of software then you may find that with the smaller SSD’s that you may be using that free space is becoming an issue. This can be because the more an end user installs to their machine from your Software Catalog, the more data that is being downloaded … Read more
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: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like “%Microsoft Windows NT Workstation 10%” You can change the “%Microsoft Windows NT Workstation 10%” to create collections … Read more
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 using SSRS to create a custom report: More Queries Our full range of SQL and WQL Collection queries are available here. … Read more
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: More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or … Read more
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: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ClientVersion != “5.00.8412.1007” Where “5.00.8412.1007” is the latest version number that you are … Read more
If you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also change the last “0” to “1” to create a collection of active devices.
We recently came across a great guide on how to setup a DCM item to detect if any users machines had the Windows Firewall turned off and how to report on it. So, we thought we would share this guide with our visitors, so head on over to MyITForum to check out how to carry … Read more
We have recently started to have problems with running a CScript command in one of our SCCM task sequences where we send the local computer description to Active Directory to automatically set the Active Directory computer name description. It has always worked fine but seemed to have stopped working after the latest hotfix. So, after … Read more