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
Hi Venu,
ReplyDeleteAt 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
Thanks,
Roy
Hi Roy,
ReplyDeleteFollow 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.