Month: October 2015

Last Chance – List of PCs by Office Release Type (Office 2010) is October’s Free SSRS Report

Make sure to email Info AT Enhansoft TODAY for your copy of this month’s free report! The List of PCs by Office Release Type (Office 2010) report will show a list of all PCs with a particular Microsoft Office 2010 Release Type installed. Don’t forget to also vote in our poll to help choose November’s free SSRS report! We’ll announce the winning report/November’s free report next week!  

Last Chance to Help Choose Enhansoft’s Next Free SQL Server Reporting Services (SSRS) Report for the Month of November

The report choices in October’s poll are: Count of Office SKUs (Office 2013) OR List of PCs by Chassis Type. VOTE HERE! We’ll announce November’s free report next week. a) The Count of Office SKUs (Office 2013) report will show you all of the Microsoft Office 2013 products installed in your environment by stock-keeping unit (SKU). In the full-feature set this report will drill through to List of PCs by Office SKU (Office 2013), which in turn will drill through to a further report, Microsoft Office 2013 Details (for a PC). b) The List of PCs by Chassis Type report returns a list of PCs by chassis type, such as laptops, desktops, towers and rack mount servers. In the full-feature set this report will drill down to the Computer System Enclosure Details report. All of our reports have the Role...

Win Attendance to the Midwest Management Summit 2015!

HEAT Software is giving away a FULL CONFERENCE badge for the Midwest Management Summit 2015 to a random lucky winner this Friday, Oct. 30th! Complete the following entry form to see if you’ll be the lucky one! (NOTE: Winner is responsible for all travel-related expenses and must have prior management approval to attend. Void where prohibited by law. Prize valued at $1499 USD.) Survey Link: Enter Giveaway Now!

The Future of System Center Configuration Manager: Getting the Windows 10 Treatment

Significant changes are coming yet this year to the on-premises endpoint management product, System Center Configuration Manager.

Trouble Finding the Report Data Window Pane in BIDS 2008 R2/SSDT?

By Garth Jones In the past, I created a lot of reports by using Business Intelligence Development Studio (BIDS) 2005, but now I’m working on a project for a client where I need to use BIDS 2008 R2/SQL Server Data Tools (SSDT). I’m amazed at how backwards BIDS/SSDT has become in this newer version. Why is it so difficult to find basic tools, such as datasets, images, prompts, etc.? For example, in BIDS 2005, using the default window pane layout, the Report Datasets feature was right there on the left side of the screen next to the Toolbox tab. Notice that only datasets are listed there, whereas images and prompts are organized under the Report tab. In BIDS 2008 R2/SSDT, the datasets are nowhere to be found in the default window pane layout. To save you from frustration, I’ll show you exactl...

Create a Windows 10 Enterprise reference image with MDT 2013 Update 1

This summer Microsoft released what they’re calling the last version of Windows, naming it Windows 10. Organizations that are looking into deploying Windows 10 will have to evaluate what scenario they will use, e.g. In-Place Upgrade, Provisioning or the traditional way of deploying an image. In this blog post, I will go through the steps required to setup a functional build server for reference images. The goal with this blog post is for you to get up and running with a functioning build server that will create the Windows 10 Enterprise reference image for bare metal deployments.

The advantages of ITOA

There is no shortage of experts who perpetually remark the importance of a solid IT infrastructure in today’s business landscape. A far-reaching consensus among experts has long acknowledged not only that the IT infrastructure plays the role of a veritable backbone in business operations, but also that, like other business-enabling assets, it has to be properly managed. However, the focus has historically been on the IT infrastructure’s operational role: computers and computing services, whether local or cloud-based, have traditionally been viewed strictly in terms of allowing work to be done faster. A typed-up report is instantly sent by e-mail to an office from another continent; a price change can happen instantly; a spreadsheet gives, within minutes, predictions that would ...

How to Create a Prompted Query (WQL)

By Garth Jones Not too long ago, I answered a question within the ConfigMgr 2012 forums about why a prompted query wasn’t working. This led me to write a blog post about how to create a prompted query. Creating a prompted query (or WQL) is similar to creating any other query, so I won’t provide every step, only the basics. NOTE: I’m using ConfigMgr 2012 in my example, but the steps are basically the same for 2007 and 2016. 1. Open the ConfigMgr 2012 console and browse to Monitoring | Queries. Next, click on the Create Query button. 2. Provide a Name for your query and then click on Edit Query Statement… 3. Select the displayed columns that you want to see. Next, click on the Criteria tab. 4. This is where the fun begins. Click the star button. 5. Change the Criterion Type to Prompted value...

Enabling the Ruler within BIDS or SSDT

By Garth Jones The disabled ruler feature within SQL Server Data Tools (SSDT) and SQL Server Business Intelligence Development Studio (BIDS) (post SQL 2005) is one of my pet peeves! Whenever I use BIDS or SSDT I have to enable the ruler and I find this very frustrating. Since I don’t use BIDS (post SQL 2005) or SSDT that often, I sometimes spend at least an hour searching online to find out where the ruler setting is hiding. You would think that it would be straight forward (Tools | Options Menu), but it isn’t. To save you from this frustration, as well as my future self, I am putting down once and for all these crucial steps. Go to Report | View | Ruler. That’s it! Once the ruler is enabled, you can ensure that your report will fit on a standard-sized page. Unfortunately, what makes this ...

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

The report choices in October’s poll are: Count of Office SKUs (Office 2013) OR List of PCs by Chassis Type. At the moment List of PCs by Chassis Type is leading in the poll! VOTE HERE! a) The Count of Office SKUs (Office 2013) report will show you all of the Microsoft Office 2013 products installed in your environment by stock-keeping unit (SKU). In the full-feature set this report will drill through to List of PCs by Office SKU (Office 2013), which in turn will drill through to a further report, Microsoft Office 2013 Details (for a PC). b) The List of PCs by Chassis Type report returns a list of PCs by chassis type, such as laptops, desktops, towers and rack mount servers. In the full-feature set this report will drill down to the Computer System Enclosure Details report. All of our repo...

MDT Monitor Tool v1.5

Hi, It has been too long since I wrote anything but here comes a small update. Hopefully I get more time to blog all things I’ve been wanting to share soon. I have just updated my MDT Monitor Tool to version 1.5 (Download), this version adds the “Start Time” column. So if you have many deployments ongoing or finnished you can now sort on start time.   New in v1.5: Added Start Time as a value in the columns so you can sort on when a deployment was started Removed the empty column to the left.   New in v1.4: Fixed bug where Dart Remote Viewer didnt work Option to show client local time instead of UTC, edit config.xml to enable/disable   New in v1.2: Fixed Dart Remote Viewer not connection to full ip Issue: 1222   New in v1.1: Added timers for autorefresh...

Query to Find the Number of Operating Systems by PC Type

By Garth Jones In the TechNet forum, I was asked about how to query for a count of Operating Systems (OS) by virtual machine and by computer type (desktop, laptop, or server). I thought this information might be useful for everyone, so I’m sharing my query. The results will be organized into four columns. The first is OS, the second is Virtual/Physical, the third column is PC Type (Chassis) and the last column gives the total amount of devices running the specified OS. select OS.caption0 as ‘OS’, Case when RV.Is_Virtual_Machine0 = 1 then ‘Virtual’ when CS.Manufacturer0 like ‘%VMWare%’ then ‘Virtual’ else ‘Physical’ end as ‘Type’, Case SE.ChassisTypes0 when ‘1’ then ‘Other’ when ‘2’ t...