Share This Post

SCCM 2007 Conversion Tool for ASP Report: Count Operating Systems and Service Packs

Thank you to everyone who contacted us about native Microsoft SCCM 2007 ASP reports that don’t convert correctly to SSRS reports.

We were asked to fix Count operating systems and service packs, so this is the latest free conversion tool that you can download from our website.

What we did:

  • Added chart with drill-through
  • Fixed drill-through to work on the whole line and not just the first column
  • Added color matching between the chart and table
  • Updated the query to convert Service Packs with NULL data to ‘- RTM -‘
  • Very minimal changes to SQL to allow for it to work within SQL BI tool
  • Updated footer
  • Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation
  • Some SQL formatting to allow for easier readability

Remember to keep sending your suggestions to:

Share This Post

Enhansoft specializes in providing software solutions, custom reports, and consulting services for retrieving your IT asset inventory. This is done within the system management area focusing on Microsoft System Center Configuration Manager (SCCM) by extending its asset information and reporting capabilities. Enhansoft is a Bronze sponsor of

Leave a Reply