Sql Queries | Eswar Koneti Blog

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 | 11 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…

SCCM Configmgr How to get list of deployments set to OverrideServiceWindows and RebootOutsideOfServiceWindows

Posted on January 3, 2017 by Eswar Koneti | 3 Comments

Introduction: Few months ago ,we had an issue with one of the deployment (it was software updates) that was deployed to collection with override service window due to emergency patch…

SCCM Configmgr how to find applications with no deployments as part of maintenance tasks

Posted on December 21, 2016 by Eswar Koneti | 6 Comments

Introduction: One of my blog reader asked question about ‘There is report in your blog to find out packages that has no advertisements created,but is there similar report to…

How to find who initiated restart of SCCM Configmgr Client

Posted on November 1, 2016 by Eswar Koneti | 10 Comments

Colleague of mine has received request to check why did the SCCM client (server OS) rebooted during office hours and more details about the reboot (who initiated etc.). I…