In-depth guides for Microsoft System Center products including SCCM/ConfigMgr, SCOM, SCVMM, and Orchestrator. Written for IT professionals.
Following on from our recent posts for Configuration Manager collection queries, we have another one here for all devices that are Microsoft Exchange servers. Go ahead and create a new device collection and then use this query: select * from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.Name like “Microsoft Exchange%” Save the … Read more
We have another WQL query here for you today to enable you to create a Configuration Manager collection based on whether a device is used as a domain controller. Go ahead and create a new device collection and then use this query: Save the query and you should now see a collection of all your … Read more
If you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information together. SELECT S.Name0 as Name, S.Client_Version0 as [Cient Version], OS.Caption0 as [Operating System], CS.Manufacturer0 as Manufacturer, CS.Model0 as Model, PB.SMBIOSBIOSVersion0 as BIOS, PR.Name0 as CPU, … Read more
If you are looking for an SCCM SQL query to create a report to search for machines which do not have a particular software installed, you can use the following: Then you can use the variable @displayname to choose from a drop down of software that is in the SCCM database pulled from client machines. … Read more
We had seen a few posts around the internet where people are asking the differences between the various Add_Remove_Programs data within the System Center Configuration Manager database. So we thought we would post a quick reference here to confirm which table of data means what. There are five different tables of data available to you … Read more
If you have been using System Center Endpoint Protection and you now want to move away from it, you will need to carry out an uninstall of the software. This can be very easily carried out either through a manual process of uninstalling using the Programs and Features within the Windows Control Panel or if … Read more
Some time ago there was a bug within SCCM where when you deployed an application, you had to change the deployment date back a day to make it work. This seemed to have been fixed when moving over to current branch but this issue has raised it’s head again. This will cause clients trying to … Read more
When using System Center Service Manager (SCSM) you can sometimes end up with Incidents, Change Management items or Service Requests that need to be deleted individually. You an carry this out by using a combination of SMLets and PowerShell. INSTRUCTIONS The first thing you will need to do is to download and install SMLets on your … Read more
If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SCCM SQL data and SSRS to produce the reports. The best way to start creating a custom report is to ensure that you get your SQL query correct first. We have written hundreds of … Read more
This is a quick reference guide to the Chassis Type values that are pulled from machine when using SCCM. 1 = ‘Other’ 2 = ‘Unknown’ 3 = ‘Desktop’ 4 = ‘Low Profile Desktop’ 5 = ‘Pizza Box’ 6 = ‘Mini Tower’ 7 = ‘Tower’ 8 = ‘Portable’ 9 = ‘Laptop’ 10 = ‘Notebook’ 11 = … Read more
When you create a new System Center Orchestrator Runbook and you have checked it in ready to use, you may not see it in systems that will want to use it, like Configuration Manager, Microsoft Deployment Toolkit or Service Manager. This is due to authorisation cache not updating and as so, not showing the newly … Read more
If you are using System Center Operations Manager (SCOM) then you may have Management Packs in your system that you may longer want – especially if, like me, you go and add as many as you can in blissful ignorance expecting to get lots of tasty data. Then realising that this is a terrible idea … Read more