Windows 8 Start Menu Button – Just like Windows 7!

We hear a lot of people complaining about Windows 8 since Microsoft launched their new flagship operating system. Stupid touchpad operation, stupid charms, stupid start screen and stupid apps are all common complaints of Windows 8. The problem is, if you buy a new computer, the chances are that the OEM operating system on it is going to be Windows …

Windows 8 Start Menu Button – Just like Windows 7! Read More

Query for all machines with SQL installed using Installed Software

If you wish to run a SQL query against your SCCM database to find all machines with SQL installed, then you can use this SQL query below: More SQL 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 if you would like us to create …

Query for all machines with SQL installed using Installed Software Read More

SCCM – WQL Query for machines without Endpoint Protection installed

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 post, or if you would …

SCCM – WQL Query for machines without Endpoint Protection installed Read More

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

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 the where value of 4096000 …

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

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

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 all the passwords we could …

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

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

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 that is soon to end …

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