Even though we use Maik Koster’s MDT Web FrontEnd we still had some requirements to be able to run a quick report on referenced packages by a certain location, role, or MakeModel via the MDT database. Another requirement is the Package Name which the MDT Database does not include.
Therefore I created a quick and simple report that references both the MDT 2010 database and ConfigMgr’s database for Package name in order to display these results. I figured I would provide the MOF for this report for others to use/modify.
This report *does* use Linked Servers in order to access the MDT database. If you are not familiar with setting up a Linked Server in your SQL environment, check out these articles here first.
Once you have created a linked server, all you need to do is import this MOF as a report. Then edit the report and replace every piece of the report that has [192.168.1.120] with your linked server such as [MySQLBox]. This also includes the SQL statements in the prompts as well.
P.S. My linked server is an IP address as seen in the report because on my test network my MDT database and SCCM database are both on the same server. And you cannot create a link to the same server by name, so you must use something like an IP Address. Technically if they are both on the same server you could just create views in SQL to do this instead of linked servers, whatever you prefer.