How to Query Clients collection or SSRS with Online Status in SCCM Configmgr 1602

  Microsoft has introduced new feature in System Center Configuration manager Build Version 1602  called Client Online Status .This is really cool and exciting feature which is really needed these days to know if the computer is online or offline (of course ,SCCM agent must be working and healthy which is different story). A new…
SCCM Configmgr SQL Report get list of machines with one Version of application and exclude other versions

I had requirement from team to find out the clients that have one application (example Java) with one version installed and exclude clients that have multiple versions with same application installed. Lets take simple example . I have clients CLN01,CLN02,CLN03 and CLN04 and they have different versions of Java application installed on them. PC Name…
SCCM collection Subselected Queries

Have seen lot of questions on how to get list of computers that do not have xxxxxx .This xxxx could be of anything like softwares,file names anything that do not have. In this post,I will go through step by step procedure how to make it simple. Step 1: To get list of computers that do…