This is the quick post to provide additional tips to ConfigMgr Admins (ConfigMgr Admin Tips) to find out the list of Views, Tables, Functions, and IP addresses view information. Special Thanks to Karthick for all the tips 👇👇!
All these points are discussed and demoed in the ConfigMgr SSRS Report Creation Process Explained by Kannan CS SQL Query Tips Tricks for Admins | Video.
List of Views Tables Functions for ConfigMgr
- This 👇 query shows what views and table-value functions are supported
select * from sys.all_objects select * from sys.all_objects where type = 'v'
- The Type will provide the detail information of each SQL information
Download Details of ConfigMgr 2002
Download Spreadsheet 👉👉https://github.com/AnoopCNair/SQL-sys.all_objects-SCCM-ConfigMgr
IP Address Views Information from SCCM
The following query will give you the the views which has IP address information related views from SCCM database.
select * from sys.views where name like '%IP%'
Boundary Related Views from SCCM ConfigMgr
select * from sys.views where name like '%boundary%'
Another tip – SQL Views ConfigMgr SCCM
select * from sys.views where name like '%client%' select * from sys.views where name like '%clienthealth%'