Sql Queries | Eswar Koneti Blog

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

Posted on July 20, 2017 by Eswar Koneti | 3 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…

Category: SQL Queries

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

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

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

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

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

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

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