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'
ConfigMgr Admin Tips
List of Views Tables Functions for ConfigMgr – ConfigMgr Admin Tips
  • 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%'
IP address information related views from SCCM database. - ConfigMgr Admin Tips
IP address information related views from SCCM database. – ConfigMgr Admin Tips

Boundary Related Views from SCCM ConfigMgr

select * from sys.views where name like '%boundary%'
Boundary Related Views from SCCM ConfigMgr
Boundary Related Views from SCCM ConfigMgr

Another tip – SQL Views ConfigMgr SCCM

select * from sys.views where name like '%client%'
select * from sys.views where name like '%clienthealth%'

Resources

2 thoughts on “ConfigMgr Admin Tips | List of Views Tables Functions IP Address Views information by Karthick | SQL Query Tips | SCCM”

Leave a Comment