Enhansoft

Enhansoft Support and Announcement Blog

Enhansoft Selected as Best of TechEd 2014 Finalist

We are pleased to announce that Enhansoft was selected as a finalist in the Systems Management and Operations category with our product Enhanced Web Reporting for Best of TechEd 2014! “We are speechless at Enhanced Web Reporting becoming a finalist! We work tirelessly to increase the value of Enhanced Web Reporting for our clients, and we will be making a special announcement about new reports that we’re adding to Enhanced Web Reporting at TechEd,” said Chief Architect Garth Jones.

Best of TechEd 2014

Stay tuned because we’ll be letting you know what amazing SQL Server Reporting Services (SSRS) reports we will be giving away and what other special offers we have in store for TechEd 2014 attendees!

Get the Most Accurate and Up-to-Date Data Using the v_R_System_Valid SQL Query in Configuration Manager 2012

By Garth Jones

When you delete a PC from the System Center 2012 Configuration Manager (CM12) console it is NOT deleted from the database at the same time. Yes you read that right! The CM12 console does NOT delete a PC from the database right away. Depending on how you write your queries, this may affect your results and you may not get the most up-to-date information from CM 12’s database.

Let’s look at the following two simple queries.

The first query will give you a count of all software installed within your CM12 environment using the v_GS_COMPUTER_SYSTEM SQL view.

The second query will give you a count of all software installed within your CM12 environment using the v_R_System_Valid SQL view.

v_R_System_Valid Query

Notice the difference between the two results. There are over 500 missing software titles in the “Total RV” count! I only deleted 4 PCs in my test lab to show you this difference, but imagine the incorrect results that you would get for a continually changing environment with 10,000 PCs or more.

v_R_System and v_R_System_Valid

According to the CM12 online documentation the v_R_System SQL view, “Lists all discovered system resources by resource ID, resource type, whether the resource is a client, what type of client, client version, NetBIOS name, user name, operating system, unique identifier, and more.”

http://technet.microsoft.com/en-us/library/dn581928.aspx

What the CM12 online documentation does not say is that the v_R_System SQL view filters out systems that are flagged as deleted, but haven’t actually been removed from the database yet.

However, this may still give you some unexpected results, as obsolete PCs are still listed within this SQL view. Therefore, if you want to remove obsolete PCs from your query then you need to use the v_R_System_Valid SQL view.

This is what the CM12 online documentation says about the v_R_System_Valid SQL view:

Lists all discovered system resources that are not in an obsolete or decommissioned state. This view is a subset of the v_R_System view…

Obsolete PCs

What is the difference between deleted and obsolete PCs? In CM12 and CM07 a record for a PC is flagged as obsolete usually when it is replaced by a newer one for the same client. The newer record becomes the client’s current record and all old records are flagged as obsolete.

This is why you may want to filter out obsolete PCs by using the v_R_System_Valid query.

CM07 Note:

CM07 uses both the v_R_System and v_R_System_Valid SQL views, but in CM07 when you delete a PC it removes the PC from the database immediately! The only difference between the SQL views is that v_R_System_Valid filters out obsolete PC records.

Here’s the bottom line, in order to exclude deleted PCs and obsolete PCs from you query results you should always use the v_R_System_Valid SQL view. That is why at Enhansoft, in order to give you the most accurate results, we always use the v_R_System_Valid SQL view for all of our SSRS reports.

Vote for May’s Free SSRS Report!

Now’s your chance to help decide which of the following two SSRS reports will become May’s free report!

The report choices in this month’s poll are: Count of File Systems OR List of PCs by SQL 2005 Edition. Count of File Systems currently has a commanding lead with 75% of the vote.

VOTE HERE!

As mentioned first in January, all of the SSRS reports in our monthly give-away now have the Role-Based Administration (RBA) feature enabled. This means that if you are using System Center 2012 R2 Configuration Manager, these reports will work with all RBA clients. Not too worry if you aren’t using SCCM 2012 R2 because you can still run these reports as usual with SCCM 2012 and SCCM 2007.

a) Count of File Systems shows all of the file systems within your Configuration Manager/SMS environment, such as NTFS, Fat, Fat32, HGFS, VGFS, etc.

Count of File Systems

In the full-feature set, this report drills through to List of PCs by File System, which in turn will drill through to a further report, All-in-one PC View.

b) List of PCs by SQL 2005 Edition provides you with the PC Name, Version Number, Instance Name, and Install Directory for a particular SQL 2005 edition.

List of PCs by SQL 2005 Edition

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

Don’t forget to contact Info AT Enhansoft to request April’s free SSRS report, Collection Action Details.

If you would like to suggest future SSRS report give-aways, please email ewrwish At Enhansoft with your ideas.

