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

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/

ConfigMgr / SCCM Documentation script 1.21

by Garth 21. December 2009 18:08

The ConfigMgr Documentation script has been updated again.

One of the key items in this versions is updating the boundary list for ConfigMgr. This version has only be tested with ConfigMgr. So this might mean that boundaries will no longer be displayed if used on SMS server. With that in mind I have left the SMS 1.18 version on the Enhansoft site with the old boundary method enabled.

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

'History
'
'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 | News | Product Release | SCCM | SMS | System Center Configuration Manager

Comparing Monitor Information Reporting to Community Monitor Information Scripts

by Garth 24. November 2009 03:43

On a regular base Enhansoft is asked how Monitor Information Reporting (MIR) compares to the community monitor scripts. So we thought that we would compare MIR to a few of the existing scripts. Throughout this white paper we will try to provide a fair comparison.

Download the Whitepaper below:

Tags:

Announcement | ConfigMgr | MIR | Monitor Information Reporting | System Center Configuration Manager

Monitor Information Reporting v3 Beta

by Garth 28. September 2009 18:45

We are pleased to announce the beta of Monitor Information Reporting v3.

 

 

As a participant in this beta, you will receive a 4-month license for MIR v3 and will help shape the final release of MIR v3. To participate in this private beta, please contact support@enhansoft.com and we will send you a license key and link to the MIR v3 setup program.  

 

 

During the beta program Enhansoft will send out surveys to participants to help guide us with future releases of MIR v3. Support can be obtained by posting issues within support forum http://support.enhansoft.com/Forum/  or contacting support@enhansoft.com 

 

 

What is new in MIR v3:

 

·         Interface changes to provide a better listing of monitors

 

o   Minor changes to layout

 

o   Removed Default Monitor data

 

o   Filtered out truly duplicated monitors.

 

·         Option to scrub monitor data and allow for a fresh start

 

·         Capture native pixel format data

 

·         Capture monitor power option data

 

·         Update the active monitor status

 

·         Calculated serial numbers

 

·         Even more detailed logging.

 

 

Interface

 

Based on feedback we have simplified the interface.

 

 

MIRInterface

 

Scrubbing monitor data

 

Removing old monitor data from a PC can be a tedious process as demonstrated by the blog poston how to manually clean up monitor data. MIR v3 allows you to remove this data either by using an option within the MIR GUI found under tools menu or by using a command line switch “/Scrub”.

 

 

 

 Scrub

 

It is important to note that a reboot is required to repopulate the monitor data, otherwise you will see the following message displayed. MIR v.3 will NOT force the reboot of a system once the scrub command has been executed.

 

DisplayKey 

 

 

 

Native pixel format

 

 

Native Pixel Format 

 

The Native Pixel format also called Preferred Timing Mode or default resolution has been added. This allows an Administrator to determine if a monitor is blurriness’s caused by incorrectly setting the native pixel format.  With most PCs now having liquid crystal display (LCD), most LCD flat panel monitor users do not realize that operating their monitor in a resolution other than the native resolution negatively impacts the performance of their flat panel monitor. Unlike cathode ray tube (CRT) displays, the liquid crystal display panel used in flat panel monitors has a fixed, predefined pixel format over a set area. A fixed pixel format means that if the native resolution of the LCD panel is 1,024 x 768, there are exactly 1,024 pixels in each horizontal line and 768 pixels in each vertical line or 786,432 total pixels. When a PC’s resolution is set to the native pixel format, this allows for a 1:1 ratio and yields the best results. When the non-native resolution such as the 800 x 600 is displayed on a 1024 x 768 native resolution monitor scaling occurs. Scaling adjusts the image to fill the entire monitor screen. This results in manipulation of pixels to fill the screen, but the manipulation may cause text and images to appear blurry.  There is no good way to show a non-native resolution on a fixed matrix display. 

 

 

 

Monitor Power option

 

 PowerManagement

 

 

 

What are the 4 monitor power management options and what do they mean?

 

The 4 options are: 

 

Mode

 

Power

 

Approximate Recovery Time

 

On

 

100%

 

0 Second

 

Standby

 

< 80%

 

1 Second

 

Suspend

 

< 30W

 

5 Seconds

 

Active Off

 

< 8 W

 

20 Seconds

 

 

From these options we can see that a significant power saving can be achieved just by ensuring that all monitors have suspend mode and are set up to use it. For more details please see the blog post entitled “Monitor Power Management Options

 

 

 

