Enhansoft

Enhansoft Support and Announcement Blog

Last Day to Request October’s Free SSRS Report–Count of Office SKUs (Office 2010)

Make sure to email Info AT Enhansoft for your copy of October’s free report today!

Count of Office SKUs (Office 2010) will show you all of the Microsoft Office 2010 products installed in your environment by stock-keeping unit (SKU).

October's free 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.

Count of Office SKUs (Office 2010)

Happy Halloween Everyone!

Halloween

MMS 2014 – SQL and SSRS Track Social Media Links

By Garth Jones

Since a number of you have asked me for the Midwest Management Summit (MMS) social media links, I put together a list of important links focusing on the SQL/SSRS track.

Midwest Management Summit SQL/SSRS Track: http://mms2014.sched.org/overview/type/sql?iframe=no&w=&sidebar=yes&bg=no#.VFIyIhF0z9k

Facebook: https://www.facebook.com/MidwestManagementSummitMN

Twitter: @MMSMinnesota https://twitter.com/MMSMinnesota

Google+: https://plus.google.com/109505442590040552644/videos

SQL/SSRS Track Presenters:

Steve Thompson
Blog: http://stevethompsonmvp.wordpress.com/

Matthew Teegarden
Blog: http://emptygarden.info/

Garth Jones
Blog: http://be.enhansoft.com/
Twitter: @GarthMJ https://twitter.com/garthmj
Google+: https://plus.google.com/+GarthJones2006/posts

Sherry Kissinger
Blog: http://mnscug.org/blogs/sherry-kissinger

For more details about MMS 2014, see http://mms.mnscug.org/

mms2014

Last Reminder to Vote for November’s Free SSRS Report

All month-long Computer Operating System Details has received the most votes in our poll, but you can change that if you would like to see List of PCs by Number of Mouse Buttons become November’s free report by VOTING HERE! 

Here’s more information about each report to help you decide which one to vote for:

a) In the Computer Operating System Details report you will be able to see the PC name, registered user, last boot-up time and the operating system (OS) install date. This report is useful because at a quick glance you can see when a PC was last rebooted or when an OS was installed. Please Note: If any imaging, such as Windows Imaging format (WIM) or Ghost, was used then the install date might be listed as the date the image was created and not the actual install date of a particular PC.

Computer Operating System Details

In the full-feature set, this is the final drill through report from List of PCs by Installed Year and Month and List of All PCs Installed Within the Last Week.

b) List of PCs by Number of Mouse Buttons returns a list of machines for a designated number of mouse buttons. This information may be needed when planning a migration from one operating system to another.

List of PCs by Number of Mouse Buttons

In the full-feature set, this report will drill down to Computer Mouse Details.

All of our 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.

Don’t forget to contact Info AT Enhansoft to request October’s free SSRS report, Count of Office SKUs (Office 2010).

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

VotingButton

CMTrace Error - Failed to Create Temporary File

By Garth Jones

Similar to other ConfigMgr 2012 administrators, anytime I run into an issue I review the log files. Recently, I launched CMTrace on one of my servers and I kept getting this error message, “Failed to create temporary file.” I find it really difficult to review log files using Notepad (sorry @Wally_Mead) so I had to find a solution to this CMTrace problem fast.

Here’s some background information:

While testing a new application I decided to clear out the temp folder on the server that I was working on. The %temp% environment variable pointed to C:\Users\administrator.AD\AppData\Local\Temp. However, since I was remote controlled (RDP) into the server the RDP session’s %temp% was actually C:\Users\administrator.AD\AppData\Local\Temp\2. The %temp% environment variable pointed to a nonexistent folder, so this explains why I kept getting this error with CMTrace. The folder didn’t exist!

What I did:

The solution to this problem was to simply recreate the folder. Once I did this everything worked great. By the way, I have since discovered that I also could have logged off and logged on again. This also would have recreated the folder for me.

CMTrace Error

Reminder–October’s Free SSRS Report is Count of Office SKUs (Office 2010)

Make sure to email Info AT Enhansoft for your copy of October’s free report today!

Count of Office SKUs (Office 2010) will show you all of the Microsoft Office 2010 products installed in your environment by stock-keeping unit (SKU).

October's free 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.

Count of Office SKUs (Office 2010)

This report is only free in October.

MMS 2014 – SQL and SSRS Track Topics

By Garth Jones

It is official! The Midwest Management Summit (MMS) 2014 SQL and SQL Server Reporting Services (SSRS) track topics are finalized. Here’s the complete list:

