SCCM ConfigMgr report for local admins and local group members

I had a requirement to generate report to list members (users/groups) of local administrators group on servers for auditing purpose. Finding the users/groups who are member of  local administrator group manually or scripting is tedious task on all servers .If you are managing the devices with configuration manager ,you can leverage Configmgr tool to get…
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  2012 Collection SSRS report with No SEP client or SEP Client is older version

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…
SCCM Configmgr 2012 R2 Collections to Upgrade Clients to CU2 Version

few weeks Ago, Microsoft released Cumulative Update 2 (kb2970177) for Configuration manager 2012 R2 which supersedes previously released cumulative Update (1). This update fixes several issues ,supports to new platform for Unix/Linux and brings changes to Configmgr powershell cmd-lets as well. Download the Cumulative Update 2 from http://support.microsoft.com/kb/2970177 Description of Windows PowerShell changes in CU2…

If you are using User Device Affinity--associating a user with one or more specified devices  for application deployment to make sure the application install on all devices that are associated with that user,it is necessary to identify the computers which do not have primary User Defined.More about User Define Affinity http://technet.microsoft.com/en-us/library/gg699365.aspx. Create collection using below…

Long ago ,written SCCM report to list packages not used for 6 months as part of Package Archival process http://eskonr.com/2012/11/sccm-configmgr-package-archival-process-cleanup-activity/ .This report tells you to take further action to clean or move to Archive folder to wait for some more months before it goes for Deletion. What next ? Delete these packages from Assigned DPs…