Exercise Overview:

Installing AppClarity

In this lab, you will install AppClarity onto the Application server 1ETRNAP.

Prepare the environment

In this exercise, you will prepare the lab environment with the necessary configuration and components required by AppClarity.

Confirm pre-requisites are installed

The pre-requisites for each of the AppClarity components are identified in the online documentation (http://help.1e.com).

Always refer to the product documentation for the version of software you are installing to confirm the software pre-requisites for that specific version.
The following pre-requisites are already installed and configured on 1ETRNAP

  • .NET Framework 4.5
  • MSMQ
  • IIS 7.5
  • Microsoft SQL Server 2014

You will now install the XPS Viewer Windows Server feature to view reports in the AppClarity Console.

  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 is selected and click Next
  6. On the Server Roles page, click Next
  7. On the Features page, scroll to the bottom of the Features list and select XPS Viewer, then click Next
  8. On the Confirmation page, click Install then close the wizard when the installation completes

Review IIS MIME types

The AppClarity Console Installer requires the .application, .manifest and .deploy MIME types to be defined. These are already configured on 1ETRNAP, but the following steps show how to check and configure this if necessary.

  1. On 1ETRNAP, from the Start screen open Internet Information Server (IIS) Manager
  2. Select the 1ETRNAP server and double-click the MIME Types icon on the right-hand side (in the IIS group of icons
  3. Scroll down the list of registered MIME types and confirm the following are present
  4. Extension

    MIME Type

    Entry Type










  1. If any of these MIME Types need to be added, right-click anywhere in the list and select Add… from the context menu, then enter the details from the above table into the Add MIME Type dialog box as shown below
  2. Close IIS Manager

Enable Common Language Runtime (CLR) support in SQL Server

AppClarity requires Common Language Runtime support to be enabled in SQL Server to be able to run code in SQL Stored Procedures

  1. On 1ETRNAP, from the Start screen start the SQL Server Management Studio and connect to the local server
  2. Ensure the master database is selected in the toolbar then click the New Query button
  3. In the query window, enter the following two lines
  4. exec sp_configure 'clr enabled', '1'
  5. Click the Execute button. The results will display in the Messages tab below the query window

Install AppClarity

In this exercise, you will install the AppClarity, database, server and console installer components onto 1ETRNAP.

Install AppClarity

Ensure the catalog curation process is complete by searching c:\program data\1E\AppClarity\AppClarity.Catalog.UpdateService.log for the text Curation Done. Installation of AppClarity cannot start until curation has completed.
  1. On 1ETRNAP via the SkyTap Shared Drive shortcut on the desktop navigate to 1E AppClarity - Course Content\1E AppClarity v5.2 - Course Content\ and download and copy appclarity.v5.2.100.5.zip to C:\Temp extract the folder
  2. From the Start screen right-click Command Prompt and select Run as administrator. Switch to the C:\Temp\appclarity.v5.2.100.5 directory and run the following command line:
  3. msiexec /i AppClarity.msi /l*v AppClarity-Install.log
  4. On the Welcome page click Next
  5. Accept the license agreement and click Next
  6. On the Prerequisite Checks page, ensure all the checks passed and click Next
  7. On the Setup Type page, select Custom and click Next
  8. Custom Setup enables different components to be installed on different servers. In this lab, everything is installed on 1ETRNAP, but we'll take the Custom Setup option so you get to see all the available options.
  9. On the Custom Setup page, ensure the Service, Console Installer, Database and Software Reclaimer features are selected for local installation and click Next
  10. On the License Key page copy and paste the Desktop License Key from the SkyTap Shared Drive shortcut on the desktop navigate to 1E AppClarity - Course Content\1E AppClarity v5.2 - Course Content\license.txt and repeat for the Reclaimer License Key. Click Next
  11. The Server License Key field remains blank
  12. On the System Center Configuration Manager Integration page, ensure the Would you use the Custom SCCM Uninstall feature is checked. Enter 1ETRNCM in the ConfigMgr Server box. Click Next
  13. On the 1E Catalog connection page, input 1ETRNAP into Catalog Sql Server and Catalog Web Server name and click Next
  14. On the 1E ActiveEfficiency Server URL page, enter http://1etrnap/activeefficiency as the ActiveEfficiency URL and click Next
  15. On the AppClarity Configuration page, enter your choice of Company Name (this is used to 'personalize' the AppClarity reports) and click Next
  16. On the Database Server Configuration page, leave the server as (local) and the Database Name as AppClarity and click Next

  17. On the Service Account Information page select the This Account radio button option, input 1ETRN\svc_AppClarity and use the default password. Click Next
  18. On the Console Installer Website Settings page, click Next to accept the default settings
  19. On the Ready to Install the Program page, click Install
  20. On the InstallShield Wizard Completed, note that the Launch Console Installer option is selected. Uncheck this box (we'll install the Console in the next exercise) and note the URL to which console users will connect to install the console. Click Finish to close the setup wizard

Configure AppClarity Services

As AppClarity, ActiveEfficiency and SQL Server are all running on the same server with limited resources, it is good practice to delay the startup of the AppClarity services to allow SQL Server services to finish starting before AppClarity attempts to start.

  1. From the Start screen, start Services console (services.msc) and identify the 1E AppClarity Service running as 1ETRN\svc_AppClarity and the 1E Catalog Update Service running as 1ETRN\svc_1ECatalog
  2. Double-click each of these services in turn and change the Startup Type to Automatic (Delayed Start)

Review the installation

In this task, you will observe the changes made by the AppClarity installer.

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




    Files used by the Console Installer. This folder is the physical path for the


    virtual directory in IIS.




    These are the binaries used by the 1E AppClarity service


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


    This folder contains the files to run the AppClarity System Analzyer, which allows for the tracing of inventory information from the SCCM data source through to AppClarity


    This folder contains files associated with the entitlements import tool


    This folder contains the files needed to run the software reclaimer on clients

  3. From the Start screen, start Internet Information Services Manager and locate the 1EAppClarity application in the Default Web Site
  4. The 1EAppClarity web application is simply the ClickOnce installer for the AppClarity console. AppClarity has no use for IIS other than to install the console.
  5. Open the Registry Editor (from the Start screen, start typing regedit then click regedit when it appears in the search results) and locate the HKLM\Software\1E\AppClarity registry key. Note that this key is only used for licensing
  6. There will be subfolders for different licenses, but since we're only working with the desktop side of things, you'll only see a desktop key.
  7. Locate the HKLM\Software\Wow6432Node\1E\AppClarity registry key. As a 32-bit application, the registry values that AppClarity uses for configuration are stored here
  8. Only the main installation settings are stored in the registry. Other AppClarity settings are defined in .CONFIG files in the feature binary folders (refer to the table in step 168) or in the AppClarity database.
  9. From the Start screen, start SQL Server Management Studio and expand the AppClarity database. Note that the installer has created the objects (tables, views, stored procedures etc.) in the previously empty database

  1. Note that the Service Broker has also been configured by the Database feature installation to communicate with the AppClarity service as shown below

  1. In the Security node of the AppClarity database, navigate to Roles > Database Roles and note the RoleAmpUser role that was created by the Database feature installation. This Role is granted permissions on the AppClarity database objects required by the 1E AppClarity service. View the properties of RoleAmpUser and note that the 1ETRN\svc_AppClarity account (i.e. the security context under which the 1E AppClarity service is running) is assigned to this role
  2. Browse to C:\ProgramData\1E\AppClarity. This is where you will find the AppClarity diagnostic logs. Double-click AppClarity.ServiceHost.svc_AppClarity.log to open it in the log file viewer

  1. Observe that one of the first things the service does when it starts up is to test the SQL Service Broker. If this is not running and available, the AppClarity service will terminate
  2. The service then starts to get data from the database and create the pre-compiled views in memory that it will use to serve any consoles that connect

Install the AppClarity Console

The AppClarity Console is installed from a web page using Microsoft ClickOnce (this functionality was set up by the Console Installer feature). In this exercise, you will first install the console onto the AppClarity server. You will then prepare a user in the console and have an email sent to the user so they can install the console on their workstation(s).

Note that there is no supported way to remove a ClickOnce application silently from a workstation. Once installed, the AppClarity Console can be removed using the Add Remove Programs interface. As ClickOnce applications are installed in the user's profile, they can only be removed for the logged-on user and the uninstallation requires user interaction.

Install the console on the AppClarity server

  1. On 1ETRNAP start Internet Explorer and type the following URL into the address bar


  2. If prompted by Internet Explorer Enhanced Security Configuration, simply click Add… to add the local site to the Trusted sites list
  3. When the AppClarity web page loads, click the Click to begin… button
  4. A small dialog box will appear while ClickOnce prepares for the installation. After it disappears, you may have to wait for a couple of minutes before anything happens – be patient
  5. You will be prompted with a security warning to confirm that you want to install the application. Click Install
  6. Once installed, the AppClarity console will be launched. You will be prompted to set some preferences before beginning to use the console. Click OK and you will be presented with the Preferences tab of the Configuration page in the console
  7. From the Preferences page, you can select whether you want Animation (sliding menus and pages), Display Currency, and the Home Screen you want displayed when you launch the console
  8. The AppClarity Console binaries are installed to a 'sand-box' in the user's AppData\Local\Apps\2.0 folder structure. Most of the user preferences are stored in the AppClarity database. A handful of settings that are needed when the console starts up are stored in user.config, which is created in the sandbox folder structure when the console is first closed.

Configure email settings

AppClarity Administrators can add other users through the Console. The AppClarity service will send these new users an email with instructions to install the AppClarity console. In this task you will configure the email settings used by AppClarity to send these emails to new console users. Later, you will add a user and observe the email that is sent.

  1. In the AppClarity Console, ensure the Configuration page is selected (click the icon   in the vertical toolbar on the left) and then select the Email tab
  2. Enter the following information and click Apply

    SMTP Port: 25
    Sender email address: "AppClarity Notifications" appInstaller@1etrn.local
  4. Click Apply
  5. Note that the sender email address can be any valid email address and can be given any 'friendly' name defined in quotes in the above text string.
  6. Select Console Installer. Enable Invitation Emails and in the Console Installer URL field enter http://1etrnap/1EAppClarity
  7. If you wish, you can modify the Email Template used to create the email message sent to new users. Click Apply when done
  8. This configuration will cause AppClarity to send an invitation email to all new users that are added through the console.

Add another user as a console user

In this task, you will add a new console user, who will then receive an email as configured in the previous task

  1. From the Users tab of the Configuration page, click the link that reads Click here to add a new user…and on the Properties tab of the New User form enter the following
  2. Name AppManager
    Logon 1ETRN\AppManager
    Email appmanager@1etrn.local
  3. Ensure User is enabled is the only check-box selected
  4. On the Roles tab of the form select License Editor and Product Editor (you may need to scroll right to see Product Editor). License Viewer and Product Viewer will then be automatically checked. Click Apply

Install the console on a remote workstation

You will now view the email from AppClarity and install the AppClarity Console on 1ETRNW71.

  1. On 1ETRNW71, log on as 1ETRN\AppManager and open Windows Live Mail from the Start menu. Accept the Microsoft Services Agreement if presented
  2. You should see an email in the Unread email folder from AppClarity Notifications
  3. If for any reason the email hasn't been sent or there are problems with email services in the lab environment, open Internet Explorer and browse to http://1etrnap/1EAppClarity
  4. Click on the link in the email to start the Console Installer. If presented with a dialog box to set up Internet Explorer 11, accept the defaults and click OK
  5. You will be prompted in Internet Explorer that the 'Windows Live ID Sign-in Helper' add-on from 'Microsoft Corporation' is ready for use. Click either option as this will have no impact on any of the lab exercises
  6. Close the Meet your new browser tab
  7. When the AppClarity web page loads, click the Click to begin… button
  8. From this point the installation will proceed as you saw previously
  9. Note that if you select any of the other tabs besides Preferences or Currencies in the Configuration page, that you will not have access. This is due to how the AppManager user was set up in the AppClarity console earlier.
  10. Select Products as the Home Screen on the Preferences tab and click Apply
  11. Close the AppClarity Console and log off 1ETRNW71

Lab Summary

In this lab, you have learned what preparation is required before installing AppClarity. You have installed and observed the AppClarity server components and learned how the AppClarity Console is installed from a web application that is installed as one of the AppClarity product features.
You have also used the AppClarity console to change user preferences and to configure email settings. You then added a user and observed AppClarity email notification in action.

Next Lab
Ex 5 - AppClarity 5.2 - Connectivity and Integration with ActiveEfficiency