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:

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

Please VOTE for your favorite SSRS report:

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.

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 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.

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.

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.

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

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!

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.

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:

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.

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:

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