Category: WQL Quiries

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

Posted on April 19, 2016 by | 13 Comments | 20,860 Views
  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…
Read more »
SCCM Configmgr 2012 SSRS Report Content Status with Compliance – Console View

Posted on November 23, 2015 by | 2 Comments | 1,448 Views
This post is an extension to my previous article to view the content status for the applications,packages,driver packages,software updates,windows images using SSRS report instead of Console. Few people contacted me ,if there is way to get the status /Report of all packages on all Distribution points with its compliance % and other information what is…
Read more »
SCCM Configmgr 2012 Create device collection using the User Department attribute

Posted on November 17, 2015 by | 5 Comments | 4,575 Views
  Recently ,I have got a request from the business unit manager on the reboot of computers due to patch management (applicable to Applications as well) .The Custom client device setting ‘ Display temporary notification to the user ' (shown below) set with 480 minutes across the enterprise workstations but specific department (ex: Engineering), not…
Read more »
SCCM 2012 Collection SSRS report with No SEP client or SEP Client is older version

Posted on October 10, 2015 by | 0 Comments | 4,141 Views
Rolled out new Symantec endpoint Protection (SEP) Version to clients across all the sites. After few days ,report (All application deployment –Basic)  says ,around 100+ computers still running on old version which did not upgraded to deployed version.Out of these 100+ clients,some of them already have deployed version if I check via resource explorer (also…
Read more »
How to Upgrade Clients to SCCM 2012 R2 CU4

Posted on March 10, 2015 by | 4 Comments | 784 Views
It has been almost month for now ,since the release of Configmgr 2012 R2 CU4.To know more about what CU4 includes,you can refer the KB3026739 article http://support.microsoft.com/kb/3026739. Installation of Configmgr 2014 CU4 is similar to installation of previous Cumulative updates and it is straight forward. If you miss to install the Previous Cumulative updates,you can…
Read more »