Subselect Query for Reports (SQL)

By Garth Jones This post is a continuation of my series about how queries are processed. Please start with the first blog post in this series for more details. Today’s blog post will show you how to create a subselect query in order to discover which PCs do not have Microsoft Project 2010 installed using T-SQL (generally called SQL) for...

Read More»

The Subselect Query

By Garth Jones In my blog posts from last week I talked about how queries are processed and how a Not Equal To operator is processed. In this blog post I will help you write a subselect query in order to determine what PCs are missing a specific type of software. A subselect query is made up of two parts:...

Read More»

Computer Software Update Status is September’s Free SSRS Report

Get your copy of Computer Software Update Status today by emailing Info AT Enhansoft. This popular report is only free in September! Computer Software Update Status provides the overall software update compliant status for a PC. This information is useful to help ensure that your computers are up-to-date with all software updates. Also, make sure to vote in our poll...

Read More»

How Queries Are Processed

By Garth Jones A question that comes up from time to time is about how to locate PCs that do not have a specific type of software installed. A common mistake is to think that you need to use either Not Equal To or Not Like within a query. However, by using these operators in your query the end result...

Read More»

Remote Server Administration Tools (RSAT) for Windows 8.1

By Garth Jones I don’t need to tell you that Configuration Manager administrators wear many hats and perform several tasks. One of those tasks is managing users and computers in Active Directory (AD). When I needed to perform this task, I noticed that Remote Server Administration Tools (RSAT) were not installed on my Windows 8.1 x64 PC, so this blog...

Read More»

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

The report choices in September’s poll are: Count of Office SKUs (Office 2010) OR Computer Sound Card Details. Which report will get the most votes and become October’s free SSRS report? Take part in our poll and help decide! VOTE HERE! a) Count of Office SKUs (Office 2010) will show you all of the Microsoft Office 2010 products installed in...

Read More»

September’s Free SSRS Report is Computer Software Update Status

Thank you to everyone who voted in last month’s poll. The winning report with 80% of the vote is Computer Software Update Status! Get your copy today by emailing Info AT Enhansoft. This report is only free in September. Computer Software Update Status provides the overall software update compliant status for a PC. This information is useful to help ensure...

Read More»

Last Reminder to Vote for September’s Free SSRS Report

You only have a few more days left to vote. The report choices are: Computer Software Update Status OR List of PCs by Manufacturer (System Enclosure). Currently, Computer Software Update Status has 81% of the vote. If you would like to see List of PCs by Manufacturer (System Enclosure) become September’s free report make sure to vote and get your...

Read More»

Extracting the User Name From a Computer

By Garth Jones This question was asked in the Microsoft TechEd forum, “How do I get the user name from the PC name when the PC name has two different formats (XX-XX-XXX-XXXXXXX-X and XX-XX-XXX-XXXXXXX)?” In this particular case an extra character was added to certain PCs to indicate that they were rebuilt in order to avoid duplicate PC names in...

Read More»

ConfigMgr SSRS Browser and Script Issues

By Garth Jones Recently I was working at a client’s site and I ran across this error message: This page might not function correctly because either your browser does not support scripts or active scripting is disabled. The solution to this problem is simple. All you need to do is to add the CM 2012 / CM 2007 SSRS reporting...

Read More»