Friday, October 31, 2014

Get all the tables from SCCM database

The following query gives all the available tables (including custom hardware inventory classes).
Select distinct table_name,COLUMN_NAME From Information_Schema.columns
where table_name LIKE ('v_%')
Order by table_name

More SCCM custom reports can be found here


  1. Hi Venu,
    At what level do you run this query?
    Directly under SQL server Management studio on the DB of SCCM or in the query view under monitoring tab of the sccm console?
    In both cases, the query seems invalid.
    I run the SCCM 2012 R2 version


  2. Hi Roy,
    Follow same steps as to create a new report then run the report.
    That will give you all the available views from the DB.

    When you copy the above query please make sure that there are no special lines added.