Get WMI Query v1.6 Released
A free utility to get the WMI information from a computer. This is a great tool for SCCM administrators.
A free utility to get the WMI information from a computer. This is a great tool for SCCM administrators.
If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SQL data and SSRS to produce the reports. The best way to start to create a custom report is to ensure that you get your SQL query correct first. We have written hundreds of…
We have recently been tasked with fixing a problem with Configuration Manager 2012 SP1 and deploying a fat Windows XP wim image to a Dell Latitude E5510 with the newer generation of Intel processors, in this case the processor was an Intel i3 Processor. The problem was this, the customer had a fat Windows XP…
If you are building a Configuration Manager 2012 server there are a number of pre-requisites that have to be installed for it to work correctly. It can be quite time consuming installing all of the server features that are required so to help with this process, you can run Powershell cmdlets that will take care…
If you are using Configuration Manager 2012 for Operating System Deployment (OSD) – which is one of the main functions of the system so we will assume that you are – then you may want to monitor the process of your task sequences. To do this, you should go into your Configuration Manager Console and…
An excellent tool to use alongside Configuration Manager is SCCM Client Center Tool. We have been using it for years and it also makes a great tool to hand out to helpdesk staff if you do not want them to have access to the full Configuration Manager Console. The tool has many functions but the…
UPDATE: Windows 7 Lock Screen Changer Utility now released! ======================================================================== We have recently been looking into corporate branding for Configuration Manager 2012 Operating System Deployments and we came across an interesting guide about automatically changing your users icon picture and background lock screen in both Windows 7 and Windows 8. We thought this was an…
Introduction If you are trying to use any remote tools like sysinternals against Windows Vista, 7 or 8.1 machines then you need to have remote UAC elevation privileges to enable you to carry out changes on the machine you are trying to amend. However, you may find that you are still having problems with connecting…
This is a SQL query for your SCCM database or you can use it to create a report using SSRS. For this work, you must ensure that you have the Logical Disk class enabled in the hardware inventory settings. This will give you the following information: Computer Name Disk Description Drive Letter Volume Name File…
This guide will show you how to extract the MSI and CAB files from the Java offline installer so that you can then successfully distribute them using ConfigMgr, WSUS, WDS or Group Policy. First of all, you should download the latest version of the offline Java installer from the link below: Download Download Java MSI…
Java have now released update 51 of version 7 of their Java Client software. The update is available as an offline installer and using our guide below, you can extract the MSI from it and use it for deployment by using Windows Updates to update current machines or add to your Configuration Manager Application Catalog…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
This is a query for ConfigMgr 2012 and it will return the machines that do not have the 2012 client installed on them. This is useful if you have gone through an upgrade from 2007 to 2012 and need to know if or where machines have not fully upgraded themselves so that you can take…
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: Server Name Server Make Server Model Server Operating System…
Most users in organisations believe that Google Earth is a great tool for their work and freely install it on their work machines and think nothing of it. Well, Google Earth is NOT free for commercial use and if business users want to use Google Earth for work purposes on work machines, then a licence…