Exercise Overview:

Installing the 1E Catalog and ActiveEfficiency

The heart of AppClarity is the Catalog. It consists of a database of thousands of applications and their characteristic signatures. When these applications are discovered in an enterprise, they can be easily and automatically identified and organized into products. In this exercise, we will install the Catalog and allow the curation process to complete.

Install 1E Catalog and ActiveEfficiency

Install required Windows Role Services and Features

The 1E Catalog and ActiveEfficiency requires different Windows Roles and Features to be installed, which you will do in this task.

1ETRNAP


  1. Log on to 1ETRNAP as 1ETRN\AppInstaller and start Server Manager
  2. From the Manage menu (top-right menu bar) select Add Roles and Features to start the Add Roles and Features Wizard
  3. On the Before you begin page click Next
  4. On the Installation Type page ensure Role-based or feature-based installation is selected and click Next
  5. On the Server Selection page, ensure the local server (1ETRNAP.1ETRN.LOCAL) is selected and click Next
  6. On the Server Roles page, locate and expand the Web Server (IIS) server role then expand the Web Server role service below that
  7. Expand Common HTTP Features and select Default Document and Static Content
  8. Expand Performance and enable Static Content Compression
  9. Expand Security and select Windows Authentication
  10. Windows Authentication is not a requirement for ActiveEfficiency, although it can optionally be used to control access to data through the ActiveEfficiency web API.
  11. Expand Application Development and select ASP.NET 4.6. You will be prompted to add the ISAPI Filters, ISAPI Extensions and .NET Extensibility 4.6 role services required by ASP.NET 4.6. Click Add Features to include these then click Next
  12. On the Features page, scroll down and select Message Queuing then click Next

  1. The Confirmation page should now show the following Role Services and Features

  1. Click Install
  2. When the installation completes, Close the wizard

Install the 1E Catalog

1ETRNAP 
  1. On 1ETRNAP via the SkyTap Shared Drive shortcut on the desktop navigate to 1ECatalog\1ecatalog.v1.0.200.662\ and download and copy 1ECatalog.msi to C:\Temp
  2. From the Start screen right-click Command Prompt and select Run as administrator. Switch to the C:\Temp directory and run the following command line:
  3. msiexec /i 1ECatalog.msi /l*v 1ECatalog-Install.log
  4. On the Welcome page click Next
  5. Accept the license agreement on the License Agreement page and click Next
  6. On the Destination Folder page click Next
  7. On the Service account page, enter the following information and click Next
  8. Username: 1ETRN\svc_1ECatalog
    Password: Passw0rd
  9. On the Database Server Configuration page, select the server as (local) and the Database Name as 1ECatalog and click Next
  10. On the 1E Cloud Catalog page, deselect the Download/Upload Catalog Updates checkbox. Click Next
  11. In order to optimize the time we are spending on the lab exercises, we disable the cloud catalog upload/download feature. It is best practice that the upload/download functionality is enabled in a production environment
  12. On the Ready to Install the Program page, click Install
  13. Click Finish when the wizard completes

Review the Installation

  1. Open Windows Explorer and browse to C:\Program Files\1E\Catalog. Note the following subfolders
  2. Folder

    Description

    CatalogUpdateService

    These are the binaries used by the 1E AppClarity Catalog Update Service, which synchronizes the AppClarity Catalog through the ActiveEfficiency Cloud Service

    CatalogWebUI

    Files used by the Catalog web service

    Database

    This folder contains all the binary files used to configure the AppClarity SQL database. Using compiled code to manage the SQL configuration enables AppClarity to be easily patched using Windows Installer patches (MSP)

  3. From the Start screen, start Internet Information Services Manager and locate the CatalogWeb application pool in the Application Pools
  4. Locate the CatalogWeb application in the Default Web Site
  5. From the Start screen, start SQL Server Management Studio and expand the Databases folder and the 1ECatalog database. Note the objects: tables, views, stored procedures(found under programmability)
  6. Open Internet Explorer. Navigate to http://localhost/catalogweb. The page will be incomplete until the curation is complete, but observe the page briefly and then go ahead and close the browser
  7. In the lab environment, it will take a little while (approximately 50 minutes) for the curation of the 1E Catalog to complete. The catalog web page will not display all Vendors until the curation is complete, nor will it allow for filtering or any other operations via the web. You can look at the AppClarity.Catalog.UpdateService.log in C:\ProgramData\1E\AppClarity and look for a line that states: Curation Done. This will indicate that the Catalog installation process is complete. Once the curation is complete, you will be able to see all vendors and products listed in the CatalogWeb webpage.

