Yearly Archives: 2014

SCCM – WQL Query for machines without Endpoint Protection installed

By | July 15, 2023

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 you can use the following 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… Read More »

SCCM – WQL Query for machines with 4GB RAM or more

By | March 30, 2023

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 distinct SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.DistinguishedName from SMS_R_System inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId where SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory >= 4096000 order by SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.DistinguishedName You can change… Read More »

Microsoft Evaluation VHD’s – Windows Server 2012 Contoso Administrator Password

By | August 6, 2023

Although most people will be using full versions of Windows Server 2012 products by now, some may still use the evaluation VHDs from Microsoft. We have just downloaded all 11GB of VHD files from Microsoft for doing some testing and got to the point where we need to enter the Contoso Administrator password. After trying… Read More »

Adobe Reader 11 MSI & Update 11.0.06 MSP Downloads

By | April 1, 2023

Adobe have now released update 11.0.06 for their Adobe Reader XI software. This is available to push out as a windows update using System Center Updates Publisher (SCUP) and WSUS or Configuration Manager. However, if you want to download the MSI and MSP for distribution using the Software Catalog, WDS or Group Policy, the links… Read More »

Skype 6.11 MSI Released

By | April 1, 2023

Skype have now released version 6.11 and have also made public a download location for the MSI.  This is excellent news for those that wish to deploy Skype through Group Policy, SCCM or WDS so if you have been waiting for this, the link is below:  Skype Latest Version MSI Download Link Free Subscription If… Read More »

Microsoft will remove Security Essentials (MSE) for Windows XP in April 2014 – Download NOW!

By | March 30, 2023

If you have Windows XP, or if like me, you have to rebuild many friends and family members old computers, then you will probably be aware of Microsoft Security Essentials – the free Microsoft security program. Microsoft have provided this free of charge to Windows XP and Windows 7 users for some time now but… Read More »

SCCM – WQL Query for devices with specific software installed

By | March 30, 2023

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 »

SCCM 2012 – Newly discovered machines in the last 24 hours

By | March 30, 2023

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 »

Report on Dell Warranty Statuses for all machines using SCCM & Dell Client Integration Pack

By | March 30, 2023

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 »

SCCM – WQL Query for machines with a valid Hardware Scan in the last x days

By | March 30, 2023

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 »

SCCM – WQL Query for MAC Address Prompt

By | March 30, 2023

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 »

SCCM – Query for devices in a specific Active Directory Organisational Unit (OU)

By | March 30, 2023

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 »

Remove IE MSI

By | July 10, 2023

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 »