SQL Refresher - Presenters: Steve Thompson & Matthew Teegarden

SQL Report Writing - Presenters: Matthew Teegarden & Garth Jones

SQL Operators - Presenters: Garth Jones & John Nelson

SQL Report Writing Next Level - Presenters: John Nelson and Garth Jones

What are Your SQL / Reporting Questions? - Presenters: Garth Jones, Sherry Kissinger, John Nelson & Steve Thompson

CM12 Data Mining - Presenters: Garth Jones & Sherry Kissinger

For more details about MMS 2014, please visit: http://mms.mnscug.org/

mms2014

Vote for November’s Free SSRS Report

Help choose Enhansoft’s next free SQL Server Reporting Services (SSRS) report for the Month of November.

The report choices in this month’s poll are: Computer Operating System Details OR List of PCs by Number of Mouse Buttons.

All month-long Computer Operating System Details has received the majority of the votes, but you can change that if you would like to see List of PCs by Number of Mouse Buttons become November’s free report by VOTING HERE!

a) In the Computer Operating System Details report you will be able to see the PC name, registered user, last boot-up time and the operating system (OS) install date. This report is useful because at a quick glance you can see when a PC was last rebooted or when an OS was installed. Please Note: If any imaging, such as Windows Imaging format (WIM) or Ghost, was used then the install date might be listed as the date the image was created and not the actual install date of a particular PC.

Computer Operating System Details

In the full-feature set, this is the final drill through report from List of PCs by Installed Year and Month and List of All PCs Installed Within the Last Week.

b) List of PCs by Number of Mouse Buttons returns a list of machines for a designated number of mouse buttons. This information may be needed when planning a migration from one operating system to another.

List of PCs by Number of Mouse Buttons

In the full-feature set, this report will drill down to Computer Mouse Details.

All of our 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.

Don’t forget to contact Info AT Enhansoft to request October’s free SSRS report, Count of Office SKUs (Office 2010).

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

Step-by-Step Instructions on How to Install a System Center 2012 Configuration Manager Client on a CentOS 7 Server

By Garth Jones

In my last two blog posts, Step-by-Step Instructions on How to Install a CentOS 7 Linux Virtual Machine in Windows Hyper-V Server, and How to Install CentOS 7 on Hyper-V With Integration Services, I showed you how to install and setup your CentOS 7 server.

In this blog post, I will show you how to install the System Center 2012 Configuration Manager (CM12) client agent on a CentOS 7 server.

  1. Download and extract the TAR files for the *nix Configuration Manager client from one of the following Links:

CM12 R2

http://www.microsoft.com/en-us/download/details.aspx?id=39360

CM12 SP1

http://www.microsoft.com/en-us/download/details.aspx?id=36212

  1. Copy all of the TAR files to your CentOS 7 server.

 

How to install a System Center 2012 Configuration Manager Client-Terminal Window

3. On your CentOS 7 server, open a Terminal Window; change the directory location to the install location, as per the above example, and change the attribute of the install file to allow for it to be executed. chmod +x install

How to install a System Center 2012 Configuration Manager Client-Command Line

4. Execute the following command line and don’t forget to adjust it for your site.

./install -mp <mp FQDN> -sitecode <side code> ccm-Universalx64.tar

For my test site, I used this command line: ./install -mp cm12-cm4.gartek.tst -sitecode cm4 ccm-Universalx64.tar (see the above screenshot).

How to install a System Center 2012 Configuration Manager Client-Wait

5. Wait until the installation is complete.

How to install a System Center 2012 Configuration Manager Client-Complete

In the above screenshot, you can see that the installation is complete.

How to install a System Center 2012 Configuration Manager Client-Update Membership

6. Move to the CM12 Console and Update Membership for the All Systems collection. However, notice that once the collection membership is refreshed that my CentOS client is not approved.

How to install a System Center 2012 Configuration Manager Client-Approve

7. Right click the client and click Approve.

How to install a System Center 2012 Configuration Manager Client-Inventory Data

8. Once the hardware inventory is returned to CM12, you will see the inventory data within Resource Explorer from your CentOS 7 server. You can then treat this client just as you would any other.

Below are a couple of useful commands to know for your CentOS 7 server.

Perform a policy request:

/opt/microsoft/configmgr/bin/ccmexec -rs policy

Perform a hardware inventory request:

/opt/microsoft/configmgr/bin/ccmexec -rs hinv

