Identify database, application, and importer versions

Products

• Information Centric Analytics

Issue/Introduction

How do I identify the installed version of the Information Centric Analytics (ICA) application, database, and importer versions?

Environment

Version : 6.x

Resolution

To identify the installed version of ICA, follow either of these procedures:

Portal

NOTE: This method will only return the currently installed version of ICA and its components

1. Login to the ICA portal
2. Click on the version displayed in the lower left-hand corner of the page

SQL

NOTE: This method will return the current and previously installed versions of ICA and its components

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric database
3. Open a query editor window by pressing CTRL+N, clicking the New Query button in the Standard toolbar, or, selecting New > Query with Current Connection from the File menu
4. Copy and paste the following query in the new query editor window:

   SELECT * FROM RiskFabric.dbo.Versions;

5. Execute the query by pressing F5, clicking the Execute button in the SQL Editor toolbar, or selecting Execute from the Query menu