Browse by Tags

Subselect Query for Reports (SQL)
18 September 14 11:20 AM | Enhansoft
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...
The Subselect Query
17 September 14 09:41 AM | Enhansoft
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 to write a subselect query in order to determine what PCs are missing a specific type...
Computer Software Update Status is September’s Free SSRS Report
16 September 14 09:56 AM | Enhansoft
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...
How a “Not Equal To” Query is Processed
11 September 14 09:41 AM | Enhansoft
By Garth Jones Building on yesterday’s blog post about how a query is processed this post will show you how a query processes the Not Equal To operator. As I explained in my last post, when a query is run it will process each row within a view or a table...
How Queries Are Processed
10 September 14 10:57 AM | Enhansoft
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...
Remote Server Administration Tools (RSAT) for Windows 8.1
09 September 14 09:35 AM | Enhansoft
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...
September’s Free SSRS Report is Computer Software Update Status
03 September 14 09:49 AM | Enhansoft
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...
Final Reminder for August’s Free SSRS Report–Computer Service Details
29 August 14 09:22 AM | Enhansoft
Computer Service Details is only available for free in August, so make sure to request your copy by sending an email to Info AT Enhansoft today! The Computer Service Details report is useful when you need to quickly review the status of each service installed...
Extracting the User Name from a Computer
27 August 14 11:37 AM | Enhansoft
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...
Computer Service Details is August’s Free SSRS Report
14 August 14 09:17 AM | Enhansoft
Computer Service Details is only available for free in August, so make sure to request your copy today by sending an email to Info AT Enhansoft . The Computer Service Details report is useful when you need to quickly review the status of each service...
Remove Old Objects From AD and SCCM
12 August 14 09:12 AM | Enhansoft
By Garth Jones System Center Configuration Manager (SCCM) is a huge product and the easiest way to get all clients into SCCM is to enable AD System Discovery (ADSD) which will discover all devices within the domain. However, doing this can expose issues...
Free Disk Space Data and SCCM 2012
07 August 14 10:55 AM | Enhansoft
By Garth Jones This question comes up from time to time, “I am not getting Free Disk Space (MB) data in Hardware 01A - Summary of computers in a specific collection report. Why?” The answer is simple. Free disk space data is not collected in System Center...
August’s Free SSRS Report is Computer Service Details
05 August 14 09:59 AM | Enhansoft
Thank you to everyone who voted in last month’s poll! With 86% of the vote, Computer Service Details is the winner which makes it August’s free SSRS report. Get your free copy today by sending an email to Info AT Enhansoft . This report is only free in...
Last Chance to Request July’s Free SSRS Report, List of PCs by Office SKU (Office 2003)
31 July 14 09:47 AM | Enhansoft
Get your free copy of List of PCs by Office SKU (Office 2003) today by sending an email to Info AT Enhansoft . This is the last day to request this report! List of PCs by Office SKU (Office 2003) will show a list of all PCs with a particular Microsoft...
Comparing Application Model With Registry Key to Application Model With File Version
24 July 14 09:56 AM | Enhansoft
By Garth Jones Previously, I published blog posts about how to use application model with a registry key to install PsExec and how to use application model with a file version to install CMTrace. A question came up about which is better to use, a registry...
More Posts Next page »

This Blog

Syndication