I hope that you find this blog post useful in order to manage your CentOS 7 clients.

Now that I have confirmed what steps are needed to inventory CentOS 7 servers, I can say with confidence that yes it can be done! I hope that you have found this blog post series useful.

How to Install CentOS 7 on Hyper-V With Integration Services

By Garth Jones

In my last blog post, I showed you how to install a CentOS 7 Linux virtual machine in Windows Hyper-V Server. In this blog post I will demonstrate how to install Linux integration services for Hyper-V.

STOP the installation!

I learned a few things while putting together this post. First, I was under the impression that I needed to install Hyper-V integration services. However, I found out that starting with CentOS 6.4, the Linux Integration Services for Hyper-V are included, so you do not need to install it at all!

You can read more about Hyper-V integration services here: http://technet.microsoft.com/en-US/library/dn531026.aspx

After reading about Hyper-V integration services in the above link, you’ll soon discover, like me, that Cloud support for operating systems (OS) like *nix is changing so fast that things can get out of date very quickly. Blog posts from a year ago might not be relevant any more. It is important, therefore, to review the latest documentation in order to confirm Hyper-V integration services details and to ensure that you are not missing any steps that may be required.

For example, notice within the link above that starting with CentOS 6.5, which was released on December 1, 2013 (not even a year ago), that Dynamic Memory – Hot Add is supported. In order to leverage this feature, however, you need to enable it within the CentOS server first. I enabled this feature (following the steps in the link) within my CentOS 7 server so that it can use Dynamic Memory.

Tip: One of the tricks that I learned was to enable the Graphic User Interface (GUI) for CentOS by using the following command:

yum groupinstall "GNOME Desktop" "Graphical Administration Tools"

By the way, it took ~10 minutes to install the GUI.

After installation this is what the GUI looked like:

Graphic User Interface

In tomorrow’s blog post, I will show you how to install a System Center 2012 Configuration Manager client on CentOS 7.

Step-by-Step Instructions on How to Install a CentOS 7 Linux Virtual Machine in Windows Hyper-V Server

By Garth Jones

Using System Center 2012 Configuration Manager (CM12) or CM12 R2, I wanted to confirm what steps were needed to inventory the *nix server operating system. In my example I chose CentOS 7, so over the next few blog posts I will show you how to install a CentOS 7 Linux virtual machine in Windows Hyper-V Server, how to install CentOS 7 on Hyper-V with integration services, and how to install the CM12 client agent on the CentOS 7 server.

Starting with how to install a CentOS 7 Linux virtual machine in Windows Hyper-V Server:

1. First, download CentOS 7 ISO from http://www.centos.org/.

2. While waiting for CentOS 7 ISO to download, create a virtual machine (VM) in Hyper-V, and use a legacy NIC.

3. Once the CentOS 7 ISO is downloaded, attach the ISO to the VM’s CD-ROM drive and start the VM.

How to Install a CentOS 7 Linux Virtual Machine-Install 

4. Click the letter I to install CentOS 7.

How to Install a CentOS 7 Linux Virtual Machine-Language

5. Select the appropriate language and click Continue.

How to Install a CentOS 7 Linux Virtual Machine-Network and Hostname

6. Click NETWORK & HOSTNAME.

How to Install a CentOS 7 Linux Virtual Machine-Enable NIC and Configure Hostname

7. Enable the NIC and configure the Hostname. Click Done (top left) when completed.

How to Install a CentOS 7 Linux Virtual Machine-Begin Installation

8. Click Begin Installation.

How to Install a CentOS 7 Linux Virtual Machine-Root Password

9. Click ROOT PASSWORD.

How to Install a CentOS 7 Linux Virtual Machine-Set Root Password

10. Set the Root Password and click Done.

How to Install a CentOS 7 Linux Virtual Machine-User Creation

11. Click USER CREATION.

How to Install a CentOS 7 Linux Virtual Machine-Set User Details

12. Fill in the user details and click Done.

How to Install a CentOS 7 Linux Virtual Machine-Wait

13. Wait while the CentOS 7 server completes the set-up.

How to Install a CentOS 7 Linux Virtual Machine-Reboot

14. Once the configuration is complete, click Reboot.

How to Install a CentOS 7 Linux Virtual Machine-Logon

15. After the reboot, logon and you are done.

In tomorrow’s blog post I will show you how to install Hyper-V integration services and then follow that post with another about how to install the CM12 client agent on the CentOS 7 server.