ConfigMgr Admin Tips | List of Views Tables Functions IP Address Views information by Karthick | SQL Query Tips | SCCM

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%'

Resources

• SCCM Patching Basics Video Recording Available Now | ConfigMgr
• SCCM SSRS Custom Report Creation with Graphs by Kannan 👉SQL Query Tips ✌ How to Find SCCM Views Ep #11