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.
I've seen views built out on the presentation layer almost like a Universe in BOXI.
Any information would be greatly appreciated.
Comments
-
NotHackingYou
Member Posts: 1,460 ■■■■■■■■□□
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.When you go the extra mile, there's no traffic. -
N2IT
Inactive Imported Users Posts: 7,483 ■■■■■■■■■■
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.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.