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 | vNext | System Center Configuration Manager | SCCM | Product Release

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 | Enhanced Web Reporting | EWR | Product Release | SCCM | ConfigMgr | 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 | EWR | Enhanced Web Reporting | 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 | Warranty Information Reporting | WIR | vNext

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:

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

Public Beta for Enhanced Network Device Discovery

by Suzanne 27. May 2010 16:28

We are pleased to announce that the public beta for Enhanced Network Device Discovery will commence June 14, 2010.

As a participant in this beta, you will receive a 6 month license for ENDD and will help shape future releases of ENDD. To participate in this public beta, please contact support@enhansoft.com  and we will send you the license key and link to the ENDD setup program.

 

A quick overview of ENDD is below.

 

Enhanced Network Device Discovery (ENDD)

Enhance ConfigMgr / SMS asset management information with network devices such as Printers, Routers, Switches, IP Phones.  ENDD augmented with SNMP can:

·         provide items such as make, model and serial number of each device

·         Capture any SNMP data

·         Automatically scans IP ranges.

 

 

 

 

 

Tags:

Beta Release | ENDD

ConfigMgr / SCCM Documentation Script v1.31

by Garth 14. May 2010 19:16

The Configuration Manager 2007 Documentation Script has been updated to version 1.31.

If you have any comments, questions or additions that you would like, please post those to the support forum

'History
'
'1.31 - Merged Scripts
'1.30 - Added debug code to provide section
'1.28 - Class Premissions
'1.27 - Added Program Details
'1.25-1.29 - Reserved these update will be added to v1.31 or later.
'1.25 - Fix Typo and ..
'1.24 - Even more var declared and fix Boundary issues.
'1.23 - Set "Option Explicit OFF"
'1.22 - Don't remember and added bWMILocalGroups to vars list.
'1.21 - Fixed Boundaries and make this version work for ConfigMgr only now!
'1.20 - interim release.
'1.19 - more var issues. Fix issue with the alt username and password. (Doh!)
'1.18 - Increased MaxCharacters 500 to fix Microsoft Cursor Engine: Multiple-step operation generated errors. Check each status value. issue.
'1.17 - Made sure that all vars are declared, added ECStr Function, update some of the debug code
'1.16 - Fixed anther issue with username and password. Add more debug mode code
'1.15 - Fixed issue with username and password.
'1.14 - Re-released
'1.13 - Fixed typos Thanks to Jim Dempsey for finding them
'1.12 - Add lots of conversion details such as 1/0 to True/False etc.
'1.11 - Added site control file refresh
'1.10 - Fully Add  schedule token decode and update
'1.09 - Added bit shifting functions
'1.08 - Add Decodetext schedule Token
'1.07 - Add Decodetext Function
'1.06 - Add Boundary, Agent setting (HW, SW, etc.)
'1.05 - Add Help, Added Command line options
'1.04 - Changed Default Font size from 12 to 10
'1.03 - Removed SQL Query for Web report, Added ReportID
'1.02 - Fixed Basic site info
'1.02 - Fixed Basic site info

http://www.enhansoft.com/pages/downloads.aspx

Tags:

Announcement | Documentation Script | Product Release | SCCM | System Center Configuration Manager

Powered by BlogEngine.NET 1.6.0.0

About the author

Something about the author

Tag cloud