Installing and configuring ActiveEfficiency

In this exercise, you will learn how to install and configure ActiveEfficiency Server for use with AppClarity.

ActiveEfficiency Server is used in different ways by other 1E solutions. This course covers the basic steps required to install ActiveEfficiency for use with AppClarity. Please refer to the ActiveEfficiency documentation if you are planning to implement other 1E solutions in the same environment.
In this lab environment ActiveEfficiency Server is installed on the same server as AppClarity. In a production environment, you should host ActiveEfficiency on a separate server or servers adequately configured to support the functionality and scale required. Refer to the ActiveEfficiency documentation for further information on ActiveEfficiency Server sizing and capacity planning.

Install ActiveEfficiency Server

In this task, you will install ActiveEfficiency Server on the Application server (1ETRNAP)

1ETRNAP
  1. On 1ETRNAP via the SkyTap Shared Drive shortcut on the desktop navigate to 1EActiveEfficiency\activeefficiency.v1.9.800.6 and download and copy ActiveEfficiencyServer.msi to C:\Temp
  2. From the Windows Start screen, right-click Command Prompt and select Run as administrator
  3. Switch to the C:\Temp directory and run the following command line to start the ActiveEfficiency installation wizard
  4. msiexec /i ActiveEfficiencyServer.msi /l*v AEServer-Install.log
  5. On the Welcome page click Next
  6. On the License Agreement page select I accept the terms in the license agreement and click Next
  7. On the Prerequisite Checks page, ensure all checks have passed and click Next
  8. On the Enable 1E ActiveEfficiency Cloud Connection page, ensure Yes I want to register with 1E ActiveEfficiency is UNCHECKED and click Next
  9. On the Destination Folder page accept the default location and click Next
  10. On the Database Server page select the (local) database server and leave the database name as ActiveEfficiency. Click Next
  11. In production environments it is best practice to create the ActiveEfficiency database at the required size prior to running the installation to avoid the database files having to auto-grow considerably, which would impact performance. The database creation by the installer will take several minutes once installation begins.
  12. On the ActiveEfficiency Website Settings page click Next
  13. On the Nomad synchronization page click Next
  14. On the Ready to Install the Program page click Install
  15. When the wizard completes, click Finish

Review the installation

In this task, you will observe the changes made by the ActiveEfficiency server installation

1ETRNAP
  1. Browse to C:\Program Files (x86)\1E\ActiveEfficiency and note the following folders
  2. Folder

    Description

    Database

    Files used to create and manage the database

    DeployCertificate

    Binaries associated with deploying a certificate to the client for communication with the 1E ActiveEfficiency cloud service

    Service

    Binaries associated with the ActiveEfficiency service

    Web

    Binaries associated with the ActiveEfficiency Web Service

  3. Browse to C:\ProgramData\1E\ActiveEfficiency. This is where the ActiveEfficiency service log can be found. Open service.log and observe the startup activity
  4. From the Windows Start screen click Services and note the 1E ActiveEfficiency service, which runs in the context of the Network Service account
  5. Open the Internet Information Services(IIS) Manager and expand the 1ETRNAP server node
  6. Select the Application Pools node and note the ActiveEfficiency Application Pool, running with the identify of NetworkService
  7. Expand the Default Web Site and select the ActiveEfficiency Web Site. Click the Basic Settings link (under Actions on the right) and note that the physical location is the Web\WebService folder identified in step 43
  8. From the Start screen, open Internet Explorer and browse to http://localhost/activeefficiency
  9. This page provides a simple interface to the ActiveEfficiency web service. URI's are provided for scouts, devices and applications, but these will yield no results until the scout has been run. Leave this page open for later use.
  10. Open the Registry Editor (from the Start screen, type regedit then click the regedit icon in the search results) and navigate to HKLM\Software\Wow6432Node\1E\ActiveEfficiency
  11. The values in this registry key define the ActiveEfficiency website settings, SQL server instance and certificate subject of the certificate used to secure communication with the 1E ActiveEfficiency Cloud Service.
  12. From the Start screen, start SQL Server Management Studio and connect to the local server. Expand the Databases node and note the ActiveEfficiency database
  13. Expand the ActiveEfficiency database and review the tables

