Enhansoft

Enhansoft Support and Announcement Blog

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.

What Not to Do With MBAM and Windows 2003 Domains

By Garth Jones

Several weeks ago I was doing some work with Microsoft BitLocker Administration and Monitoring (MBAM) and setting it up within one of my test labs. This test lab was running Windows Server 2003 as the Primary Domain Controller (PDC) and the language setting was English Canada. I’m telling you this now because you’ll understand why a bit later in this post.

With MBAM, you need an Active Directory (AD) schema change if you are running Windows 2003 domain.

Here’s more information on AD schema change: http://technet.microsoft.com/en-us/library/dd875529(v=WS.10).aspx

In the documentation listed in the above-noted link there is a note that says:

“If you will use a domain controller running Windows Server 2003 with SP1 or SP2, you will need to apply the schema extension (BitLockerTPMSchemaExtension.ldf) to store BitLocker and TPM passwords in Active Directory. This file can be downloaded from the Configuring Active Directory to Back up Windows BitLocker Drive Encryption and Trusted Platform Module Recovery Information download page.”

http://www.microsoft.com/download/details.aspx?id=13432

Since the Primary Domain Control (PDC) in this test lab is Windows 2003, I performed the schema change. Once it was done I reviewed the log files and everything looked great, so I forgot about it.

A week or two later I noticed some odd network issues. Since I was away from my office, I looked at this via the VPN. I noticed that there was a DNS issue and upon researching this some more I noticed an AD issue. This AD issue lead me directly to the Microsoft KB entitled, “Error messages after you install the BitLocker Drive Encryption schema updates in a Windows Server 2003 domain.” http://support.microsoft.com/kb/932862

In this KB there is a note that says if your domain is set to English Canada you need to perform a few steps.

To keep this story short, this didn’t work for me and finally I needed to move and seize the Flexible Single Master Operations (FSMO) roles. This is not a task that anyone wants to do and they most certainly don’t want to do this while VPN’ing to their lab. I waited until I got back to my office and spoke to my friend and AD expert Craig Baltzer @Bittacle.

Finally, I successfully moved and seized the FSMO roles and everything is good again!

As a side note my friend Pierre Roman @pierreroman gave a presentation at TechEd called “DCIM-B367 It’s the End of the World As You Know It… Windows Server 2003 End of Life: Infrastructure Migration.” You can watch it on Channel 9, http://channel9.msdn.com/events/TechEd/NorthAmerica/2014/DCIM-B367#fbid=VOT7xNbvGnj.

Pierre will be happy to know that I no longer have my test lab running with Windows Server 2003!

Oops

I Will be a Presenter at MMS 2014!

By Garth Jones

What is MMS 2014?

The Midwest Management Summit 2014 is a 3-day conference running from November 10-12 in Minneapolis, Minnesota. It is capped at 500 attendees to ensure that nobody gets lost in the crowd.

As some of you know, I am excited to be a presenter in a few sessions at MMS. All of my topics will be within the SQL and SQL Server Reporting Services (SSRS) track.

After each presentation I will have time to meet and talk with you. Unlike other conferences, folks won’t be rushed out of sessions to get the next presentation going. This will allow for time to absorb what you see and for the opportunity to discuss the material presented with speakers and other attendees.

This will be a true learning experience. Real networking. Real-life issues discussed.

For more details, please visit the MMS website: http://mms.mnscug.org/

mms2014

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: Computer Operating System Details OR List of PCs by Number of Mouse Buttons.

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

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

Thank you to everyone who voted in September’s poll! With 92% of the vote Count of Office SKUs (Office 2010) becomes October’s free SSRS report.

Email Info AT Enhansoft for your copy today! This report is only free in October.

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)

Stay tuned because tomorrow we will preview the reports in October’s poll!