All articles about Microsoft System Center range of products.
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…
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…
We have recently come across an excellent Powershell tool which identifies and installs all prerequisites for Configuration Manager 2012 R2 installations. Take a look at the website below for further information: ConfigMgr 2012 R2 – Prerequisites installation tool
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…
If you want to identify machines with Google Earth software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query. This WQL query can then be used as part of an import function to create a device collection within SCCM. More Queries Our full range of SQL and WQL…
I know this is a bit late but Microsoft have released a hot fix for Endpoint Protection clients. The knowledge base article is KB2907566 and can be found from the link below. Knowledge Base Article 2907566 Affected Products Microsoft System Center 2012 R2 Configuration Manager Endpoint Protection clients Microsoft System Center 2012 Configuration Manager Endpoint…
We recently had a problem involving Java 7 update 55 where when added to the software catalog, users were getting the error messages as below upon installation: “Neither command line parameter specified is an existing directory.” We did some research and found out that the installer that we were using was not correct for standalone…
Sorry but we have been forced to remove this page as NitroPDF believe that we are giving out serial numbers illegally. Although this is just a tutorial for how to gather your OWN PAID FOR serial numbers using SCCM, it seems this is not good enough for NitroPDF or Google. So, we have had to…
As a follow on to our previous post about using SCCM to collection Autodesk serial number information, we mentioned that we also had the ability to use this same function to collect serial number information for PDF-X Change. If you use exactly the same process as in the Autodesk guide, but using the below text…
In the past we have released SCCM Configuration Item VBScripts to collect Autodesk serial numbers and then inject this information in to the WMI to be collected by the next hardware inventory. After much researching and testing, we have now made a decision that this is not the best way to collect this source of…
You may sometimes come across Configuration Manager clients that are not working correctly. The tell-tale signs for this on a client machine are missing tabs, missing selections under the Actions tab and incorrect or missing information on the General tab. In short, your Configuration Manager Control Panel applet may look like below: I have had…
We have made some major updates to our Autodesk products serial number reporting script which should fix all of the reporting issues that some people have seen. It also includes a large amount of additional languages and products. WHAT PRODUCTS ARE INCLUDED? The list of Autodesk products that this Configuration Item script will now report…
I manage a SCCM environment where it was required to have the option to remove Internet Explorer 10 using the Software Catalog. This was due to a number of legacy web based systems not working with IE10 and was to get the end user the ability to remove it if required without the assistance of…
If you have a requirement to add Project, Visio or Office as an application in your SCCM environment so that your users can install it via the Software Catalog, this is a pretty easy thing to do. However, I’ve seen a lot of people recently not fully setting up the application correctly and either leaving…
If you need to create standalone media for any of your task sequences within SCCM, you may find that you have to use a large capacity memory stick. I have found that when I’ve tried to use a 64GB memory stick or above, the Create Stand Alone Media process always fails. So to get round…
UPDATE: Get WMI Query v1.5 is now available – click the Downloads button to obtain ================================================================ We are pleased to announce the release of Get WMI Query v1.4 This is an update to the previous release and now includes a drop down list consisting of Model and Manufacturer. We are working on further releases of this program…
We have now set ourselves up on various social media sites to send out our latest post updates quickly and easily. You can now follow us on Twitter, add us as a friend on Facebook or join our circle on Google+. The links to our social media sites are below:
If you are using PDF-XChange Pro and you wish to run a silent installation or add it as an application for your Software Catalog in SCCM, you can use the settings as below: SILENT INSTALL For a standard silent install, the command line is: PDFX3.exe /VERYSILENT /NORESTART /Key:”xxxxx-xxxxx-xxxxx-xxxxx-xxxxx-xxxxx” /UserName:”techygeekshome” /Organization:”techygeekshome” /UserEmail:”techygeeks@outlook.com” All you have to…
UPDATE: Get WMI Query v1.6 is now available – click the Downloads above to grab it now ====================================================================================================== We are pleased to announce the release of Get WMI Query v1.3. This program is designed to help in a SCCM environment where there is a need to provide a multiple set of drivers to a task sequence during…
If you have MDT integrated in your Configuration Manager 2012 environment, then you will notice that when you use a console on your CM server everything works fine. However, if you have a console installed on a client machine, then you may see this error when trying to view or edit a MDT task sequence…
