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

  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 is filtered based on the permissions of the administrative user who runs the report. Administrative users with specific roles can only view information defined for…
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…
SCCM Configmgr How to get list of deployments set to OverrideServiceWindows and RebootOutsideOfServiceWindows

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 to be installed on the clients. Deployment went fine and results were positive .All good ,but after few days ,some clients were added to the…
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…
SCCM Configmgr SQL query to find Top X missing updates for specific collection for specific update group

Since few days ,I am working on a customized Software update compliance dashboard report with some Pie charts for management to see how the patch compliance progress for each Business Unit (I say business unit means for each country). Management are interested to see the overall patch compliance summary for each country (focused on servers…
Download SCCM Configmgr CB 1606 SQL views documentation

Microsoft released new version of SCCM Configmgr Current Branch 1606 (YY MM) with lot of new features and improvements to the existing features. You can install this update via in-console update. With this new update ,there are also couple of newly added SQL views compared to its previous update (1602) which will help us to…