Finding Supported SCCM SQL Views​

  • Post author:
  • Post Category:SCCM
  • Post Comments:0 Comments

I hate using random SQL Queries off the internet without understanding what the query is doing.  One reason why it is dangerous to use a random queries off the internet…

Continue Reading Finding Supported SCCM SQL Views​

SCCM Collection SQL Views

  • Post author:
  • Post Category:SCCM
  • Post Comments:0 Comments

There are two types of Collection Views in SCCM. Collection Membership Views Collection Property Views Collection View Description v_ClientCollectionMembers Lists all devices, by resource ID, that are not in an…

Continue Reading SCCM Collection SQL Views

Collection Membership Query

  • Post author:
  • Post Category:SCCM
  • Post Comments:0 Comments

If you are ever in a situation where you do not have Roger Zanders Right-click tools and you want to track down what collections a device is a member of,…

Continue Reading Collection Membership Query