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

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.

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.

Thank you to everyone who dropped by Enhansoft’s booth at this year’s MMS Conference.   Today is our last day, so if you still haven’t dropped by, please do. It was great to meet so many of you and to catch-up with good friends and colleagues.  The myITforum Party was a blast (a special thank you to Rod Trent and his team for organizing this annual event), and our Chief Architect, Garth Jones, once again, wasn’t stumped on the “Ask the Expert” panel.  Here’s a photo of Enhansoft’s MMS-2011 booth at the Mandalay Bay Conference Center in Las Vegas.

Enhansoft is pleased to announce that it is a co-sponsor of the myITforum.com Party at MMS-2011.

The myITforum.com Party will take place on Tuesday, March 22 from 6 to 9 p.m. in Islanders D-E-I, which is in the North Convention Center (MMS-2011 is situated in the South Convention Center, levels 2 & 3) of Mandalay Bay Resort and Casino.

To get into the party you need a ticket. If you don’t already have a reserved ticket, make sure you pick one up at the myITforum.com booth #145 when the Expo opens at 5:30 p.m. on Monday, March 21. A limited number of tickets will be handed out at the myITforum.com booth on a first come, first serve basis.

Hope to see you there!

You can still vote for Enhansoft’s April SSRS report give-away.

Go to:

http://support.enhansoft.com/Forum/default.aspx?g=posts&t=29

and click on either Package Status or Windows Experience Index to register your vote.

Here at Enhansoft we have a friendly wager about which report will win. You can read from Suzanne’s blog that she is pulling for Windows Experience Index Report to win. I agree with her comments, but only you can vote!

Remember that you can still request a license key for Advertisement Home Report, the winning choice of this month’s SSRS Report give-away vote, by contacting info@enhansoft.com.

Here are your choices for Enhansoft’s April SSRS report give-away:

Package Status Report

or

Windows Experience Index Report

Please register your vote at:

http://support.enhansoft.com/Forum/default.aspx?g=posts&t=29

Remember that you can still request a license key for Advertisement Home Report, the winning choice of this month’s SSRS Report give-away vote, by contacting info@enhansoft.com. We hope to start sending the report out later today.

This month we are introducing each SQL Reporting Service (SSRS) report before voting begins on the free report give-away.  Yesterday we introduced Enhansoft’s Package Status Report and today we are introducing Enhansoft’s Windows Experience Index Report.  Beginning tomorrow and all throughout March you will be able to vote on either of these two reports and the winner will become April’s free report give-away.

Enhansoft’s Windows Experience Index Report

This report is designed to mimic the Windows Experience Index.  This is a great report to help you understand the performance characteristics of your PC and what needs to be upgraded in order to increase its index numbers.

For more details on 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

Enhansoft’s Windows Experience Index Report:

This month we will be introducing each SQL Reporting Service (SSRS) report before voting begins on the free report give-away.  A reminder that all of these SSRS reports and many, many, more are found in Enhansoft’s Enhanced Web Reporting.  Tomorrow we will preview the second choice for April’s free SSRS report give-away.

Enhansoft’s Package Status Report

This report enhances Microsoft System Center Configuration Manager’s Package Status information by using color-coded identifiers to help users quickly determine package problems.

Three major color enhancements:

-RED – indicates that the deployment of the package failed on one or more Distribution Points (DPs).

-YELLOW – indicates that deployment is retrying on one or more DPs.

-LIGHT RED – indicates that the target number of DPs does not match the number of installed DPs.

In addition to these three major color enhancements, grey and white are also employed to make reading the report easier.

In the example below the Dell Package is retrying.

The winner of this month’s free SSRS report give-away is Advertisement Home Report.  Thank you to everyone who voted!

Please contact info@enhansoft.com for a free license key in order to download this report.  We will start sending the report out later in the week.

Stayed tuned because tomorrow we will be previewing one of the choices for April’s free SSRS report give-away.