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 the collection properties ,i found empty there (No direct or query based rule). So i decided to write SQL query to identify the list of…