Enhansoft

SCCM 2007 Conversion Tool for ASP Report, Chart - Hourly advertisement completion status

leaston — Wed, 08 Feb 2012 20:01:12 +0100

When converting native Microsoft SCCM 2007 ASP reports to SSRS reports a few of them don’t convert correctly. Enhansoft has corrected this issue in reports where we know this problem exists.

The latest free conversion tool that you can download from our website is for Chart - Hourly advertisement completion status.

What we did:

Added Chart
Centered Table
Fixed Prompt
Fixed Prompt Text
Very minimal changes to SQL to allow for it to work within SQL BI tool
Filtered out "0" results within SQL
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

Here is a sample output:

Vote for March’s Free SSRS Report

leaston — Tue, 07 Feb 2012 19:50:58 +0100

VOTE for your favorite SSRS report to become March’s free report give-away.

The choices are:

Advertisement Metric Dashboard OR Desired Configuration Management.

This poll will be open all month-long, so make sure to check back later on in the month to see how well your favorite report is doing.

Preview of SSRS Reports in February’s Poll

leaston — Mon, 06 Feb 2012 16:49:56 +0100

All this month you will be able to vote for the SSRS report you would like to see become Enhansoft’s next free SSRS report give-away.

Details about how to vote for March’s free report will appear tomorrow.

The SSRS report choices are:

Advertisement Metric Dashboard OR Desired Configuration Management.

Advertisement Metric Dashboard shows the action taken (Accepted - No Further Status, Cancelled, Failed, No Status, Succeeded, Waiting, Reboot Pending, and Otherwise) by the System Center Configuration Management team in managing the lifecycle of packages over a series of months.

Each of the actions is color-coded for easy reference:

Accepted - No Further Status = Blue

Cancelled = Brown

Failed = Red

No Status = Gray

Succeeded = Green

Waiting = Yellow

Reboot Pending = Teal

Otherwise = Black

This report demonstrates the level of effort performed by the System Center Configuration Management team in the full life cycle management of applications deployed for a company.

Here is a sample screenshot:

Desired Configuration Management

This report is designed to mimic the Desired Configuration Management Status Summary home page within the Configuration Manager Console.

Here is a sample screenshot:

February’s Free SSRS Report

leaston — Wed, 01 Feb 2012 19:46:20 +0100

Contact info@enhansoft.com to request this month’s winning report:

Count of Printers

For the first time, we are offering you a chance to become a tester for one of our reports. Count of Printers, as its name suggests, provides you with a count of all the different printers in your environment. We have received a number of requests for SSRS reports on printers, and hope that you will be just as excited as we are about testing it. If you have any feedback about what details this “count report” should drill through to we’d love to hear your ideas, so send us a quick email.

Here is a sample screenshot:

Last chance to vote & to request free SSRS report

leaston — Tue, 31 Jan 2012 20:12:26 +0100

VOTE today for either Count of Windows Experience Index or Count of Printers to become February’s free SSRS report give-away.

Also, this is the last day to request January’s free SSRS report List of PCs with less than 10% free HD space.

Email info@enhansoft.com to get this free report!

Here is a sample screenshot:

Depended Package

garth — Thu, 26 Jan 2012 01:32:32 +0100

Use this query to get the package name for any depended program.

See the TechNet forum post for full details.

SELECT     
  Pkg.Name AS 'Package Name', 
  ADV.ProgramName AS 'Program Name',
  ADV.AdvertisementName AS 'Advertisement Name', 
  Col.Name AS 'Collection Name', 
  CRQ.RuleName AS 'Security Group Name',
  Pgm.PackageID, 
  Pgm.ProgramName, 
  Pgm.DependentProgram,
  pkgsub.Name
  
FROM
  dbo.v_Advertisement Adv
  INNER JOIN dbo.v_Collection Col ON ADV.CollectionID = Col.CollectionID 
  INNER JOIN dbo.v_Package Pkg ON ADV.PackageID = Pkg.PackageID 
  INNER JOIN dbo.v_CollectionRuleQuery CRQ ON Col.CollectionID = CRQ.CollectionID 
  INNER JOIN dbo.v_Program Pgm ON Pkg.PackageID = Pgm.PackageID
  left outer Join (select substring(Pgm.DependentProgram,0,9) as Subpac, PackageID from dbo.v_Program  Pgm where Pgm.DependentProgram != '') sub ON sub.PackageID = Pkg.PackageID 
  left outer JOIN dbo.v_Package Pkgsub ON sub.Subpac = Pkgsub.PackageID 
--where 
--  ADV.AdvertisementName like 'Z7_%' 
ORDER BY 
  ADV.AdvertisementName

Reminder to Vote for February’s Free SSRS Report

leaston — Wed, 25 Jan 2012 17:54:04 +0100

Please VOTE for your favorite SSRS report:

Count of Windows Experience Index or Count of Printers.

We have received a number of requests for SSRS reports on printers, and hope that you will be just as excited as we are about testing it. If you have any suggestions about what details this “count report” should drill through to we’d love to hear your ideas, so email us at info@enhansoft.com.

List of PCs with less than 10% free HD space–January’s Free SSRS Report Give-Away

leaston — Tue, 24 Jan 2012 17:15:58 +0100

You still have time to request this month’s free SSRS report, so please contact: info@enhansoft.com.

List of PCs with less than 10% free HD space will provide a list of PCs where at least one hard drive has less than 10% free disk space. This will allow you to proactively resolve any free disk space issues before it becomes a real problem.

Here is a sample screenshot:

Thank you to everyone who voted for this report in December.

SQL Silent Install

jyedid — Wed, 18 Jan 2012 20:10:00 +0100

Working at Enhansoft, I spin up a lot of VMs and install Configuration Manager 2007 and 2012. Since Configuration Manager requires SQL Server (we use 2008 and 2008 R2) we use the same setups time and again. Now this becomes tedious. Constantly going through the SQL setup to achieve the same end result. There has got to be an easier way to do this. And there was. SQL unattended silent install.

The following procedure is for SQL Server 2008 R2.

First step is to go though one initial setup, choosing your required configuration. You will eventually come the end of the setup with the following line:

Do not complete the setup at this point. Take note of the the location of the configuration file location; go there and copy the the configuration file to a safe location (a shared network drive for example). If you had closed the SQL install before coping the configuration file, the configuration file will have been deleted.Once that is done, you can safely close the SQL Server install windows.

Once the configuration file is safe, it has to be edited. The following should be set:

QUIET set to True

SQLSYSADMINACCOUNTS set this for your required Admins (or leave it if you set in the the initial setup)

Add PID and set the license key (this might not be needed if you product came with one preloaded)

IACCEPTSQLSERVERLICENSETERMS set to True

ADDCURRENTUSERASSQLADMIN - remove this entry, it applies only to SQL Server Express

UIMODE – remove this entry, does not work with quiet mode

INSTALLSHAREDDIR, INSTALLSHAREDWOWDIR, INSTANCEDIR – now when it comes to this 3 settings, they are up to your configuration, We install both Configuration Manager and SQL on D drives, not the default locations; which are normally the C drive.

The next step is to create a batch file to run the install. The following is what I have in mine, although a bit modified.

@echo off
echo Installing SQL Server 2008 R2
e:\setup /ConfigurationFile=\\Sharename\username\ConfigurationFile.ini

Note that I am using SQL Server 2008 R2 ISO and have inserted it into a VM, the batch file and configuration file are stored on a share.

SCCM 2007 Conversion Tool for ASP Report, Compliance 6 - Specific Computer

leaston — Tue, 17 Jan 2012 16:53:03 +0100

When converting native Microsoft SCCM 2007 ASP reports to SSRS reports a few of them don’t convert correctly. Enhansoft has corrected this issue in reports where we know this problem exists.

