ConfigMgr Site SSRS Reports

by Garth 30. July 2010 12:00

The reports within Enhanced Web Reporting (EWR) are grouped into categories; one such category is ConfigMgr Site. Like all other categories within EWR, this one has been updated to include SSRS reports.

SQL Reporting Services in System Center Configuration Manager 2007 R2 enables administrators to use the advanced reporting features of SSRS. Some of the advantages of using SSRS are:

· Report subscriptions allowing reports to be e-mailed on a schedule.

· Cleaner user interface

· Allows for reports to be exported to various file formats such as PDF and Excel.

· Allows for graphics and data to be intermixed within reports.

Reports within this category are:

· EWR - Last Collection of Update Times

· EWR - List of Advertisement Properties

· EWR - List of Objects Discovered in the past 7 Days by Discovery Method

To see samples of all the reports available, please see

· SSRS http://support.enhansoft.com/wiki/config%20mgr%20site%20-%20ssrs.ashx

· ASP http://support.enhansoft.com/wiki/configmgr%20site.ashx

Sample report from the ConfigMgr Site category:

clip_image001

Tags:

Announcement | ConfigMgr | Enhanced Web Reporting | EWR | SCCM | SSRS | System Center Configuration Manager

Computer System SSRS Reports

by Garth 29. July 2010 12:00

 

The reports within Enhanced Web Reporting (EWR) are grouped into categories; one such category is Computer System. Like all other categories within EWR, this one has been updated to include SSRS reports.

SQL Reporting Services in System Center Configuration Manager 2007 R2 enables administrators to use the advanced reporting features of SSRS. Some of the advantages of using SSRS are:

· Report subscriptions allowing reports to be e-mailed on a schedule.

· Cleaner user interface

· Allows for reports to be exported to various file formats such as PDF and Excel.

· Allows for graphics and data to be intermixed within reports.

Reports within this category are:

· EWR - Computer System Details

· EWR - Count of PCs By Chassis Bootup State

· EWR - Count of PCs By DST Enabled

· EWR - Count of PCs By Role

· EWR - Count of PCs By Thermal State

· EWR - Count of PCs By Wakeup Type

· EWR - List of PC Bootup State

· EWR - List of PCs by DST enabled State

· EWR - List of PCs by Role

· EWR - List of PCs by Thermal State

· EWR - List of PCs by Wakeup State

To see samples of all the reports available, please see

· SSRS http://support.enhansoft.com/wiki/computer%20system%20-%20ssrs.ashx

· ASP http://support.enhansoft.com/wiki/computer%20system.ashx

Sample report from the Computer System category:

clip_image001[4]

Tags:

Announcement | ConfigMgr | Enhanced Web Reporting | EWR | Product Release | SCCM | System Center Configuration Manager | vNext

Adobe SSRS Reports

by Garth 28. July 2010 12:00

The reports within Enhanced Web Reporting (EWR) are grouped into categories; one such category is Abode. Like all other categories within EWR, this one has been updated to include SSRS reports.

SQL Reporting Services in System Center Configuration Manager 2007 R2 enables administrators to use the advanced reporting features of SSRS. Some of the advantages of using SSRS are:

· Report subscriptions allowing reports to be e-mailed on a schedule.

· Cleaner user interface

· Allows for reports to be exported to various file formats such as PDF and Excel.

· Allows for graphics and data to be intermixed within reports.

Reports within this category are:

· EWR - Count of Adobe License Type

· EWR - Count of Adobe SKUs

To see samples of all the reports available, please see

· SSRS http://support.enhansoft.com/wiki/adobe%20-%20ssrs.ashx

· ASP http://support.enhansoft.com/wiki/adobe.ashx

Sample report from the Adobe category:

clip_image001

Tags:

Announcement | ConfigMgr | Enhanced Web Reporting | EWR | Product Release | SCCM | SSRS | System Center Configuration Manager | vNext

Enhanced Web Reporting v3.09

by Garth 27. July 2010 12:00

Microsoft System Center Configuration Manager 2007 collects significant information however not all of it is available via the ConfigMgr web reports. As well, additional information can be captured with some modifications to the SMS_def.mof to collect a wealth of information.

 

 

 

 

 

Sooner or later management will ask a question like, “What is our hot fix compliancy rates?”, “How many of X PCs do we have?”, “How many PCs are within X IP range?” Enhanced Web Reporting was created to help fill this void.

 

 

 

 

 

Enhanced Web Reporting (EWR) helps extend the asset information within the ConfigMgr database, then formats the data in easy, accessible, and comprehensive web reports.

 

 

·        Currently has over 90+ additional web reports

 

 

·        17 new or expanded categories

 

 

·        Ever expanding list of reports based on feedback

 

 

 

 

 

What new in Version 3.xx?

 

 

Version 3 is all about SQL Server Reporting Service (SSRS)! All version 2 reports have been update to included SSRS.  Some of the advantages of using SSRS are:

 

 

·        Report subscriptions by allowing report to be e-mailed on a schedule.

 

 

·        Cleaner user interface

 

 

·        Allows for reports to be exported to various file formats such as PDF and Excel.

 

 

·        Allows for graphics and data to be intermixed within reports.

 

 

 

 

 

What are the current categories and how many reports are there in each category? Check out the sample output from each report posted on the wiki site. Use the links below to see the reports within each category.

 

 

Over next little while we will post more about each category. Keep and eye out on the blog for more details.

 

 

 

 

 

Future of Enhanced Web Reporting:

 

 

·        More Adobe reports

 

 

·        More software update reports

 

 

·        Adding a printer category

 

 

·        What would you like to see?

 

 

 

 

 

Don’t forget that one of the benefits of EWR is the ability to request a new reports. We look to YOU to help us create new reports. We consider each report that is submitted and evaluate if this report will be useful to others beside the requestor.

 

Tags:

Announcement | ConfigMgr | Enhanced Web Reporting | EWR | News | Product Release | SCCM | SSRS | System Center Configuration Manager | vNext

Warranty Information Reporting and SSRS

by Garth 26. July 2010 14:00

Enhansoft is pleased to announce that Warranty Information Reporting (WIR) now includes SQL Server Report Services (SSRS) reports. Moving forward all new reports created for WIR will included SSRS reports.

SQL Reporting Services in System Center Configuration Manager 2007 R2 enables administrators to use the advanced reporting features of SSRS. Some of the advantages of using SSRS are:

· Report subscriptions by allowing report to be e-mailed on a schedule.

· Cleaner user interface

· Allows for reports to be exported to various file formats such as PDF and Excel.

· Allows for graphics and data to be intermixed within reports.

To see samples of all the reports available, please see http://support.enhansoft.com/wiki/wir.ashx

Sample report for WIR:

clip_image001

Tags:

ConfigMgr | SCCM | SSRS | System Center Configuration Manager | vNext | Warranty Information Reporting | WIR

Monitor Informaiton Reporting and SSRS

by Garth 23. July 2010 14:00

Enhansoft is pleased to announce that Monitor Information Reporting (MIR) now includes SQL Server Report Services (SSRS) reports. Moving forward all new reports created for MIR will included SSRS reports.

SQL Reporting Services in Configuration Manager 2007 R2 enables administrators to use the advanced reporting features of SSRS. Some of the advantages of using SSRS are:

· Report subscriptions by allowing report to be e-mailed on a schedule.

· Cleaner user interface

· Allows for reports to be exported to various file formats such as PDF and Excel.

· Allows for graphics and data to be intermixed within reports.

To see samples of all the reports available, please see http://support.enhansoft.com/wiki/mir%20-%20ssrs.ashx

Sample report for MIR:

clip_image001

Tags:

ConfigMgr | MIR | Monitor Information Reporting | SSRS | System Center Configuration Manager | vNext

How to delete folder with reports manually

by Garth 22. July 2010 14:00

You want to update your Office 2007 reports but before you do that you want to delete the existing reports. For example:

clip_image002

Use these steps to delete the folder and it contents.

- Connect to your SSRS site

- Browser to the appropriate folder

- Click the Properties tab

- Click the Delete button

- Click OK to confirm you want to delete the SSRS report.

Notice that the Office 2007 Folder has been removed.

clip_image004

Tags:

ConfigMgr | SCCM | SSRS | System Center Configuration Manager | Troubleshooting | vNext

How to upload a report manually to SQL Server Reporting Services (SSRS)

by Garth 21. July 2010 14:00

- Connect to your SSRS site

- Browse to the appropriate folder

- Click Upload File

clip_image002

- Click Browse… , select the appropriate file, then click Open

- Click the Overwrite item if it exists check box

- Click OK

clip_image004

- Click the uploaded report

clip_image006

- View results

Tags:

ConfigMgr | SCCM | SSRS | System Center Configuration Manager | Troubleshooting | vNext

How to delete SSRS report manually

by Garth 20. July 2010 07:00

- Connect to your SSRS site

- Browse to the appropriate folder

- Click the Report you want to delete

- Click the Properties tab

- Click the Delete button

- Click OK to confirm you want to delete the SSRS report.

clip_image002

Tags:

ConfigMgr | SCCM | SSRS | System Center Configuration Manager | Troubleshooting | vNext

Powered by BlogEngine.NET 1.6.0.0


Enhansoft is an information technology company specializing in Windows Management development, implementation and customization for:

  • System Center Configuration Manager v.Next
  • System Center Configuration Manager (ConfigMgr / SCCM)
  • System Management Server (SMS)
  • Virtual environments (Hyper-v / Virtual Server)

We focus on helping you manage your technology needs through our portfolio of world-class products and services.

Tag cloud