Configmgr SQL query to get the list of clients that require a specific software update patch

This is quick blog post about getting the list of clients that require a specific software update contained (it can be based on title,article ID(KB),bulletin ID). You can get the client list using the default software update compliance reports but it doesn't give you the inventory information about client ,like ip address,hardware scan,software update scan…
SCCM Configmgr Get count of software updates with its severity (Critical,Important,Moderate and Low)

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 this information count of updates with severity, you first need to identify what the SQL views that store this information about software updates. Get the…
SCCM Configmgr How to get clients maintenance window with custom dates (Past and Future )

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 the Maintenance window: Software update deployments Compliance settings deployment and evaluation Operating system deployments Task sequence deployments More about MW https://technet.microsoft.com/en-us/library/hh508762.aspx?f=255&MSPPError=-2147217396 Problem: So ,If you…
SCCM Configmgr check if allow clients to use fallback source location for content is selected or not

  Have seen couple of times on SCCM Configmgr forums asking for ‘How to get applications /deployment types that has allow clients to use fallback source location for content ’ is checked or not. Allow fallback source location for content: This feature is designed to allow client to gain access (fallback) to content that is…