The latest free conversion tool that you can download from our website is for Compliance 6 – Specific Computer. http://www.enhansoft.com/pages/sccm-2007-conversion-tools.aspx

What we did:

Fixed Prompt to allow for all Vendors to be selected
Fixed Prompt to allow for all Classification to be selected
Cleaned up Prompt query to Select PCs
Fixed Prompt text
Set default prompt selection for Classification (“All Classification”)
Set default prompt selection for Vendors (“All Companies”)
Adjusted some of the column sizes, to better mimic the ASP version of this report.
Adjusted some column headers to be vertical to match column width.
Allowed for the URL session of the report to go to the KB article
Very minimal changes to SQL to allow for it to work within SQL BI tool
Updated header
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

SCCM 2007 Conversion Tools for ASP Reports

leaston — Thu, 12 Jan 2012 16:29:41 +0100

When converting native Microsoft SCCM 2007 ASP reports to SSRS reports a few of them don’t convert correctly. Enhansoft has corrected this issue in reports where we know this problem exists.

Please go to our SCCM 2007 Conversion Tools for ASP Reports webpage: http://www.enhansoft.com/pages/sccm-2007-conversion-tools.aspx where you will be able to download free conversion tools for Software 01A - Summary of installed software in a specific collection and Software 02D - Computers with a specific software product.

We will be continually adding more conversion tools, so you may want to bookmark this page.

Enjoy these free conversion tools!

Vote for February’s Free SSRS Report

leaston — Wed, 11 Jan 2012 17:19:37 +0100

Today you can start voting for either:

Count of Windows Experience Index or Count of Printers

to become Enhansoft’s next free SSRS report give-away in February.

We are pleased that myITforum.com is once again hosting the poll, so vote for your favorite report at:

http://myitforum.com/myitforumwp/2012/01/10/help-choose-enhansofts-next-free-sql-server-reporting-services-ssrs-report-for-the-month-of-february/

Thank you for participating!

Please remember that you can request this month’s free report, List of PCs with less than 10% free HD space, all month-long by emailing info@enhansoft.com.

Preview of SSRS Reports in January’s Poll

leaston — Tue, 10 Jan 2012 16:59:49 +0100

All of January you will be able to vote for the SSRS report you would like to see become Enhansoft’s next free SSRS report give-away.

Details about how to vote for February’s free report will appear tomorrow.

The SSRS report choices are:

Count of Windows Experience Index or Count of Printers.

Count of Windows Experience Index will provide you with your environment’s count of Windows Experience Index scores for Vista and Windows 7 PCs. This report is useful in understanding how an application will perform within your environment. It also provides some guidance on how many PCs you may need to replace based on low score results. The drill through report to the Count of Windows Experience Index report, which is found in the full feature-set version of this EWR series, will provide you with a “list report” of PC details.

For more information about Microsoft’s Windows Experience Index, please see the following links:

http://windows.microsoft.com/en-US/windows-vista/What-is-the-Windows-Experience-Index

http://windows.microsoft.com/en-US/windows-vista/Windows-Experience-Index-Understand-and-improve-your-computers-performance-in-Windows-Vista

Here is a sample screenshot:

Count of Printers. For the first time, we are offering you a chance to become a tester for one of our reports. Count of Printers, as its name suggests, provides you with a count of all the different printers in your environment. We have received a number of requests for SSRS reports on printers, and hope that you will be just as excited as we are about testing it. If you have any feedback about what details this “count report” should drill through to we’d love to hear your ideas, so email us at info@enhansoft.com.

Here is a sample screenshot:

January’s Free SSRS Report Give-away - List of PCs with less than 10% free HD space

leaston — Mon, 09 Jan 2012 17:10:02 +0100

Thank you to everyone who voted in December to make List of PCs with less than 10% free HD space our free report give-away in January.

To request this month’s free report, please contact: info@enhansoft.com.

Here is a sample screenshot:

More details about next month’s report give-away will be posted this week.

Happy Holidays!

leaston — Wed, 21 Dec 2011 16:13:38 +0100

Happy Holidays from everyone here at Enhansoft!

All the best for 2012! Meilleurs voeux pour 2012!

December’s Free SSRS Report

leaston — Tue, 20 Dec 2011 15:33:30 +0100

Here’s a reminder that all this month we are giving away the SSRS report, Count of PCs By Last Inventory.

Contact info@enhansoft.com to request your free copy.

Count of PCs By Last Inventory will provide you with the most current up-to-date data about the number of PCs (laptop, notebook, desktop and server) within your environment and when they last reported to SCCM.

Most of your PC inventory should appear within the 0-30 day range.

Besides knowing your PC asset inventory count, our report will also let you know quickly if you have potential problems with your environment if numerous PCs are accumulating in the 31-91+ day range. These could be decommissioned PCs or there might be a problem with your management point; this allows you to take appropriate action.

Vote for January’s Free SSRS Report

leaston — Mon, 19 Dec 2011 16:59:59 +0100

This a reminder that all this month you can for either:

Count of PCs By Role or List of PCs with less than 10% free HD space

to become Enhansoft’s next free SSRS report give-away in January, 2012.

We are pleased that myITforum.com is once again hosting the poll, so vote for your favorite report at:

http://myitforum.com/myitforumwp/2011/12/05/help-choose-enhansofts-next-free-sql-server-reporting-services-ssrs-report-for-the-month-of-january-2012/

Thank you for voting!

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

Garth — Fri, 16 Dec 2011 21:23:00 +0100

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.

Dealing with SSRS report errors

jyedid — Wed, 07 Dec 2011 19:40:43 +0100

When dealing with SSRS reports, occasionally you may get an error such as the one below:

An error has occurred during report processing. (rsProcessingAborted)
- Query execution failed for dataset 'SUVendor'. (rsErrorExecutingCommand)
  - Could not find stored procedure 'dbo.ES_SU_Dashboard_flt_vendor'.

No matter what you do you still get this message; even when you fix the report and know it works.

So what does this error message mean? How do you get to the root of the problem?

The starting point of the solution is found in the MS Knowledge Base article:

How to: Enable Remote Errors (Reporting Services Configuration)

http://technet.microsoft.com/en-ca/library/aa337165.aspx

By following the steps in this article, you will re-run the report and a new error message will be created; only this time the error message will be more specific as to what the actual problem is that is causing the report not to run. In some cases in might be simply a permissions issue.

December’s SSRS Report Poll

leaston — Tue, 06 Dec 2011 16:12:22 +0100

Today you can start voting for either:

Count of PCs By Role or List of PCs with less than 10% free HD space

to become Enhansoft’s next free SSRS report give-away in January, 2012.

We are pleased that myITforum.com is once again hosting the poll, so vote for your favorite report at:

http://myitforum.com/myitforumwp/2011/12/05/help-choose-enhansofts-next-free-sql-server-reporting-services-ssrs-report-for-the-month-of-january-2012/

Thank you for voting!

Preview of SSRS Reports in December’s Poll

leaston — Mon, 05 Dec 2011 15:47:24 +0100

All of December you will be able to vote for the SSRS report you would like to see become Enhansoft’s next free SSRS report give-away.

Details about how to vote for January’s free report will appear tomorrow.

The SSRS report choices are:

Count of PCs By Role or List of PCs with less than 10% free HD space.

Count of PCs By Role will provide you with a count of the number of PCs that fall within each category: Backup Domain Controller, Member Server, Member Workstation, Primary Domain Controller, Standalone Server, and Standalone Workstation.

Here is a sample screenshot:

December’s Free SSRS Report–Count of PCs By Last Inventory

leaston — Thu, 01 Dec 2011 20:37:31 +0100

Thank you to everyone who voted last month!

All of December we will be giving away the SSRS report, Count of PCs By Last Inventory. Please contact info@enhansoft.com to request your free copy.