Update the Active monitor status

 

Within the previous screenshot for the interface section you will notice within the Active Monitor section that the HP monitor is “Marked Active”, but if you look at the screenshot below you will see that the Samsung is “Active”. You might ask yourself why have we added this feature. The answer is simple: we have determine that there are cases when a monitor is “Marked Active” when in fact is it not active. Until now, there was no way to determine this if a monitor was truly active, let alone clean up this issue. MIR v3 solved this issue in two ways, First for Vista , Windows 7 and Windows 2008 we can determine the truly active monitors; those will be set as “Active”, and other monitors will marked appropriately. Secondly, we have provided mechanisms to scrub the existing monitor data, which allows for this data to be cleaned up and the correct data to be displayed. See the scrub section for more detail.

 

 

Active Monitor States:

 

Active – This monitor is truly active (Vista, Window 7, Windows 2008 only)

 

Marked Active – This monitor is marked as active but could be a false positive (Active state for Windows XP and Windows 2003)

 

Non-Active – this monitor is not active

 

 

Samsung

 

 

 

Calculated serial numbers

 

Based on the standards for monitors, the maximum serial number length is 13 characters. However many monitor manufacturers have serial numbers greater than 13 characters.  This leaves the question: how can I determine what is the right serial number for a given monitor?

 

 

Through a number of processes we have been able to expand the functionally of MIR to help determine the correct serial number and in some cases even provide almost all of the serial number for some manufacturers. The following screenshots illustrate this.

 

 

 

Notice the following for each screenshot:

HWP2601ACRAD92 DEL3013CPQ1349

 

HWP2601

This HP model serial number has been confirmed to be correct as displayed.

 

 

ACRAD92

 

This Acer model, we can expand the serial number to included all but the first 2 characters. (we believe that they are always “ET” but have not added this into MIR yet pending further research.)

 

 

DEL3013

 

This Dell monitor we have displayed the serial number as it would look on the physical monitor itself, except we have replaced unknown charters with “x”

 

 

CPQ1349

 

This Compaq monitor is an example of a monitor that we have not confirmed what the physical serial number is and therefore we have placed the normal serial number within the Calculated field and marked it as Default

 

 

 

 

We will be expanding this feature to included more Calculated Serial numbers as we confirm details for each model. Please feel free to pass along any details to help expand this feature. We require a copy of the EDID for the monitor and physical serial number as displayed on the monitor.

 

 

System Management Server 2003

 

MIR v3 is fully backwards compatible with SMS 2003, however the setup program is designed only for ConfigMgr, therefore will not install correctly on SMS 2003. If you require manual installation instructions, please review the MIR v2 documentation as it still applies. If you need additional assistance please contact support.

 

 

Troubleshooting:

 

To aid in troubleshooting, please provide us  with the following details:

 

 

MIR

 

·         A description of the issue that is occurring

 

·         Export of the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\DISPLAY

 

·         MIR.log, generally found with the ConfigMgr client logs.

 

·         Physical serial number of monitor as displayed (optional but recommend)

 

 

MIR Setup

 

·         A description of the issue that is occurring

 

·         MIR_setup.log, generally found with the ConfigMgr client logs; in some cases it will be within the %temp% directory

 

·         A description  of your environment: please include Windows version(2003/2008/2008 R2) (x86/x64), ConfigMgr version, SQL version (2005 / 2008) and location (Local to site server or remote)

 

Public beta for Enhanced Network Device Discovery (ENDD)

by Garth 25. September 2009 21:42

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. 

As a participant in this beta, you will receive a 4 month license for ENDD and will help shape future releases of ENDD.

 

 

During the beta program Enhansoft will send out surveys to participants to help guide us with future releases. Support can be obtained by posting issues within support forum http://support.enhansoft.com/Forum/ or by contacting support.

 

 

 

 

 

A quick overview of ENDD is below and attached is the latest ENDD documentation.

 

 

 

 

 

 

Enhanced Network Device Discovery (ENDD)

 

 

 

 

 

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

  • Provide data such as make, model and serial number of each device
  • Capture any SNMP data

     

    Sample output

 

 

 

 

 

If you have any questions or comments, please feel free to contact us.

 

Tags:

Announcement | Beta Release | ENDD | News | SCCM | SMS | System Center Configuration Manager

Powered by BlogEngine.NET 1.6.0.0

About the author

Something about the author

Tag cloud