Quantcast
Enhansoft: Enhancing your business.
Warranty Information Reporting Online Demo

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.

Do you like these reports? Tell us about it on FACEBOOK, and tell a friend by TWEETING about it!

License 01A - Microsoft license ledger for Microsoft License Statements

  • Fixed prompts
  • Allowed “all” channel codes to be viewed
  • Set default “ – All - ” as default for channel codes prompt
  • Removed CollectionID from table
  • Added collection name to header
  • Updated font to fix overlapping issue
  • Adjusted column widths to make the report more readable
  • Removed extra datasource for MPLA link
  • Changed the second query set to static text
  • Added drill-through to MPLA URL
  • Changed page size to 8.5 x 11
  • Adjusted margins by a ¼ inch left and right
  • 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 easier readability

Count operating system versions

  • Added chart with drill-through
  • Added color matching between the chart and table
  • 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

Count operating systems and service packs

  • 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

Software 06A - Search for installed software

  • Fixed prompt
  • Fixed prompt text
  • Very minimal changes to SQL to allow for it to work within the 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 easier readability

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

Scan 2 - Last scan states by site

  • 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 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

Scan 3 - Clients of a collection reporting a specific state <secondary>

  • Cleaned up prompt queries
  • Fixed prompt text
  • Added border on both tables
  • Adjusted some of the column sizes to better mimic the ASP version of this report
  • 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

Scan 4 - Clients of a site reporting a specific state <secondary>

  • Cleaned up prompt queries
  • Fixed prompt text
  • Added border on both tables
  • Adjusted some of the column sizes to better mimic the ASP version of this report
  • 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

 

Compliance details for a configuration baseline by configuration item

  • Cleaned up prompt queries
  • Fixed prompt text
  • Added border on table
  • Adjusted some of the column sizes to better mimic the ASP version of this report
  • 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 a specific operating system and service pack

  • Fixed service pack prompt to allow for all RTM versions to be selected
  • Fixed service pack prompt to allow for ALL versions to be selected
  • 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

 

History - Specific task sequence advertisements run on a specific computer

  • Fixed column widths to make report more readable, particularly the Action Output column
  • Changed sort order to be descending by Execution Time and Last Step, thereby making the report more usable
  • Fixed conversion error within SQL
  • 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 a specific product name and version

  • Fixed column widths to make the report more readable
  • Fixed prompts
  • Fixed prompt text
  • Added defaults to each 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 easier readability

Compliance details for a configuration baseline for a specified computer

  • Fixed column widths to make the report more readable
  • Fixed prompts
  • 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 easier readability

 Hardware 09A - Search for computers

  • Fixed column widths to make the report more readable
  • Fixed prompts
  • Fixed prompt text
  • Added defaults to each 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 easier readability

Management 1 - Updates required but not deployed

  • Fixed column widths to make the report more readable
  • Fixed prompts to allow for reduced query overhead
  • Fixed prompt text
  • Set prompt default to All Classification and All Vendors
  • Added drill down on information URL
  • Removed the conversion from string to integer
  • Very minimal changes to SQL to allow for it to work within SQL BI tool
  • Updated header
  • Updated footer to move page number
  • 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
Enhancing your Business
 

Choose the appropriate report from the list below:

 

License 01A - Microsoft license ledger for Microsoft License Statements
Count operating system versions
Count operating systems and service packs
Software 06A - Search for installed software
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
Scan 2 - Last scan states by site
Scan 3 - Clients of a collection reporting a specific state
Scan 4 - Clients of a site reporting a specific state secondary
Compliance details for a configuration baseline by configuration item
Computers with a specific operating system and service pack
History - Specific task sequence advertisements run on a specific computer
Computers with a specific product name and version
Compliance details for a configuration baseline for a specified computer
Management 1 - Updates required but not deployed
Free SSRS Report