Set the 1E ActiveEfficiency Service to delayed start

In this lab, the ActiveEfficiency service is installed on the same server as SQL Server used for the ActiveEfficiency database. Due to the relatively low hardware specification of the server in this lab environment, SQL Server may not be ready at the point where the ActiveEfficiency service starts up. In this task, you will set the ActiveEfficiency service to delayed start to give SQL server time to start. This will ensure that services start up properly in the event the server needs to be restarted.

1ETRNAP
  1. On 1ETRNAP from the Start screen click Services
  2. Right-click the 1E ActiveEfficiency service and select Properties
  3. Change the Startup type to Automatic (Delayed Start) and click OK
  4. Close the Services interface

Install the ActiveEfficiency Scout

The ActiveEfficiency Scout is the component that collects inventory data from the Microsoft System Center Configuration Manager (ConfigMgr) database and stores it in the ActiveEfficiency database for other 1E applications to use. In this exercise, you will install the scout on the Application Server (1ETRNAP).

Grant the installer account read access to ConfigMgr

The scout installation requires read access to the ConfigMgr database. As you are installing the Scout on the Application Server, you are logged in as the AppInstaller user. In this task, you will assign the AppInstaller account the db_datareader role on the ConfigMgr database.

1ETRNCM
  1. Log on to 1ETRNCM as 1ETRN\SCCMAdmin
  2. From the Start screen, start SQL Server Management Studio and connect to the local SQL server
  3. Expand the Security > Logins node and right-click 1ETRN\AppInstaller to open the Login Properties dialog box
  4. Select the User Mapping page on the left. In the Users mapped to this login list, select the checkbox in the Map column for the CM_PS1 database
  5. In the Database role membership for: CM_PS1 list, select db_datareader then click OK
  6. Close the SQL Server Management Studio
  7. If the login with which you install the scout doesn't already exist on the CM database, you'd need to create the login and then provision it the db_datareader access on the ConfigMgr database.

Install the ActiveEfficiency Scout

1ETRNAP
  1. On 1ETRNAP via the SkyTap Shared Drive shortcut on the desktop navigate to 1EActiveEfficiency\activeefficiency.v1.9.800.6 and download and copy ActiveEfficiencyScout.msi to C:\Temp
  2. From the Start screen, start right-click Command Prompt and select Run as administrator
  3. If User Account Control is enabled, the installer may not install the components correctly if it executed by double-clicking the MSI file. It is good practice to install the Scout from a command prompt with elevated privileges to avoid any issues with User Account Control
  4. Switch to the C:\Temp directory and run the following command line to start the Scout installation wizard
  5. msiexec /i ActiveEfficiencyScout.msi /l*v AEScout-Install.log
  6. On the Welcome page click Next
  7. On the License Agreement page, accept the license agreement and click Next
  8. On the Component Selection page ensure only the ConfigMgr component (Standard option) is selected and click Next
  9. On the Destination Folder page click Next to use the default location
  10. On the 1E ActiveEfficiency Server page click Next (ActiveEfficiency is installed on this server)
  11. On the ConfigMgr Database page enter the following details and click Next
  12. ConfigMgr Database Server: 1ETRNCM
    ConfigMgr Database Name: CM_PS1
  13. On the 1E Shopping Configuration Manager Setup page, click Next
  14. On the Ready to Install the Program page click Install
  15. When the installation wizard completes, uncheck the Launch 1E AE Sync Manager option and click Finish

Lab Summary

In this lab, you have installed ActiveEfficiency Server, ActiveEfficiency Scout and the 1E Catalog. In its current state, ActiveEfficiency will do nothing of any interest. In the next lab, you will execute the scout to get data into the ActiveEfficiency database. Once you've installed AppClarity, the ActiveEfficiency Connector will retrieve this data from the ActiveEfficiency database into the AppClarity database.


Next Lab

Ex 2 - AppClarity 5.2 - Scouting for devices and applications