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

by leaston 27. June 2012 19:59

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: info@enhansoft.com

Tags:

Announcement | ConfigMgr | SCCM | SSRS | System Center Configuration Manager

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed
Comments are closed

Powered by BlogEngine.NET 1.6.0.0


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.

Our software solutions found in the Enhanced Asset Management Suite – EAM: Warranty Information Reporting - WIR, Monitor Information Reporting - MIR & Enhanced Web Reporting - EWR, will quickly and accurately report on your:

  • PC (laptop, notebook, desktop & server) warranties
  • PC monitor information
  • Enable you to use over 100 different SQL Server Reporting Services (SSRS) ranging from hardware, software and dashboard categories, to keep track of and effectively display even more detailed information about your IT assets.

Enhansoft aims to make tracking the life cycle of each IT asset on the network as easy and efficient as possible.

Be more efficient.   Be more accurate.  Enhansoft.

 

Tag cloud