SSRS & Software 02D - Computers with a specific software product

by Garth 16. December 2011 21:23

When converting the native Microsoft SCCM 2007 ASP reports to SQL Server Reporting Services (SSRS) reports a few of them don’t convert correctly. Enhansoft has corrected this problem in native Microsoft SCCM 2007 reports for SSRS. Please enjoy these free reports!

 

Software 02D - Computers with a specific software product

  • Fixed Prompts to allow for Null items
  • Fixed Prompt text
  • Set Default “Null” as default for all prompts except for Collection
  • Very minimal changes to SQL to allow for it to work within SQL BI tool
  • Updated footer
  • Set datasource to one that can be used by SQL BI, this will get reset to the MS datasource on installation.
  • Some SQL formatting to allow for readability

 

http://www.enhansoft.com/pages/sccm-2007-conversion-tools.aspx

 

Others are coming so stay tuned.

Tags:

Announcement | ConfigMgr | News | SCCM | SSRS | System Center Configuration Manager

Did you know...

by Suzanne 13. April 2011 15:21

This post will be the first in our series of Did You Know...

All of the log files associated with our Enhansoft products (Monitor Information Reporting, Warranty Information Reporting, Enhanced Web Reporting and Enhanced Network Device Discovery) are SMS Trace compliant and can be found in one of the following locations: %WINDIR%\System32\CCM\Logs folder, %WINDIR%\SysWOW64\CCM\Logs (for x64 OS) or in the temp file.

 

Tags:

ENDD | Enhanced Web Reporting | EWR | MIR | Monitor Information Reporting | News | SCCM | SMS | Warranty Information Reporting | WIR

Microsoft Management Summit 2011

by leaston 1. February 2011 15:00

Enhansoft is pleased to announce that it will be attending the Microsoft Management Summit 2011 (MMS-2011) at the Mandalay Bay Resort and Casino in Las Vegas, Nevada from March 21 to March 25, 2011.   We hope that you will drop by Enhansoft’s booth #128 for an informative demonstration of all our product software.   Enhansoft is an industry leader in comprehensive asset reporting and custom report writing.    Enhansoft’s product software includes: Warranty Information Reporting, Monitor Information Reporting, and Enhanced Web Reporting.  All products are available either on their own or in the Enhanced Asset Management Suite. 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.  For more information on Enhansoft products please visit our website www.Enhansoft.com.  More information on MMS-2011 may be obtained at www.mms-2011.com.

SSRS Report Winner for Dec 2010

by Garth 12. January 2011 16:46

And the winner is: Software Distribution Status.

 

 

Over the next few days, the setup program will be created and released. At the same time January’s SSRS reports will be announced. Watch this blog for more details.

 

.

Tags:

Announcement | ConfigMgr | News | SCCM | SSRS | System Center Configuration Manager | vNext

Monitor Information Reporting v3.27

by Suzanne 14. October 2010 16:29

Enhansoft if pleased to announce the release of Monitor Information Reporting v3.27. This version has the added feature of collecting the video input data (Analog vs Digital) for all Monitors. You can download an evaluation version of MIR from the following link:

http://www.enhansoft.com/downloads/mir/mirsetup327.zip

Tags:

Announcement | Monitor Information Reporting | News

Did you know?

by Garth 24. August 2010 12:00

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.

 

Tags:

Announcement | ConfigMgr | News | SCCM | SMS | SSRS | System Center Configuration Manager | System Management Server | 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

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

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)

 

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