SCCM - Data Reporting and Analysis

Just curious if any of you have written SQL against an SCCM database. I used to get access to views and do my queries there, but I was wondering if there was an IDE within in SCCM to write SQL?

I've seen views built out on the presentation layer almost like a Universe in BOXI.

Any information would be greatly appreciated.

Find more posts tagged with

SAVE $250 on Your Boot Camp — Use Code "EXAM26"

Exclusively for TechExams members for Infosec Boot Camps starting before April 30, 2026

View Boot Camps

Comments

NotHackingYou

I would probably just hook up SSMS to the SCCM database. I would take the actions in the SCCM UI that I wanted to emulate while profiling the SCCM database and reverse engineer the queries to extract the data I care about.

N2IT

CarlSaiyed wrote: »

I would probably just hook up SSMS to the SCCM database. I would take the actions in the SCCM UI that I wanted to emulate while profiling the SCCM database and reverse engineer the queries to extract the data I care about.

Thanks - I think I'll push for an string connection into the database. I agree I would rather have the full scope of SSMS than some cheesy IDE. Although if it does shows dependancies etc it could be helpful. Thanks for the follow up.