< Blog

How can I create a report using a SQL query provided (Classic ASP report)

How can I create a report using a SQL query provided by Enhansoft or that I find on a blog. (Like the personal blog of Garth Jones, the Chief Architect of Enhansoft.)

· Within the ConfigMgr Console, Browse to Site Database | Computer Management | Reporting | Reports

· In the left pane, right click the Reports node

· Point to New

· Click Report

clip_image002

· In the New Report Wizard, fill in details for:

o Report name

o Category

clip_image004

· Click Edit SQL statement…

· Remove contents of the SQL statement: text box

· Paste the query provided into the SQL Statement:

· Click OK

clip_image006

· On the Display window, click Next >

· On the Links window, click Next >

· On the Security window, click Next >

· On the Wizard Complete window, click Close