Enhansoft is pleased to be a sponsor of the 15^th Annual Gaelic Glen Show Tournament.

Over the course of the tournament (April 27, May 4 and May 5) 1,000 spectators enjoyed the gorgeous summer-like weather while watching participants of all ages competing for the Carol Durie Memorial Leading Rider Prize.

250 horse/rider combinations competed in this first of 11 tournaments all leading to the Provincial Finals which will be held later this year in Toronto.

Along with some serious “horsing around,” there was money being raised for the Kemptville District Hospital’s mammography campaign! $700 was raised from raffle and lemonade sales, and will be proudly donated in Carol Durie’s name.

Enhansoft sponsored the Modified Junior/Amateur Hunter Division and the champion was Marquita and Mackenzey Nadeau.

Congratulations to Mackenzey and Marquita!

Make sure to vote for your favorite report in this month’s survey. The winner will then become June’s free report.

Will it be:

Computer SQL Details

OR

List of PCs by Disk Description?

VOTE HERE!

As of today, Computer SQL Details is leading with 67% of the vote!

From time to time one of the questions we get is:

How can I determine what my SMS_provider path/name is?

This is important to know because if you do any System Center Configuration Manager 2012 / 2007 or even SMS 2003 automation with VBS or PoSH, you need to know what the provider path/name is for each site. This information can be queried within the SYDI-SCCM script to determine what the full provider path is on a site server. In this blog post we will show you the steps to use in order to locate the SMS provider manually. This can be very useful when troubleshooting.

Click Connect…

In the Namespace text box type \\<servername>\root\sms. In my example the server is called cm12-cm4.

Click Connect.

Click Enum Classes…

Locate __NAMESPACE and double-click on it.

Click Instances.

Here we see that the SMS provider name is site_CM4. This tells us that our full SMS provider path is \\cm12-cm4\root\sms\site_CM4. Now we can use this information to query our site server for all sorts of details.

This SSRS report is only free in May, so make sure to send an email to Info at Enhansoft.

List of All PCs Installed Within the Last Week will provide you with the most recent PC installation activity. This information will allow you to trouble-shoot client installation issues, or it can help you to monitor the installation process during a mass migration over a period of time.

Please Note: If any imaging, such as Windows Imaging format (WIM) or Ghost, was used then the install date might be listed as the date the image was created and not the actual install date of a particular PC.

In the full-feature set this report will drill through to a further report, Computer Operating System Details.

List of All PCs Installed Within the Last Week is from our Operating System category of reports found in Enhanced Web Reporting. This report is worth about $200, but only in May it’s free!

All of our reports integrate with SCCM 2012 and SCCM 2007.

To set default report parameters in SQL Server Reporting Services (SSRS) which is used by SCCM 2012 and 2007, using the report Overall Missing Software Update Status by Classificationas the example, first, browse to the report.

Notice that the classification report parameter is not populated.

• Click the Properties tab.

• Click the Parameters link.

• Select the Has Default check box next to classification.
• Next, select the down arrow.

Since the Overall Missing Software Update Status is a multi-select box, you need to add one row for each item that is to become the default. In our example the defaults are Critical Updates, Security Updates, and Service Packs.

• Once completed click Apply.
• Click the View tab.

From this point forward when this report is executed, all the report parameters will be prepopulated. The report will only display the classifications that have been selected within the defaults. Also notice that the report parameters are still visible and can be manually changed.

These steps may vary slightly depending on the SSRS version used; SQL 2005, SQL 2008 or SQL 2012.

VOTE HERE!

Will it be:

Computer SQL Details

OR

List of PCs by Disk Description?

In May’s survey you will get to choose between Computer SQL Details OR List of PCs by Disk Description.

Stay tuned because tomorrow we’ll tell you how you can vote for either report, or you can check back to our Free SSRS Report Webpage for more details.

Computer SQL Details will provide you with the number of SQL 2012, 2008, and 2005 licenses that you have for a specific PC.

List of PCs by Disk Description will return a list of workstations and user IDs for a particular disk description. By using the drop-down menu you can select the disk description you want to view. This report will help you locate which computers have various disk types, for example, VMs using pass-thru disks, Iomega drives, RIM BlackBerry USB Devices, or SD Storage Cards.

Both of these stand-alone reports work with SCCM 2012 and SCCM 2007, and the full-feature sets are found in Enhanced Web Reporting.

The voting was close all month-long, however, with 59% of the vote, List of All PCs Installed within the Last Week is the winning report and it becomes May’s free SSRS report!

To request this month’s free report, please send an email to Info at Enhansoft.

This report, from our Operating System category of reports, is worth about $200, but only in May it’s free!

All of our reports integrate with SCCM 2012 and SCCM 2007.

List of All PCs Installed Within the Last Week will provide you with the most recent PC installation activity. This information will allow you to trouble-shoot client installation issues, or it can help you to monitor the installation process during a mass migration over a period of time.

Please Note: If any imaging, such as Windows Imaging format (WIM) or Ghost, was used then the install date might be listed as the date the image was created and not the actual install date of a particular PC.

In the full-feature set, this report will drill through to Computer Operating System Details.

I am hosting the Ask the Experts panel session at the Ottawa IT Camp this Saturday May 4^th at 3:30 p.m.

Unlike other Ask the Experts sessions, I plan to have some fun with it. Can you say twitter races?! Or, what about funny hats?! You can see the fun via twitter; watch for the hashtag #OttITCamp

Currently our panel of experts are:

·        Islam Gomaa

·        Brad Bird

·        Sean Kearney

·        Marc Gagne

There may even be a surprise guest or two.

I hope that you can make it out on Saturday. For more details please see the Ottawa IT Camp webpage. http://www.ottawacodecamp.ca/Pages2013/Default.aspx

Today is the last day to request this month’s free report, Count of Adobe License Types.

This report is from our Adobe category of reports. It is worth about $200, but only in April it’s free! So, don’t forget to send an email to Info at Enhansoft to request it.

All of our free SSRS reports are from Enhanced Web Reporting - EWR and integrate with SCCM 2012 and SCCM 2007.

Count of Adobe License Types

As its name suggests, this report will return an overall count of your Adobe retail and volume license types.