April’s Free SSRS Report is Collection Action Details

Collection Action Details is only available for FREE in APRIL, so send an email to Info AT Enhansoft in order to get your copy today!

Thank you, again, to everyone who voted in last month’s poll. Collection Action Details was the over-whelming favorite report with 78% of the vote!

Collection Action Details allows you to see what collections (including collection IDs) were created, edited or deleted, and who performed these actions. You choose which action is depicted in the report.

April's free SSRS report has the Role-Based Administration (RBA) feature enabled. This means that if you are using System Center 2012 R2 Configuration Manager, April’s free SSRS report will work with all RBA clients! Don’t worry if you are not using SCCM 2012 R2 because you can still run this report as usual with SCCM 2012 and SCCM 2007.

Collection Action Details

Make sure to go onto our website and help choose which of the reports in this month’s poll will become May’s free SSRS report!

How to Install the Reporting Point and Reporting Services Point System Roles in SCCM 2007

By Garth Jones

To help answer a question posted in the Microsoft forums about how to install the reporting point and the reporting services point system roles in System Center Configuration Manager 2007 (CM07) I thought that I would put together a quick video and post part of our CM07 build guide. We often refer to this guide when building a CM07 site server from start to finish. To answer the question before anyone asks, yes we have a build guide for CM12 too; it is currently sitting at 200 pages! The video appears at the end of these step-by-step instructions.

Getting started I will assume that you have SSRS and the appropriate IIS setting already configured.

Reporting Point and Reporting Services Point - CM07 Console 

First, within the CM07 console, expand Site Database, then Site Management, <server name> and finally Site Settings. Now expand Site Systems and highlight and click the primary server name.

From the Actions pane, choose New Roles.

Reporting Point and Reporting Services Point - General

Ensure that the FQDN is entered and click Next >.

Reporting Point and Reporting Services Point - System Role Selection

Select Reporting point & Reporting Services point from the Available roles list. Click Next>.

Reporting Point and Reporting Services Point - Reporting Point

Use the defaults and click Next >.

Reporting Point and Reporting Services Point - Reporting Services Point

Use the default and click Next >.

Reporting Point and Reporting Services Point - Summary

Review the Summary Details. Click Next >.

Reporting Point and Reporting Services Point - Confirmation

View the results. Click Close.

By clicking on Close you finish the installation process.

Here’s the video:

Installing the Reporting Point and Reporting Services Point System Roles in SCCM 2007

Help Choose Enhansoft’s Next Free SQL Server Reporting Services (SSRS) Report for the Month of May

Thank you, again, to everyone who voted in last month’s poll. Now’s your chance to help decide which of the following two SSRS reports will become May’s free report!

The report choices in April’s poll are: Count of File Systems OR List of PCs by SQL 2005 Edition.

VOTE HERE!

As mentioned first in January, all of the SSRS reports in our monthly give-away now have the Role-Based Administration (RBA) feature enabled. This means that if you are using System Center 2012 R2 Configuration Manager, these reports will work with all RBA clients. Not too worry if you aren’t using SCCM 2012 R2 because you can still run these reports as usual with SCCM 2012 and SCCM 2007.

a) Count of File Systems shows all of the file systems within your Configuration Manager/SMS environment, such as NTFS, Fat, Fat32, HGFS, VGFS, etc.

Count of File Systems

In the full-feature set, this report drills through to List of PCs by File System, which in turn will drill through to a further report, All-in-one PC View.

b) List of PCs by SQL 2005 Edition provides you with the PC Name, Version Number, Instance Name, and Install Directory for a particular SQL 2005 edition. 

List of PCs by SQL 2005 Edition

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

Don’t forget to contact Info AT Enhansoft to request April’s free SSRS report, Collection Action Details.

If you would like to suggest future SSRS report give-aways, please email ewrwish At Enhansoft with your ideas.

Collection Action Details is April’s Free SSRS Report

Thank you to everyone who voted in last month’s poll! The over-whelming favorite report with 78% of the vote was Collection Action Details.

This SSRS report is only available for FREE in APRIL, so send an email to Info AT Enhansoft in order to get your copy today!

Collection Action Details allows you to see what collections (including collection IDs) were created, edited or deleted, and who performed these actions. You choose which action is depicted in the report.

April's free SSRS report has the Role-Based Administration (RBA) feature enabled. This means that if you are using System Center 2012 R2 Configuration Manager, April’s free SSRS report will work with all RBA clients! Don’t worry if you are not using SCCM 2012 R2 because you can still run this report as usual with SCCM 2012 and SCCM 2007.

Collection Action Details

Stay tuned because later this week we will preview the reports in this month’s poll. You will get to choose which of these reports will become May’s free SSRS report!

