A.J. Armstrong

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

17 February 202620 January 2014 by Andrew Armstrong

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

1 May 202618 January 2014 by Andrew Armstrong

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

System Center Orchestrator Integration Packs

24 August 202417 January 2014 by Andrew Armstrong

We have been using SCORCH for a while now and have acquired a number of Integration Packs. So, we thought we would zip them all up and add them to our site for you to download and use. Sorry but we cannot remember where most of them have come from as they have been gathered … Read more

God Mode for Windows

1 May 202616 January 2014 by Andrew Armstrong

If you wish to play God with your Windows operating system and have the ability to change virtually every setting on your machine in one easy to access window – then this little tool is for you. Simply download the installer, install on your Windows machine and you will gain full access to all the … Read more

SCCM – WQL Query for devices with specific software installed

17 February 202616 January 2014 by Andrew Armstrong

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

16 February 202515 January 2014 by Andrew Armstrong

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

1 May 202614 January 2014 by Andrew Armstrong

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

Windows 8.1 Dot.Net 3 Feature Enable using Operating System media offline

1 May 202613 January 2014 by Andrew Armstrong

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

How to add a custom static page to your blog and not adding it to your menu tabs – Google Blogger

1 May 202612 January 2014 by Andrew Armstrong

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

SCCM 2012 – WQL Query for Machines with less that 1GB RAM

16 February 202510 January 2014 by Andrew Armstrong

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

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

16 February 20259 January 2014 by Andrew Armstrong

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

17 February 20268 January 2014 by Andrew Armstrong

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