SCCM 2012 SQL Views
To get SCCM 2012 SQL views , please try below query. I think, this is handy particularly when you upgrade SCCM infrastructure and new reports are added to the release.
SELECT DISTINCT TOP (100) PERCENT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME LIKE 'v_%')
ORDER BY TABLE_NAME
Run the report, save in excel and use pivot for ease of use.
Thanks
