SQL Queries | Eswar Koneti Blog

How to check who executed SCCM Configmgr reports for auditing or troubleshooting purpose

Posted on September 6, 2017 by Eswar Koneti | 0 Comments

If you want to know who executed (number of times ) the Configuration manager reports (or any other SSSRS reports) or if anyone compliant that some of the Configmgr reports…

SCCM Configmgr Software Update Compliance Report for Specific Collection within Specific Time Frame

Posted on July 20, 2017 by Eswar Koneti | 5 Comments

In this post, i will discuss about the requirement that i have got recently. Local team /manager wants to run the software update compliance report for their LBU machines (collections)…

SCCM Configmgr Get count of software updates with its severity (Critical,Important,Moderate and Low)

Posted on July 18, 2017 by Eswar Koneti | 0 Comments

Quick post on how to get count of list of updates or count of updates in your Configuration Manager with severity categorised as Critical,Important,Moderate and Low. In order to get…

SCCM SSRS The report parameter has a default value or valid value that depends on the report parameter UserSIDs.Forward dependencies are not valid

Posted on May 4, 2017 by Eswar Koneti | 2 Comments

Other day,I was trying to create my first SCCM Configmgr SSRS report with RBA (role based administration) what it means is ,data for all reports included with Configuration Manager…

SCCM Configmgr SQL WQL query compare 2 or more collections to get the difference

Posted on March 22, 2017 by Eswar Koneti | 0 Comments

This is quick post to show you ,how to compare 2 or more collections to find clients that are not member of other collections. The reason for me to write…

SCCM Configmgr report for local admins and local group members

Posted on March 9, 2017 by Eswar Koneti | 15 Comments

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…

How to find and update DNS server search order using SCCM Configmgr

Posted on February 13, 2017 by Eswar Koneti | 1 Comment

If you are using SCCM Configmgr in your environment, you can accomplish lot manual /administrative tasks using Configmgr using deployment/compliance method. Recently I was working on task to update…

SCCM Configmgr How to get clients maintenance window with custom dates (Past and Future )

Posted on January 24, 2017 by Eswar Koneti | 2 Comments

Introduction: Maintenance windows in Configmgr help to ensure that client configuration changes occur during periods that do not affect the productivity of the organization. Following Operations can be performed during…