Making IT Happen
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 MoreIf 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 MoreIf 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 MoreIf you are a Mimecast user and are also using Windows 8.1, you may find that when you have installed the Mimecast client for Outlook (MSO) and try to enter your domain or cloud credentials, the username has SMTP set and cannot be changed and the password part is greyed out. You will then receive the usual error message at …
Mimecast MSO Fix – SMTP in the Credentials Error Read MoreAlthough 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 MoreSkype 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
Skype 6.11 MSI Released Read MoreWe 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 over a few years, so …
System Center Orchestrator Integration Packs Read MoreIf 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 administration tools that Windows has …
God Mode for Windows Read MoreIf 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 MoreIf 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 example, we are using “Microsoft …
SCCM – WQL Query for devices with specific software installed Read MoreIf 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 value not hour value) to …
SCCM 2012 – Newly discovered machines in the last 24 hours Read MoreDell 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 all the warranty information into …
Report on Dell Warranty Statuses for all machines using SCCM & Dell Client Integration Pack Read More
