Practical IT Guides for Windows, SCCM & PowerShell Admins
TechyGeeksHome has been helping IT professionals and sysadmins since 2010. Find 1,500+ real-world guides covering Windows 10 & 11, Windows Server, SCCM/ConfigMgr, PowerShell scripting, Active Directory, networking, and virtualisation — all written from hands-on production experience by a UK IT pro with 26 years in the field.
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 using this query. select distinct SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ClientVersion from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = “Microsoft Office Professional Plus 2010” order by SMS_R_System.Name In this … Read more
If you want to identify machines that have been newly discovered within the last 24 hours, then you have use the query below. select SMS_R_System.Name, SMS_R_System.CreationDate from SMS_R_System where DateDiff(dd,SMS_R_System.CreationDate, GetDate ()) <= 1 If you want to change the 24 hours value, then just amend the where value of 1 (this is a day … Read more
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 tool does is looks at your SCCM SQL database for Dell machines and their asset tags, then checks against its own warranty database for the warranty information. It then inserts … Read more
If you are having trouble in getting the Dot.Net 3 feature to enable on your Windows 8 machine, there is a way that you can do this offline by using DISM and the original Windows 8 media. Instructions Firstly, you sure ensure that you have your original Windows 8 media in your optical drive (or … Read more
We have recently been asked about how to add a static page to Google Blogger, but not have it added to the menu tabs – whilst keeping other tabs in place. So in essence – how to create a hidden custom page. We use these to give general information on pages without them being added … Read more
If you need to identify machines within your SCCM environment that have a certain amount of RAM or less, you can use the following WQL query to do this. SQL Query Code You can change the where value “1024000” to the amount of RAM that you are looking for. More Queries Our full range of … Read more
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 use this WQL query as per below. select SMS_R_System.Name, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceId = SMS_R_System.ResourceId where DateDiff(dd,SMS_G_System_WORKSTATION_STATUS.LastHardwareScan,GetDate() ) <= 15 This query is defaulted to 15 … Read more
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 query that you should use for this is below: select distinct SMS_R_System.Name, SMS_R_System.MACAddresses from SMS_R_System where SMS_R_System.MACAddresses = ##PRM:SMS_R_System.MACAddresses## order by SMS_R_System.MACAddresses More Queries Our full range of SQL and … Read more
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 this one below. All you need to do is change the demo OU below to your own required OU. Organisational Unit TECHYGEEKSHOME/LAB/COMPUTERS/WINDOWS 10 Query Script SELECT distinct * FROM SMS_R_System … Read more
We are pleased to announce the release of our RemoveIE software in an MSI format. This will allow you to distribute the application to a large number of computers using tools such as Group Policy or SCCM. The MSI program is a free download and this does allow you to distribute the software within your … Read more
If you are trying to run a Powershell script, you may find sometimes that you get this following error message: Cannot be loaded because the execution of scripts is disabled on this system. There is a very simple fix for this, all you have to do is ensure that you run your Powershell program as … Read more
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 different information and also use it to create a report using SSRS. This query by default brings back the following information: Query More Queries Our full range of SQL and … Read more
