SCCM Configmgr CB 1802 SQL Views documentation
With the release of SCCM Configmgr current branch 1802 ,there are some exciting features added from its previous version 1710. When there are new features released ,certainly there will…
Category: SQL Queries
SQL query to get client count with status active obsolete missing for collections in tabular column
Quick blog post on how to get client count with active obsolete and missing status for collections in a nice tabular column. I used 3 SQL views in this…
SCCM Configmgr Technical Preview 1802 available
On this Valentine day (Feb 14,2018 ), Microsoft released Feb 2018 Technical preview version 1802 for Configuration Manager with large number of features (21) that ever released before. These…
SCCM Report for Missing Boundaries and Troubleshooting
Introduction: Boundaries for SCCM define network locations on your intranet that can contain devices that you want to manage. Boundary groups are logical groups of boundaries that you configure.…
Configmgr Report list empty collections with no query rules defined (collection clean-up)
I was looking at the console other day and found that, there were many collections created in the root folder (device collection) with 0 count. So i looked at…
Configmgr How use compliance settings to check windows update agent version (WUA) is older ,Collection and SQL query
Using compliance settings in Configmgr, you can do many tasks as part of compliance. In the last couple of blogs, we have utilized compliance settings to identify WU settings,automatic update,trusted…
Configmgr report for count of MS office versions with architecture type 32bit and 64bit
This blog post is going to be version 3 on the same topic (report for MS office versions) but with different requirements.My previous posts on ssrs report for count of…
ConfigMgr How to use Compliance Settings to check the windows update policy settings like WUServer, UseWUServer,NoAutoUpdate on clients
When you install configuration manager client to manage any windows device ,it will try to configure local group policy to set WSUS server settings (unless you have no GPO…