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

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

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

ConfigMgr / SCCM Documentation Script v1.24

by Garth 2. March 2010 15:23

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

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

'History
'
'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

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

Tags:

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

Enhansoft Goes Gold!

by Garth 20. January 2010 04:14

Ottawa, Ontario, Canada, January 19, 2010--- Enhansoft Inc., a leading developer of System Center Configuration Manager solutions, was awarded Microsoft Gold Certified Partner status on January 15th 2010. Holding the Systems Management competencies confirms Enhansoft’s commitment to Microsoft customers and technologies. 

 

Microsoft Gold Certified Partners have access to exclusive resources and early product information. The program includes direct access to Microsoft staff, product support, new products and technologies, and planning tools and events on the latest Microsoft product developments and future direction.

 

 “Our new partnership provides us greater access to the Microsoft System Center team. Our dedication to providing the best solutions and support in the industry has paid off. ”

 

Garth Jones

 

Chief Architect

 

 

 

About Enhansoft Inc.

 


Enhansoft, a Microsoft Gold Certified Partner, specializes in providing software solutions and consulting services within the system management area focusing on Microsoft System Center products. Maximize the potential of your systems, the productivity of the company workforce and, best of all, the impact on the bottom line.

 

 

 

Our products have a worldwide reputation for extending and enhancing Microsoft technologies by leveraging Microsoft System Center Configuration Manager (ConfigMgr / SCCM) & Systems Management Server (SMS) technologies to extend their asset information and reporting capabilities.

 

 

Enhansoft professional services bring together a deep product knowledge of system management focused on Microsoft System Center products.

 

 

Our Clients Benefit From:

 

Our Focus

 

We specialize in the system management area, focusing on Microsoft System Center products with an emphasis on asset management.

 

 

Our Experience

 

The team at Enhansoft combines real-world system management experience with high-level programming expertise to design software that is easy to implement and has an immediate impact on workload and company bottom line.

 

 

Our professional services team helps customers realize value within their system management environment. Many of our consultants have more than 10 years of experience within system management area, are leaders in their respective IT communities and user groups, and have presented at such conferences as Microsoft Management Summit, Techdays, and EnergizeIT.

 

 

Our Expertise

 

Our products and services are designed for ConfigMgr experts by ConfigMgr experts.

 

 

From global corporations to institutes of higher learning and public school systems, to global government agencies, Enhansoft has the software and expertise to help any organization realize the long-term efficiencies and cost savings associated with asset management. Our headquarters are located in Ottawa, Ontario, Canada with remotes offices in Chicago, Illinois. We leverage hands-on experience, as well as client feedback to continually refine our products. We also work with a network of partners — including software resellers and consulting firms — who recommend our products, service and expertise to their own clients.

 

 

 

http://www.enhansoft.com/

Powered by BlogEngine.NET 1.6.0.0

About the author

Something about the author

Tag cloud