Early next week we will preview the reports that you can vote for to become January’s free SSRS report.

Here’s a summary of December’s free report:

Most of your PC inventory should appear within the 0-30 day range.

Last Day to Vote for SSRS Report

leaston — Wed, 30 Nov 2011 16:29:11 +0100

Today is the last day to vote for either:

Count of PCs by Last Inventory or Microsoft Office Details 2010

to become Enhansoft’s free SSRS report give-away in December.

We are pleased that myITforum.com is once again hosting the poll, so vote for your favorite report at:

http://myitforum.com/myitforumwp/2011/11/02/help-choose-enhansofts-next-free-sql-server-reporting-services-ssrs-report-for-the-month-of-december-2011/

Thank you for voting!

Software Updates Dashboard–Free SSRS Report in November

leaston — Tue, 29 Nov 2011 17:15:04 +0100

This is a reminder that you have only today and tomorrow to contact info@enhansoft.com to request November’s free SSRS report.

Here’s a brief summary of Software Updates Dashboard:

This new addition to Enhanced Web Reporting is designed to mimic the Software Update Compliance Status Summary home page within the ConfigMgr Console.

Sample Screenshot:

DevTeach – ITProTeach in Ottawa

jyedid — Mon, 28 Nov 2011 18:00:36 +0100

On November 3^rd and 4^th, I attended the first ever DevTeach conference in Ottawa. As a new addition they added ITProTeach to their list of sessions.

One of the sessions I attended was titled, ‘A deep dive in SCCM Data’ and was presented by none other than Enhansoft’s Chief Architect, Garth Jones. This session covered a lot of info in 90 minutes. I felt like it was directed for the most part at me. Okay, I’m being biased, but that’s only due to the fact that I work for Garth.

The session covered stuff from SQL statements to proper SSRS reports and what goes on behind the scenes of report writing and getting Configuration Manager into those reports. In case you missed it, here is a link to Garth’s PPT.

All in all, as always Garth is a very good presenter and really knows his stuff. In fact, Garth was voted Top Speaker at DevTeach. Not a surprise!

Now if only there was a course on SSRS report writing. Maybe next year….

Adobe Licenses

leaston — Wed, 23 Nov 2011 16:05:00 +0100

Did you know that Enhansoft can help you keep track of your Adobe licenses?

Reports found in Enhanced Web Reporting – EWR include:

1) Count of Adobe License Types

Which will drill through to:

2) List of PCs by Adobe License Type

3) Count of Adobe SKUs

Which will drill through to:

4) List of PCs by Adobe SKU

The final drill through report from all of the above-noted “List” reports is:

5) Adobe Computer Details

Here is a sample screenshot of List of PCs by Adobe License Type:

Enhansoft is committed to helping you report on and better understand your software inventory.

If you have suggestions on how we can further help you keep track of your IT assets, please contact info@enhansoft.com.

Software Updates Dashboard is November’s Free SSRS Report

leaston — Thu, 17 Nov 2011 21:38:01 +0100

This is a reminder that you can still email info@enhansoft.com to request November’s free SSRS report.

Here’s a brief summary of Software Updates Dashboard:

This new addition to Enhanced Web Reporting is designed to mimic the Software Update Compliance Status Summary home page within the ConfigMgr Console.

Sample Screenshot:

SQL Server Edition Series

leaston — Wed, 16 Nov 2011 15:47:57 +0100

As part of our on-going commitment to help you better understand and report on your software inventory we announced in July the addition of the SQL Server Edition series to Enhanced Web Reporting – EWR.

These new reports cover SQL 2008 R2 all the way down to SQL 2005.

Reports in the SQL Server Edition series include:

1) Count of SQL 2008 Editions

Which will drill through to:

2) List of PCs by SQL 2008 Editions

3) Count of SQL 2005 Editions

Which will drill through to:

4) List of SQL 2005 Editions

Those following our blog postings will know that July’s free SSRS report give-away was Count of SQL 2005 Editions.

If you have suggestions on how we can further help you keep track of your IT assets, please contact info@enhansoft.com.

Reminder to Vote for December’s Free SSRS Report

leaston — Tue, 15 Nov 2011 22:18:06 +0100

Vote for either:

Count of PCs by Last Inventory or Microsoft Office Details 2010.

to become Enhansoft’s free SSRS report in December.

We are pleased to announce that myITforum.com is once again hosting the poll, so vote for your favorite report at:

http://myitforum.com/myitforumwp/2011/11/02/help-choose-enhansofts-next-free-sql-server-reporting-services-ssrs-report-for-the-month-of-december-2011/

Thank you for voting!

Diving Deep in the SCCM data! Bring your Swim trunks! – Part 2

Garth — Mon, 14 Nov 2011 16:07:00 +0100

While away on holidays, I was asked what does the “Diving Deep in the SCCM data! Bring your Swim trunks!” SSRS report look like. Well here it is!

The RDL file for this report is within the ZIP file on http://support.enhansoft.com/Blogs/post/Diving-Deep-in-the-SCCM-data!-Bring-your-Swim-trunks!.aspx along with the PPT.

Here is how to manually upload the RDL file to your SSRS site
http://support.enhansoft.com/Blogs/post/How-to-upload-a-report-manually-to-SQL-Server-Reporting-Services-(SSRS).aspx

And you will also need to change the Datasource too.
http://support.enhansoft.com/Blogs/post/How-to-Change-the-SSRS-Datasource.aspx

Enhansoft’s EWR Microsoft Office 2010 Series

leaston — Wed, 09 Nov 2011 18:43:49 +0100

Last week we announced that the SSRS report, Microsoft Office Details 2010, was one of the options that you could vote for to become December’s winning free SSRS report. You still have time to vote as the poll will close on November 30.

Did you know that this is a report found in Enhansoft’s brand new Microsoft Office 2010 Series?

This series was added to Enhanced Web Reporting - EWR in September as part of our on-going commitment to help you report on and better understand your software inventory.

The reports found in this series will enhance your understanding of your Microsoft Office 2010 environment.

Reports in the Microsoft Office 2010 series include:

1) Count of Office SKU (Office 2010)

Which will drill through to:

2) List of PCs By Office SKU (Office 2010)

3) Count of Office License Type (Office 2010)

Which will drill through to:

4) List of PCs By Office License Type (Office 2010)

5) Count of Office Release Version (Office 2010)

Which will drill through to:

6) List of PCs By Office Release Version (Office 2010)

The final drill through report from all of the above-noted “List” reports is:

7) Microsoft Office Details 2010 (for a Computer)

If you have suggestions on how we can further help you keep track of your software inventory or other IT assets, please contact info@enhansoft.com.

DevTeach/ITPro Teach Thank You

leaston — Mon, 07 Nov 2011 16:20:26 +0100

Thank you to everyone who dropped by to see us at DevTeach/ITProTeach on Friday. We enjoyed meeting all of you and we will begin sending out the free SSRS reports later today.

Here’s a reminder that Garth posted his PPT presentation and samples from his session at DevTeach/ITPro Teach, “Diving Deep in the SCCM Data! Bring Your Swim Trunks!” on Friday’s blog.

http://support.enhansoft.com/Blogs/post/Diving-Deep-in-the-SCCM-data!-Bring-your-Swim-trunks!.aspx

DevTeach Winner

garth — Fri, 04 Nov 2011 18:45:00 +0100

Congratulations to Scott K. for winning Enhansoft’s Foolish Chicken restaurant gift certificate at DevTeach.

Diving Deep in the SCCM data! Bring your Swim trunks!

Garth — Fri, 04 Nov 2011 17:45:00 +0100

Yesterday during my presentation Diving Deep in the SCCM data! Bring your Swim trunks! at DevTeach. I said that I would post the PPT and samples to my blog.

