SCCM 2007 Conversion Tool for ASP Report, Scan 2 – Last Scan States by Site


When converting native Microsoft SCCM 2007 ASP reports to SSRS reports a few of them don’t convert correctly. Enhansoft has corrected this issue in reports where we know this problem exists.
The latest free conversion tool that you can download from our website is for:
Scan 2 – Last scan states by site
What we did:

  • Fixed Prompt to allow for Data from All Sites to be selected
  • Cleaned up Prompt queries
  • Fixed Prompt text
  • Set default prompt selection for Sites (“All Sites”)
  • Adjusted alternating table colors to better highlight data
  • Added border on both tables
  • Adjusted some of the column sizes to better mimic the ASP version of this report
  • Changed the page size to 8.5 X 11
  • Very minimal changes to SQL to allow for it to work within SQL BI tool
  • Updated header
  • 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 readability

Leave a Comment

Share via
Copy link