System Center

SCCM – Create a device collection based on Exchange Server role

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 […]

System Center

Java 8 Update 161 MSI Installers and Offline Installers for x86 and x64 Browsers Released

We have now uploaded to our Filestore microsite the MSI installers and Offline Installers for the latest Java version release. The versions that have been added are: Java 8 Update 161 x86 MSI Installer Java 8 Update 161 x64 MSI Installer Java 8 Update 161 x86 Offline Installer Java 8 Update 161 x64 Offline Installer […]

System Center

SCCM – Hardware and Client Version SQL Query

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, […]

News

Happy New Year 2018!

We would like to wish all of our visitors a very Happy New Year. 2017 was a great year for us and we hope that 2018 will be happy and prosperous for you all. Happy New Year! Free Subscription If you want to be notified when we post more quality guides like this one, sign […]