All the real “Meat” is in the RDL file.

http://www.enhansoft.com/downloads/ppt/sharks.zip

Enhansoft at DevTeach/ITPro Teach

leaston — Fri, 04 Nov 2011 01:00:00 +0100

Join us at our booth today at the Ottawa Convention Centre – Friday, November 4.

http://www.devteach.com/ITProTeach/

We’d love to meet you and as a special thank you we’ll send you the following free SSRS reports:

Count of SQL 2005 Editions

This report provides a count of all SQL 2005 editions within your environment. With this information you will know the number of SQL 2005 licenses you have. From here you can drill down further to see the report, List of PCs by SQL 2005 Edition. (In full version of EWR).

Use Count of SQL 2005 Editions to help retrieve and report on your SQL 2005 license inventory.

Find all PCs with Invalid Serial Numbers

This report provides you with a list of PCs with serial numbers that are invalid and therefore can’t be used to help track warranty information for a PC.

Operating System Details for a Computer

Operating System Details for a Computer is a SSRS report within the Operating System category found in Enhanced Web Reporting (EWR)

For each PC you will be able to see the PC name, registered user, last boot-up time and the OS install date.

See you soon!

Vote for December’s Free SSRS Report

leaston — Thu, 03 Nov 2011 17:35:20 +0100

The reports to choose from to become Enhansoft’s next free SSRS report for the month of December are:

Count of PCs by Last Inventory or Microsoft Office Details 2010.

We are pleased to announce that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://myitforum.com/myitforumwp/2011/11/02/help-choose-enhansofts-next-free-sql-server-reporting-services-ssrs-report-for-the-month-of-december-2011/

You can vote all month long and in December we will announce the winning report.

Thank you for participating, and don’t forget to request November’s free report Software Updates Dashboard, by emailing info@enhansoft.com.

Preview of SSRS Report Give-away Choices

leaston — Wed, 02 Nov 2011 18:38:03 +0100

All this month you will be able to vote for the report you would like to see become Enhansoft’s free December SSRS report give-away.

Details about how to vote for December’s free report will appear in tomorrow’s blog.

The choices are:

Count of PCs by Last Inventory or Microsoft Office Details 2010.

Both of these reports are found in Enhanced Web Reporting – EWR.

Most of your PC inventory should appear within the 0-30 day range.

Microsoft Office Details 2010 (for a Computer) will show all Microsoft Office 2010 software installed on a particular PC.

At a quick glance you will be able to know which of your Microsoft Office 2010 licenses are retail (Microsoft Visio 2010) or volume licenses (Microsoft PowerPoint 2010). You will also know the license’s release version and whether or not it is a 64-bit version.

This report will allow you to interactively sort by Product (SKU), Language, Release, x64 and License Type columns.

The Microsoft Office 2010 series is a new addition to EWR and Microsoft Office Details 2010 (for a Computer) is the final drill down report from all 3 of the following List Reports:

1) List of PCs By Office SKU (Office 2010)

2) List of PCs By Office License Type (Office 2010)

3) List of PCs By Office Release Version (Office 2010)

November’s Free SSRS Report - Software Updates Dashboard

leaston — Tue, 01 Nov 2011 20:07:04 +0100

Thank you to everyone who voted at myITforum.com!

Please email info@enhansoft.com to request November’s free SSRS report.

Tomorrow we will preview the choices for December’s free report.

Here’s a brief summary of Software Updates Dashboard:

This new addition to Enhanced Web Reporting is designed to mimic the Software Update Compliance Status Summary home page within the ConfigMgr Console.

Sample Screenshot:

Last Chance to Request Oct.’s Free SSRS Report & to Vote for Nov.’s Free SSRS Report

leaston — Mon, 31 Oct 2011 17:59:42 +0100

This is the last day to contact info@enhansoft.com to request this month’s free SSRS report, List of Superseded Software Updates.

This is also the last day to vote for November’s free SSRS report give-away.

The choices are:

Count by Chassis Types or Software Updates Dashboard.

We are pleased that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://myitforum.com/myitforumwp/2011/10/04/help-choose-enhansofts-next-free-sql-server-reporting-services-ssrs-report-for-the-month-of-november/

Tomorrow we will announce November’s winning report give-away.

DevTeach/ITPro Teach

leaston — Fri, 28 Oct 2011 16:05:42 +0100

It’s time. The first 3 people who are registered attendees at DevTeach/ITPro Teach and send an email to info@enhansoft.com will win one free hour on-site at DevTeach/ITPro Teach with our Chief Architect where they will have a custom SSRS report written for their CM07 or CM12 environments.

Good luck!

Free SSRS Reports at DevTeach/ITPro Teach

leaston — Thu, 27 Oct 2011 17:25:41 +0100

Please make sure to drop by Enhansoft’s booth at DevTeach/ITPro Teach on Nov. 4. http://www.devteach.com/

As a thank you for stopping by, we will be emailing out the following SSRS reports:

Count of SQL 2005 Editions

Use Count of SQL 2005 Editions to help retrieve and report on your SQL 2005 license inventory.

Find all PCs with Invalid Serial Numbers

This report provides you with a list of PCs with serial numbers that are invalid and therefore can’t be used to help track warranty information for a PC.

Operating System Details for a Computer

Operating System Details for a Computer is a SSRS report within the Operating System category found in Enhanced Web Reporting (EWR)

For each PC you will be able to see the PC name, registered user, last boot-up time and the OS install date.

See you on Nov. 4!

GTEC Thank You

leaston — Mon, 24 Oct 2011 16:13:18 +0100

Thank you to everyone who dropped by our booth at GTEC last week. We enjoyed meeting all of you and we will begin sending out the free SSRS reports later today.

See you next year!

Enhansoft’s Booth at GTEC

leaston — Wed, 19 Oct 2011 12:40:10 +0100

Make sure that you drop by our booth #427 today at GTEC between 9:30 a.m. and 4:30 p.m. Today is the last day of the Expo and to everyone who sees us we will be sending out 3 free SSRS reports.

See you there!

GTEC and Enhansoft

leaston — Tue, 18 Oct 2011 12:26:41 +0100

Hope to see you today or tomorrow (Oct. 18-19) at GTEC.

Drop by our booth #427 anytime between 9:30 a.m. and 4:30 p.m. at the Ottawa Convention Centre, and as a special thank you we will send you the following free SSRS reports:

Collection Metric Dashboard

This report shows the action taken (Create, Edit, Delete) by the System Center Configuration Management team in managing the lifecycle of packages over a series of months. Each of the actions is color-coded in the report for easy reference. You will see the level of effort that has been performed by the System Center Configuration Management team in the full life cycle management of deployed applications.

Operating System Details for a Computer

This SSRS report will provide you with the particulars about a PC such as PC name, registered user, last boot-up time and the OS install date.

List of PCs by Adobe License Type

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

All of these reports (and over 90 more!) are found in Enhanced Web Reporting – EWR.

For more information about GTEC please visit: http://www.gtec.ca/.

October’s Free SSRS Report

leaston — Fri, 14 Oct 2011 14:47:28 +0100

Remember that you can contact info@enhansoft.com to request this month’s free report, List of Superseded Software Updates.

We welcome your comments and suggestions, so please let us know what you think about this report and if you have suggestions about future free reports.

Once again, thank you to everyone who voted in our survey in September.

List of Superseded Software Updates

This report shows a list of all software updates that have been superseded.

Sample Screenshot:

Choose Enhansoft’s Next Free SSRS Report

leaston — Thu, 13 Oct 2011 20:15:48 +0100

The choices for November’s free SSRS report give-away are:

Count by Chassis Types and Software Updates Dashboard.

We are pleased that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://myitforum.com/myitforumwp/2011/10/04/help-choose-enhansofts-next-free-sql-server-reporting-services-ssrs-report-for-the-month-of-november/

You can vote all month long and at the beginning of November we will announce the winning report.

Enhansoft at GTEC

leaston — Wed, 12 Oct 2011 14:58:54 +0100

Join us at Canada’s Government Technology Event – GTEC – being held in Ottawa at the newly renovated Ottawa Convention Centre. Drop by our booth #427 on October 18 or 19, and as a special thank you we will send you the following free SSRS reports:

Collection Metric Dashboard

Operating System Details for a Computer

This SSRS report will provide you with the particulars about a PC such as PC name, registered user, last boot-up time and the OS install date.

List of PCs by Adobe License Type

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

All of these reports (and over 90 more!) are found in Enhanced Web Reporting – EWR.

For more information about GTEC please visit: http://www.gtec.ca/.

GTEC–Complimentary Private Sector Expo Pass

leaston — Tue, 11 Oct 2011 22:30:42 +0100

Enhansoft will be an Exhibitor at GTEC on Tuesday October 18 and Wednesday October 19. To receive a complimentary Private Sector Expo Pass please register at: http://www.gtec.ca/ and use promo code: EXPO2011.

Please don’t forget to stop by our booth #427. See you next week!

ITProTeach Special Offer

leaston — Fri, 07 Oct 2011 20:27:16 +0100

Register now for ITProTeach http://www.devteach.com/itproteach/ and use promo code: OT00NETUGC to receive $100 off of the registration fee.

Sessions include: Diving Deep in the SCCM Data, Customizing MDT 2012 to Automate Your Deployments, and Microsoft Visual Studio Lab Management 2010.

Check out all the sessions here: http://www.devteach.com/Session.aspx#161

Free Custom Report – DevTeach/ITProTeach

leaston — Thu, 06 Oct 2011 19:19:06 +0100

Our Chief Architect is NEVER busy enough! Just kidding! But, we here at Enhansoft thought that it would be a great idea to make him even busier at DevTeach/ITProTeach. http://www.devteach.com/itproteach/

If you are an attendee at DevTeach/ITProTeach (make sure that you are registered at DevTeach/ITProTeach) then follow our blogs closely because sometime between now and November 2 we will announce that the first three people who contact us will win one free hour with our Chief Architect at DevTeach/ITProTeach where they will have a custom SSRS report written for their CM07 or CM12 environments. That’s one free hour of one-on-one time. Are you kidding me??!!

Vote for November’s Free SSRS Report

leaston — Wed, 05 Oct 2011 15:48:41 +0100

The choices for Enhansoft’s next free SSRS report for the month of November are:

Count by Chassis Types and Software Updates Dashboard.

We are pleased that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://myitforum.com/myitforumwp/2011/10/04/help-choose-enhansofts-next-free-sql-server-reporting-services-ssrs-report-for-the-month-of-november/

You can vote all month long and in November we will announce the winning report.

Thank you for participating, and don’t forget to request October’s free report List of Superseded Software Updates, by emailing info@enhansoft.com.

Preview of November’s SSRS Report Options

leaston — Tue, 04 Oct 2011 16:11:46 +0100

The choices for Enhansoft’s free November SSRS report are Count by Chassis Types and Software Updates Dashboard.

Tomorrow we will tell you how you can vote for the report you want to become next month’s free SSRS report.

Count by Chassis Types

Did you ever want to know how many Rack Mount computers you have? What about laptops?

This report is for you. This report will show you a count of all the different computer types, from laptop to desktop, and from tower to Rack Mount server.

Sample Screenshot:

Software Updates Dashboard

This new addition to Enhanced Web Reporting is designed to mimic the Software Update Compliance Status Summary home page within the ConfigMgr Console.

Sample Screenshot:

October’s free SSRS report give-away is “List of Superseded Software Updates.”

leaston — Mon, 03 Oct 2011 18:57:15 +0100

Thank you to everyone who voted!

Please email info@enhansoft.com to request this month’s free report. This report will be available until October 31.

Later this week we will preview and tell you how to vote for November’s free SSRS report.

List of Superseded Software Updates

This report shows a list of all software updates that have been superseded.

Sample Screenshot:

Diving Deep into SCCM Data! Bring your Swim Trunks!

leaston — Fri, 30 Sep 2011 14:05:10 +0100

Join our Chief Architect, Garth Jones, as he dives deep into the depths of Configuration Manager. Garth will be a presenter at ITProTeach, which is part of the DevTeach conference, being held in Ottawa, Canada, on November 2-4 2011, http://www.devteach.com/itproteach/

Don’t be afraid of swimming with the sharks!

In this session, Garth will show you tricks that can be used for both SCCM 2007 and SCCM 2012. When you swim with the sharks, the tips provided in this session will help you from being eating alive. You will learn items such as how to create a template for SSRS reports that any Manager will want!

Last Chance to Request September’s Free Report & to Vote for October’s Free Report

leaston — Thu, 29 Sep 2011 16:16:06 +0100

Reminder - tomorrow is the last day to request September’s free SSRS report Count of PCs By Installed Year and Month by simply emailing info@enhansoft.com.

Also don’t forget to vote for the report you want to see become Enhansoft’s next free report give-away.

The choices to vote on for October’s free SSRS report are:

List of Superseded Software Updates and List of PCs by Hard Drive Space Used for a File Type.

We are pleased to announce that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://www.myitforum.com/absolutenm/templates/?a=26110&z=120

Next week we will announce October’s free report.

Thank you for voting!

Enhansoft at GTEC

leaston — Wed, 28 Sep 2011 18:40:46 +0100

Enhansoft is pleased to announce that it will be an exhibitor at Canada’s Government Technology Event – GTEC – being held at the Ottawa Convention Centre in October.

For more details about GTEC please go to: http://www.gtec.ca/.

SSRS Report Ideas

leaston — Tue, 27 Sep 2011 15:37:40 +0100

Since February of this year we have given away a number of free SSRS reports.

You’ve seen what we’ve done, so now here’s your opportunity to tell us what you want to see.

Please contact info@enhansoft.com with your ideas and suggestions. Thank you!

Microsoft Office Details 2010 (for a Computer)

leaston — Mon, 26 Sep 2011 14:49:33 +0100

This is our last day of previewing the Microsoft Office 2010 series. If you have any questions about this series, or Enhanced Web Reporting - EWR, please contact info@enhansoft.com.

The report Microsoft Office Details 2010 (for a Computer) will show all Microsoft Office 2010 software installed on a particular PC. This report is the final drill down report from all 3 of the following List Reports:

1) List of PCs By Office SKU (Office 2010)

2) List of PCs By Office License Type (Office 2010)

3) List of PCs By Office Release Version (Office 2010)

Here is a sample screenshot of Microsoft Office Details 2010 (for a Computer):

Enhansoft at DevTeach–Special Offer

leaston — Fri, 23 Sep 2011 19:03:46 +0100

Enhansoft is proud to announce that it is a Gold sponsor at DevTeach.

DevTeach runs from Nov. 2-4, 2011 in Ottawa at the newly renovated Ottawa Convention Centre. Please join us at our booth on Nov. 4.

For more information about DevTeach please visit: http://www.devteach.com/itproteach/

Special Offer - Register at http://www.devteach.com/Register.aspx and use the promo code ON00NEPEAN to receive $100 off the registration fee.

List of PCs By Office Release Version (Office 2010)

leaston — Fri, 23 Sep 2011 17:13:49 +0100

From Count of Office Release Version (Office 2010) which we previewed yesterday, you can drill down to the report, List of PCs By Office Release Version (Office 2010).

This report will show a list of all PCs with a particular Office 2010 Release Version installed. This report will drill down further to the report Microsoft Office Details 2010 (for a Computer) which we will preview next week.

Sample screenshot:

Free SSRS Reports

leaston — Thu, 22 Sep 2011 17:28:42 +0100

This is a reminder that you can still request September’s free SSRS report Count of PCs By Installed Year and Month by simply emailing info@enhansoft.com.

Also don’t forget to vote for the report you want to see become Enhansoft’s next free report give-away.

The choices to vote on for October’s free SSRS report are:

List of Superseded Software Updates and List of PCs by Hard Drive Space Used for a File Type.

We are pleased to announce that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://www.myitforum.com/absolutenm/templates/?a=26110&z=120

You can vote all month long and in October we will announce the winning report.

Thank you for voting!

Count of Office Release Version (Office 2010)

leaston — Thu, 22 Sep 2011 14:03:25 +0100

Continuing with our preview of Enhanced Web Reporting – EWR’s latest addition, the Microsoft Office 2010 series, the next report preview is Count of Office Release Version (Office 2010).

Count of Office Release Version (Office 2010) will show you all of the Office 2010 products installed in your environment by Release Version. This report will drill down to List of PCs By Office Release Version (Office 2010), which in turn will drill down to a further report, Microsoft Office Details 2010 (for a Computer).

Here is a sample screenshot of Count of Office Release Version (Office 2010):

How to test Data Source

Garth — Wed, 21 Sep 2011 21:10:00 +0100

Use these step to test your Data source

Launch Internet Explorer http://server name/Reports and select the Data Source. Double click the data source icon or the GUID; highlighted above.

Select Test Connection.

Notice the Successful connection message.

List of PCs By Office License Type (Office 2010)

leaston — Wed, 21 Sep 2011 14:42:17 +0100

From the report Count of Office License Type (Office 2010) which we previewed yesterday, you can drill down to the report List of PCs By Office License Type (Office 2010).

This report will show a list of all PCs with a particular Office 2010 License Type installed. This report will drill down further to Microsoft Office Details 2010 (for a Computer).

Sample screenshot of List of PCs By Office License Type (Office 2010):

Count of Office License Type (Office 2010)

leaston — Tue, 20 Sep 2011 13:23:48 +0100

Continuing with our preview of Enhanced Web Reporting – EWR’s latest addition, the Microsoft Office 2010 series, the next report preview is Count of Office License Type (Office 2010).

Count of Office License Type (Office 2010) will show you all of the Office 2010 products installed in your environment by License Type. This report will drill down to List of PCs By Office License Type (Office 2010), which in turn will drill down to a further report, Microsoft Office Details 2010 (for a Computer).

Here is a sample screenshot of Count of Office License Type (Office 2010):

Patch compliance progression report

Garth — Tue, 20 Sep 2011 02:08:00 +0100

Over on the myITforum mailing there has been some discussion about one of our reports. Our SSRS reports are based on my original version on my personal blog site. http://smsug.ca/blogs/garth_jones/archive/2009/02/25/patch-compliance-progression-report.aspx

What is different between the one of my blog site and the Enhanced Web Report (EWR) version, is that the EWR version will look at only approved software updates and you can drill down to the details for each PCs to see what SU are missing.

List of PCs By Office SKU (Office 2010)

leaston — Wed, 14 Sep 2011 14:52:07 +0100

Continuing with the Microsoft Office 2010 series found in Enhanced Web Reporting – EWR from the report Count of Office SKU (Office 2010) which was previewed yesterday, you can drill down to the report, List of PCs By Office SKU (Office 2010).

This report will show a list of all PCs with a particular Office 2010 product installed. This report will then drill down to a further report, Microsoft Office Details 2010 (for a Computer).

Here is a sample screenshot of List of PCs By Office SKU (Office 2010):

Count of Office SKU (Office 2010)

leaston — Tue, 13 Sep 2011 14:51:43 +0100

Today is the first preview of the Microsoft Office 2010 series found in Enhanced Web Reporting – EWR.

Count of Office SKU (Office 2010) will show you all of the Microsoft Office 2010 products installed in your environment by Product (SKU). This report will drill down to List of PCs By Office SKU (Office 2010), which in turn will drill down to a further report, Microsoft Office Details 2010 (for a Computer).

Here is a sample screenshot of Count of Office SKU (Office 2010):

Microsoft Office 2010 EWR Reports

leaston — Mon, 12 Sep 2011 20:05:39 +0100

Enhansoft’s Enhanced Web Reporting – EWR continues to grow. In July we told you how we added new reports to give you more details about SQL server licenses within your environment and that we added the Metric Dashboard series.

Today we would like to announce that we have added a Microsoft Office 2010 category.

These reports will enhance your understanding of your Microsoft Office 2010 environment.

Reports in the Microsoft Office 2010 series include:

1) Count of Office SKU (Office 2010)

2) List of PCs By Office SKU (Office 2010)

3) Count of Office License Type (Office 2010)

4) List of PCs By Office License Type (Office 2010)

5) Count of Office Release Version (Office 2010)

6) List of PCs By Office Release Version (Office 2010)

7) Microsoft Office Details 2010 (for a Computer)

Over the next few days we will preview each of these reports.

Vote for October’s Free SSRS Report

leaston — Thu, 08 Sep 2011 15:04:23 +0100

The choices for Enhansoft’s next free SSRS report for the month of October are:

List of Superseded Software Updates and List of PCs by Hard Drive Space Used for a File Type.

We are pleased to announce that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://www.myitforum.com/absolutenm/templates/?a=26110&z=120

You can vote all month long and in October we will announce the winning report.

Thank you for participating, and don’t forget to request September’s free report Count of PCs By Installed Year and Month, by emailing info@enhansoft.com.

Preview of October’s free SSRS report options

leaston — Wed, 07 Sep 2011 20:37:35 +0100

The choices for Enhansoft’s free October SSRS report are List of Superseded Software Updates and List of PCs by Hard Drive Space Used for a File Type.

Tomorrow we will tell you how you can vote for the report you want to become next month’s free SSRS report.

List of Superseded Software Updates

This report shows a list of all software updates that have been superseded.

Sample Screenshot of List of Superseded Software Updates:

List of PCs by Hard Drive Space Used for a File Type

This report shows a list of PCs for a particular file type and how much disk space is used by those file types.

Sample Screenshot of List of PCs by Hard Drive Space Used for a File Type:

Enhansoft’s Count of PCs By Installed Year and Month–This Month’s Free SSRS Report

leaston — Tue, 06 Sep 2011 17:17:41 +0100

Please contact info@enhansoft.com to request September’s free report, Count of PCs By Installed Year and Month. We will start sending the report out later this week.

Thank you to everyone who voted at myITforum.com!

Last day to request Enhansoft’s free August SSRS report

leaston — Wed, 31 Aug 2011 14:59:44 +0100

Today is your last chance to email info@enhansoft.com to request August’s free report, Package Metric Dashboard.

Package Metric Dashboard shows the action taken (Create, Edit, Delete) by the System Center Configuration Management team in managing the lifecycle of packages over a series of months.

Each of the actions is color-coded for easy reference. Create = Green, Edit = Steel, Delete = Maroon.

This report demonstrates the level of effort that has been performed by the System Center Configuration Management team in the full life cycle management of applications deployed for a company.

Sample screenshot:

Last Reminder to Vote for September’s Free SSRS Report

leaston — Mon, 29 Aug 2011 18:20:54 +0100

You have all day today, Tuesday and Wednesday to vote for the report you would like to see become Enhansoft’s free September SSRS report give-away.

The reports to choose from are:

Microsoft Office Details 2007and

Count of PCs By Installed Year and Month.

We are pleased that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://www.myitforum.com/absolutenm/templates/site.aspx?articleid=25638&zoneid=120

We will announce September’s report winner next week. Thank you for voting!

August’s Free SSRS Report–Package Metric Dashboard

