List of PCs by Adobe SKU is a new SSRS report within the Adobe category for Enhanced Web Reports (EWR)

This report will provide you a list of PCs that have a particular Adobe SKU installed.

List of PCs by Adobe License Type is a new SSRS report within the Adobe category for Enhanced Web Reports (EWR)

This report will provide you a list of PCs that have a particular Adobe license type installed.

Overall Software Update Status for PC is a new SSRS report for Enhanced Web Reports (EWR)

This report provide a summary of Software Update Status

When a SSRS report is created a data source (DS) is used to create and test the report. This DS may not exist on your SSRS site therefore you will need to point it to a DS that does exist on your site. Use these steps to re-point the DS to an existing DS.

· Connect to your SSRS site

· Browse to the appropriate folder

· Click the report you want to change data source for

· Click the Properties tab

· Click the Data Sources link on the left

· Click the Browse button

· Expand Home | <Your SSRS folder name> until you find the shared data source you are looking for

· Select the data source

Note: {5C6358F2-4BB6-4a1b-A16E-8D96795D8602} is the default ConfigMgr data source

· Click OK (You might need to scroll down to see the OK button.)

· Click Apply button

· Click the View tab to ensure that that report works correctly.

How can I create a report using a SQL query provided by Enhansoft or that I find on a blog. (Like the personal blog of Garth Jones, the Chief Architect of Enhansoft.)

· Within the ConfigMgr Console, Browse to Site Database | Computer Management | Reporting | Reports

· In the left pane, right click the Reports node

· Point to New

· Click Report

· In the New Report Wizard, fill in details for:

o Report name

o Category

· Click Edit SQL statement…

· Remove contents of the SQL statement: text box

· Paste the query provided into the SQL Statement:

· Click OK

· On the Display window, click Next >

· On the Links window, click Next >

· On the Security window, click Next >

· On the Wizard Complete window, click Close

Did you know that you can hire the Enhansoft team to create custom System Center Configuration Manager (ConfigMgr / SCCM) reports either Classic reports {Active Server Pages (ASP)} or Reporting Service Point {SQL Server Report Services (SSRS)}?

Many companies find it is easier and cheaper to hire outside staff to perform a specialized task like this. Enhansoft has lots of experience creating reports, and we have create reports for many companies. If you are looking for someone to create custom System Center Configuration Manager reports, please contact sales for more details.

Enhanced Web Reporting (EWR) is updated as required to include the new reports that have been requested. We try to limit major updates to report categories to once a quarter and minor releases to monthly. We suggest our clients subscribe to our blog and announcements of new reports will be made there.

The answer is simple, since one of the benefits of Enhanced Web Reporting (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.

For example, we have a suggestion about our Adobe reports like Count of Adobe SKU, The request is that it would be nice to have a list of PCs with the particular Adobe product. This report has be accepted and is expected to be release in the next update of EWR.

The reports within Enhanced Web Reporting (EWR) are grouped into categories; one such category is Workstation. 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 - All In One

· EWR - Count of PCs By Last Inventory

· EWR - Count of Physical PCs vs Virtual PCs

· EWR - List of PCs which have not rebooted the last 7 days

· EWR - List of PCs with less that 10% free hard drive space

· EWR - List PCs by hard drive space used for a file type

To see samples of all the reports available, please see

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

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

Sample report from the Workstation category:

The reports within Enhanced Web Reporting (EWR) are grouped into categories; one such category is Windows Experience Index. 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 Windows Experience Index

· EWR - Count of CPU Score

· EWR - Count of Disk Score

· EWR - Count of Gaming Graphics Score

· EWR - Count of Graphics Score

· EWR - Count of Memory Score

· EWR - Count of Windows Experience Index

· EWR - List of PCs by CPU Score

· EWR - List of PCs by Disk Score

· EWR - List of PCs by Gaming Graphics Score

· EWR - List of PCs by Graphics Score

· EWR - List of PCs by Memory Score

· EWR - List of PCs by Windows Experience Index

To see samples of all the reports available, please see

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

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

Sample report from the Windows Experience Index category: