Understanding SCCM SQL Views
The Configuration Manager 2012 / Current Branch come with many built in reports which are sufficient for day to day requirements. However, you still have to deal with SQL query to pull custom details directly from SCCM database based on requirement. As an SCCM administrator you must have good understanding of SQL query in order order to pull these information from SCCM database directly. One of the key requirement here is to have understanding of SCCM DB schema. Once you know which information are stored in which SQL view, you can easily write a SQL query to pull out information. Know SCCM SQL Views: The SCCM SQL View v_SchemaViews contain the details of all views. You can use below SQL query to get a list of all views. Select * from v_SchemaViews Since, SCCM creates one separate view for each collection, the list will be quite long. You can filter the result by excluding Collection views from query. Select * from v_SchemaViews where Type <> 'Collection'