leaston — Thu, 18 Aug 2011 21:02:57 +0100

Email info@enhansoft.com to request this month’s free report, Package Metric Dashboard.

Package Metric Dashboard shows the action taken (Create, Edit, Delete) by the System Center Configuration Management team in managing the lifecycle of packages over a series of months.

Each of the actions is color-coded for easy reference. Create = Green, Edit = Steel, Delete = Maroon.

This report demonstrates the level of effort that has been performed by the System Center Configuration Management team in the full life cycle management of applications deployed for a company.

Here is a sample screenshot:

Reminder to Vote for September’s Free SSRS Report

leaston — Wed, 17 Aug 2011 20:33:41 +0100

The options for Enhansoft’s free September SSRS report are:

Microsoft Office Details 2007 and Count of PCs By Installed Year and Month.

You need to vote for the one you would like to be our give-away report. The last day to vote will be August 31.

We are pleased that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://www.myitforum.com/absolutenm/templates/site.aspx?articleid=25638&zoneid=120

At the beginning of September we will announce the winner. Thank you for voting!

Help choose Enhansoft’s next free SSRS Report

leaston — Thu, 04 Aug 2011 16:35:10 +0100

The choices for Enhansoft’s next free SSRS report for the month of September are Microsoft Office Details 2007 and Count of PCs By Installed Year and Month.

We are pleased to announce that myITforum.com is once again hosting the poll, so please vote for your favorite report at:

http://www.myitforum.com/absolutenm/templates/site.aspx?articleid=25638&zoneid=120

Thank you for participating, and don’t forget to request this month’s free report, Package Metric Dashboard, by emailing info@enhansoft.com.

Preview of September’s Give-away Choices

leaston — Wed, 03 Aug 2011 15:27:04 +0100

The choices for Enhansoft’s free September SSRS report are Microsoft Office Details 2007 and Count of PCs By Installed Year and Month.

Microsoft Office Details 2007

This report shows a detailed list of all Office 2007 products installed on each PC, enabling you to keep track of the number of Office 2007 licenses within your environment.

Sample Screenshot of Microsoft Office Details 2007:

Count of PCs By Installed Year and Month

This report will help you understand the volume of OS installs by retrieving your PC installation data. The report will display each calendar year separately, so you can see how many PCs were installed each month.

Sample Screenshot of Count of PCs By Installed Year and Month:

Tomorrow we will tell you how you can vote for either of these reports to become September’s free SSRS report.

August’s Free SSRS Report - Package Metric Dashboard

leaston — Tue, 02 Aug 2011 16:54:17 +0100

Please contact info@enhansoft.com to request this month’s free report, Package Metric Dashboard.

Thank you to everyone who voted at myITforum.com!

Tomorrow we will preview the options for September’s free report.

Last chance to vote for August’s free SSRS report & to request July’s free SSRS report

leaston — Fri, 29 Jul 2011 14:44:28 +0100

The choices for August’s free SSRS report are: Package Metric Dashboard and Computer Processor Details.

myITforum.com is hosting the poll, so please vote for your favorite report at: http://www.myitforum.com/absolutenm/templates/?a=25067&z=120

This is also a reminder to contact info@enhansoft.com to request July’s free SSRS Report, Count of SQL 2005 Versions.

This report will provide a count of SQL 2005 versions within your environment. With this information you will have a better understanding of your SQL 2005 licenses.

Advertisement Metric Dashboard Preview

leaston — Thu, 28 Jul 2011 19:06:30 +0100

Today is the last day of our Metric Dashboard series preview. This series, made up of Advertisement Metric Dashboard, Collection Metric Dashboard, Program Metric Dashboard, and Package Metric Dashboard, is a new addition to Enhanced Web Reporting (EWR).

Each of the actions is color-coded for easy reference:

Accepted - No Further Status = Blue

Cancelled = Brown

Failed = Red

No Status = Gray

Succeeded = Green

Waiting = Yellow

Reboot Pending = Teal

Otherwise = Black

This report demonstrates the level of effort that has been performed by the System Center Configuration Management team in the full life cycle management of applications deployed for a company.

Here is a sample output of Advertisement Metric Dashboard:

Collection Metric Dashboard Preview

leaston — Wed, 27 Jul 2011 21:34:24 +0100

We are continuing today with our preview of the Metric Dashboard series which was recently added to Enhanced Web Reporting(EWR).

Collection Metric Dashboard shows the action taken (Create, Edit, Delete) by the System Center Configuration Management team in managing the lifecycle of packages over a series of months.

Each of the actions is color-coded for easy reference.

Create = Green

Edit = Steel

Delete = Maroon.

This report demonstrates the level of effort that has been performed by the System Center Configuration Management team in the full life cycle management of applications deployed for a company.

This report also allows you to drill through to more detailed reports about collection actions.

Here are sample outputs of Collection Metric Dashboard and Collection Action Details:

1st Annual Carol Durie Memorial Hunter Classic and Gaelic Glen Silver/Bronze Show

leaston — Wed, 27 Jul 2011 17:38:00 +0100

Last weekend 200 horses competed in and 800 people attended the 1^st Annual Carol Durie Memorial Hunter Classic and Gaelic Glen Silver/Bronze Show.

Enhansoft was proud to sponsor both events where the theme this year was “Think Pink.” Horses were braided in pink, riders wore pink, and the horses’ hind quarters were dyed with the Breast Cancer Logo.

$900 was raised for the Kemptville District Hospital Mammography Unit.

The winner of the 1^st Annual Carol Durie Memorial Hunter Classic was Exclusive and Tiffany-Heather Doyle. Tiffany donated her entire winnings of $250 to Breast Cancer.

Many thanks go out to all of the participants, volunteers and sponsors for a wonderful event!

Program Metric Dashboard Preview

leaston — Wed, 27 Jul 2011 01:16:53 +0100

Program Metric Dashboard shows the action taken (Create, Edit, Delete) by the System Center Configuration Management team in managing the lifecycle of packages over a series of months.

Each of the actions is color-coded for easy reference.

Create = Green

Edit = Steel

Delete = Maroon.

This report demonstrates the level of effort that has been performed by the System Center Configuration Management team in the full life cycle management of applications deployed for a company.

This report also allows you to drill through to more detailed reports about program actions.

Here are sample outputs of Program Metric Dashboard and Program Action Details:

Here we go again – Enhanced Web Reporting (EWR) keeps growing, Part 2!

leaston — Mon, 25 Jul 2011 17:13:40 +0100

Two weeks ago we previewed 4 new reports added to Enhanced Web Reporting (EWR) that give you more details about your SQL server licenses.

Today we would like to announce the addition of the Metric Dashboard series to EWR.

This series is made up of Advertisement Metric Dashboard, Collection Metric Dashboard, Program Metric Dashboard, and Package Metric Dashboard. All of the reports in this series are “hard” color-coded and they allow you to drill through to secondary reports.

You may recall that Package Metric Dashboard is one of the choices that you can vote for to become Enhansoft’s free August report. More details about this report and where to vote can be found at:

http://www.myitforum.com/absolutenm/templates/?a=25067&z=120 or by viewing our blogs posted on July 6 and July 7.

Once again, we would like to thank Jimmy Martin for suggesting these reports.

Over the next few days we will preview the other Metric Dashboard reports.

Count of SQL 2005 Versions – July’s free SSRS report

leaston — Thu, 21 Jul 2011 15:59:16 +0100

This is a reminder to contact info@enhansoft.com to request July’s free SSRS Report, Count of SQL 2005 Versions.

This report will provide a count of SQL 2005 versions within your environment. With this information you will have a better understanding of your SQL 2005 licenses.

Here is a sample output:

Reminder to vote for Enhansoft’s free August SQL Server Reporting Services (SSRS) Report

