Quantcast
Enhansoft: Enhancing your business.

SCCM 2007 Conversion Tools for ASP Reports

When converting the native Microsoft SCCM 2007 ASP reports to SQL Server Reporting Services (SSRS) reports a few of them don’t convert correctly. Enhansoft has corrected this problem in native Microsoft SCCM 2007 reports for SSRS, which we know have issues.  Keep checking back to this webpage to find other reports that we have fixed.  Please enjoy these free reports!

Software 01A - Summary of installed software in a specific collection

  • Fixed Prompts to allow for all Publishers to be selected
  • Fixed Prompt text
  • Set Default “ All Publishers” as default forpublisher prompt
  • 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

Software 02D - Computers with a specific software product

  • Fixed Prompts to allow for Null items
  • Fixed Prompt text
  • Set Default “Null” as default for all prompts except for Collection
  • 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 readability

Compliance 6 - Specific computer

  • Fixed Prompt to allow for all Vendors to be selected
  • Fixed Prompt to allow for all Classification to be selected
  • Cleaned up Prompt query to Select PCs
  • Fixed Prompt text
  • Set default prompt selection for Classification (“All Classification”)
  • Set default prompt selection for Vendors (“All Companies”)
  • Adjusted some of the column sizes, to better mimic the ASP version of this report.
  • Adjusted some column headers to be vertical to match column width.
  • Allowed for the URL session of the report to go to the KB article
  • 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

Computers with compliance evaluation failures for a specific configuration baseline

  • Fixed Prompt
  • Fixed Prompt text
  • 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

Chart - Hourly advertisement completion status

  • Added Chart
  • Centered Table
  • Fixed Prompt
  • Fixed Prompt text
  • Very minimal changes to SQL to allow for it to work within SQL BI tool
  • Filtered out "0" results within SQL
  • 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 readability
Enhancing your Business
 

Choose the appropriate report from the list below:

 
Software 01A - Summary of installed software in a specific collection
Software 02D - Computers with a specific software product
Compliance 6 - Specific computer
Computers with compliance evaluation failures for a specific configuration baseline
Chart - Hourly advertisement completion status