Last Day to Request List of PCs by Adobe SKU

Make sure to email Info AT Enhansoft TODAY in order to receive your free copy of List of PCs by Adobe SKU.

This SSRS report was the clear favorite in last month’s poll winning 70% of the vote. It is only available for free in March, so make sure to send in your request today!

List of PCs by Adobe SKU will provide you with a list of PCs that have a particular Adobe SKU installed. This SSRS report has the Role-Based Administration (RBA) feature enabled, so if you are using System Center 2012 R2 Configuration Manager this report will work with all RBA clients. Don’t worry if you are not using SCCM 2012 R2 because you can still run this report as usual on SCCM 2012 and SCCM 2007.

List of PCs by Adobe SKU

This is also the last day to vote for April’s free SSRS report on our website! Tomorrow we will announce April’s free SSRS report.

Last Reminder to Vote for Collection Action Details or List of PCs by Thermal State

Make sure to vote for your favorite SSRS report in this month’s poll because the winning report will become April’s FREE SSRS report.

Collection Action Details has increased its lead with 77% of the vote over List of PCs by Thermal State. If you want List of PCs by Thermal State to become April’s free SSRS report then make sure to vote and tell your friends and colleagues to vote as well. If you want Collection Action Details to win then make sure to check back to our poll to see if it is maintaining its lead. 

VOTE HERE! Thank you to everyone who has voted so far!

As mentioned in last month’s report preview, our SSRS reports have the Role-Based Administration (RBA) feature enabled. This means that if you are using System Center 2012 R2 Configuration Manager, these reports will work with all RBA clients. Don’t worry if you are not using SCCM 2012 R2 because you can still run these reports as usual with SCCM 2012 and SCCM 2007.

a) Collection Action Details allows you to see what collections (including collection IDs) were created, edited or deleted, and who performed these actions. You choose which action is depicted in the report.

Collection Action Details

In the full-feature set, this report is the final drill through report from Collection Metric Dashboard.

b) List of PCs by Thermal State returns a list of PCs with a particular thermal state. The thermal state is important to know as it will help you understand if a computer is potentially overheating. It should be noted that virtual machines will generally display “Other.”

List of PCs by Thermal State

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

Don’t forget to contact Info AT Enhansoft to request March’s free SSRS report, List of PCs by Adobe SKU. You only have a few more days left!

If you would like to suggest future SSRS report give-aways, please email ewrwish At Enhansoft with your ideas.

Using SCCM 2012 Application Model to Install PsExec

By Garth Jones

I do a lot of testing with PsExec because I need this tool to simulate exactly how System Center 2012 Configuration Manager (CM12) and CM07 install / run applications.

Recently, while I was doing some testing, I needed to run PsExec on one of my new servers, but I noticed that it was not installed. In order to install PsExec, I wanted to use CM12’s application model, but PsExec does NOT have a MSI file to install. It simply has an .exe file in a zip file. In lieu of a MSI file, I created a script installation application for PsExec.

If you’re ever in a similar situation, follow these steps:

First, create a registry key to use with your detection method.

[HKEY_LOCAL_MACHINE\SOFTWARE\Enhansoft\Tools]
"PSExec"="Installed"

Then create a batch file to install PsExec and place it with the unzipped source files.

copy %~dps0*.* %windir%\system32
regedit /s psexec.reg
regedit /s ES_Flag.reg

Now, in the CM12 console, click on the Create Application button in the Software Library node.

Application Model - Manually Specify Application Information

Select the “Manually specify the application information” option. Click on Next.

Application Model - General Information

Fill in the details about your application and click on Next.

Application Model - Application Catalog

Fill in the details in this dialogue box and then click on Next.

Application Model - Script Installer

Select Script Installer and then click on Next.

Application Model - Deployment Types

Click Add…

Application Model - Content

Enter the source location and the batch file information and then click on Next.

Application Model - Detection Method

Click Add Clause….

Application Model - Detection Rule

Change the Setting Type to Registry and select the registry key. In my case, in order to test the full functionality I also enabled, “This registry setting must satisfy the following rule to indicate the presence of this application,” and used “Equals” with Operator and typed in “Installed” for Value. Next, click OK and then click on Next.

Application Model - User Experience

Change the options as required and click on Summary.

Application Model - Summary

Click on Next.

Application Model - Deployment Types-Summary

Click on Summary.

Application Model - Confirm Settings

Click on Next and then click on Close.

That’s all there is to it and PsExec should install shortly. Treat this application script just as you would any other application deployment. I assigned this to my All Desktop and Server Clients collection.

Afterwards, I started thinking about how else this script installation application could be used, for example with BgInfo!