leaston — Wed, 20 Jul 2011 15:06:44 +0100

The choices for August’s free SSRS report are: Package Metric Dashboard and Computer Processor Details.

We are pleased to announce, once again, that myITforum.com is hosting the poll, so please vote for your favorite report at: http://www.myitforum.com/absolutenm/templates/?a=25067&z=120

Package Metric Dashboard is one of 4 reports in the metric dashboard series and we want to publically thank Jimmy Martin for suggesting this series. You may or may not have noticed, but we took Jimmy’s idea for metric dashboard reports one-step forward and for easy reference “hard” color-coded these reports.

If you would like to see sample screenshots of either Package Metric Dashboard or Computer Processor Details, please view our blog posted on July 6, or click on the above link to myITforum’s poll site.

Thank you, again, to everyone for voting.

List of PCs by SQL 2005 Edition

leaston — Fri, 15 Jul 2011 14:00:00 +0100

This is our final preview of the new SSRS reports found in Enhanced Web Reporting(EWR).

Yesterday we learned that with Count of SQL 2005 Editions you have the ability to drill down to the report List of PCs by SQL 2005 Edition. This report provides you with the PC Name, Version Number, Instance Name, and Installed Directory for a particular SQL 2005 edition.

Your inventory assessment will be complete when you know exactly which PCs have SQL 2005 installed on them.

Use Enhanced Web Reporting (EWR) to stay up-to-date with your SQL licenses.

Better understand your SQL 2005 Licensing

leaston — Thu, 14 Jul 2011 09:30:00 +0100

The next new SSRS report in our series of Enhanced Web Reporting (EWR) previews is Count of SQL 2005 Editions.

Use Count of SQL 2005 Editions to help retrieve and report on your SQL 2005 license inventory.

List of PCs by SQL 2008 Edition

leaston — Wed, 13 Jul 2011 09:30:00 +0100

We are continuing with our sneak peek of new reports that were recently added to Enhanced Web Reporting (EWR).

Yesterday we saw that with Count of SQL 2008 Editions you have the ability to drill down to the report List of PCs by SQL 2008 Edition. This report provides you with the PC Name, Version Number, Instance Name, and Installed Directory for a particular SQL 2008 edition.

Your software inventory assessment for SQL 2008 will be complete when you know exactly which PCs have this software installed on them.

Better understand your SQL 2008 Licensing

leaston — Tue, 12 Jul 2011 14:30:00 +0100

Here is the first sneak peak of one of Enhanced Web Reporting (EWR)’s new reports – Count of SQL 2008 Editions.

This report provides a count of all SQL 2008 editions within your environment. With this information you will know the number of SQL 2008 licenses you have.

From here you can drill down further to see the report, List of PCs by SQL 2008 Edition.

Use Count of SQL 2008 Editions to help retrieve and report on your SQL 2008 software.

Here we go again – Enhanced Web Reporting (EWR) keeps growing!

leaston — Mon, 11 Jul 2011 07:30:00 +0100

The latest addition to Enhansoft’s EWRincludes new reports that give you more details about SQL server licenses within your environment.

These new reports cover SQL 2008 R2 all the way down to SQL 2005.

Over the next few days, we will preview each of these reports.

Don’t feel left out if you need reports for SQL 2000. Contact us at info@enhansoft.com and we will be pleased to talk to you about your SQL reporting needs.

Let EWR help you keep compliant by retrieving your software inventory information.

2011 Carol Durie Memorial Golf Tournament

leaston — Fri, 08 Jul 2011 18:00:00 +0100

Today the 2011 Carol Durie Memorial Golf Tournament is being held at Equinelle Golf Course in Kemptville, ON. This promises to be a great day of golf, fun and raising funds for the Kemptville District Hospital Mammography Campaign. Enhansoft is proud to be a Silver sponsor of this important community event.

Vote for August’s free SSRS report

leaston — Thu, 07 Jul 2011 17:12:03 +0100

Help choose Enhansoft’s next free SQL Server Reporting Services (SSRS) report for the month of August.

The choices are: Package Metric Dashboard and Computer Processor Details.

We are pleased to announce that myITforum.com is once again hosting the poll, so please vote for your favorite report at: http://www.myitforum.com/absolutenm/templates/?a=25067&z=120

Preview of August’s Choices for Enhansoft’s SSRS Report Give-Away

leaston — Wed, 06 Jul 2011 14:41:11 +0100

The choices for August’s free SSRS report are:

Package Metric Dashboard and Computer Processor Details.

Package Metric Dashboard shows the action taken (Create, Edit, Delete) by the System Center Configuration Management team in managing the lifecycle of packages over a series of months.

Each of the actions is color-coded for easy reference. Create = Green, Edit = Steel, Delete = Maroon.

This report demonstrates the level of effort that has been performed by the System Center Configuration Management team in the full life cycle management of applications deployed for a company. It should be noted that Package Metric Dashboard is one of four reports within this series (Advertisement Metric Dashboard, Collection Metric Dashboard, Package Metric Dashboard and Program Metric Dashboard).

Here is a sample screenshot:

Computer Processor Details is a useful report to see which PCs are running a x86 OS that can also run a x64 OS. It will also provide details such as the Socket Type and CPU Manufacturer.

Here is a sample screenshot:

Tomorrow we will tell you how you can vote for either SSRS report to become August’s free give-away report.

Please do not forget to contact info@enhansoft.com to request July’s free SSRS Report, Count of SQL 2005 Versions.

If you would like to suggest future SSRS report give-aways, please email info@enhansoft.com with your ideas.

Count of SQL 2005 Versions is July’s free SSRS report

leaston — Tue, 05 Jul 2011 19:16:52 +0100

Thank you to everyone who voted for July’s free SSRS report at myITforum.com!

Contact info@enhansoft.com all this month to request your free copy of Count of SQL 2005 Versions. We will start sending out the report later this week.

If there is a SSRS report that you would like to see as one of the monthly options to be voted on, please let us know.

Carol Durie Memorial Golf Tournament for Breast Cancer

leaston — Thu, 30 Jun 2011 15:49:40 +0100

On July 8, 2011 the Carol Durie Memorial Golf Tournament for Breast Cancer will be held at Equinelle Golf Course in Kemptville, ON. Enhansoft is proud to be a Silver sponsor of this important community event.

For more information please see the facebook page: http://www.facebook.com/#!/event.php?eid=173382662703999

Reminder to vote for July’s free SSRS report & to request June’s free SSRS report

leaston — Wed, 29 Jun 2011 16:39:25 +0100

You can still vote for Enhansoft’s free July SSRS report. Your choices are: List of PCs by Mouse Name and Count of SQL 2005 Versions.

Vote for July’s free SSRS report give-away at: http://www.myitforum.com/absolutenm/templates/site.aspx?articleid=24186&zoneid

The last day to vote is tomorrow - Thursday June 30.

This is also your last chance to request June’s free SSRS report – Last Collection of Update Times.

Please contact info@enhansoft.com to request a copy of this free report.

Annual Ottawa IT Community Social Night

leaston — Thu, 16 Jun 2011 19:08:47 +0100

Enhansoft is pleased to announce that it is sponsoring the Annual Ottawa IT Community Social Night.

This event will take place at 6 p.m. on Monday June 27 at the Fox & Feather on Elgin Street. Registration is from 5:30 p.m.

Please go to: http://oitc2011social.eventbrite.com/ to register and for more information.

June’s free SSRS Report

leaston — Wed, 15 Jun 2011 15:12:20 +0100

You still have time to request June’s free SSRS report – Last Collection of Update Times.

Contact info@enhansoft.com to receive this free report.

Please don’t forget to vote for next month’s free report give-away at: http://www.myitforum.com/absolutenm/templates/site.aspx?articleid=24186&zoneid=120