Duplicate computer records in IT Analytics Computer cube

Products

• IT Analytics

Issue/Introduction

In IT Analytics Computer cube view you may notice duplicates and triplicates of computer resources affecting counts and causing confudion.

Looking behind the console, we found that  data being pulled from vRM_Computer_Item view using query from vITAnalytics_CMDB_ComputerDim.

By checking further the only difference between duplicate records were values in DiscoveryDate.

 

 

Environment

IT Analytics 8.0 

Cause

Original view vITAnalytics_CMDB_ComputerDim does not have any condition to select only one from multiple possible records keys.

Resolution

For now, we have made a quick fix for stored procedure spITAnalytics_CSMP_CreateViews to prevent duplicates based on the discovery table entries.            

Duplicates will disappear after altering the spITAnalytics_CSMP_CreateViews and recreating affected views in CMDB.

To do that execute stored procedure spITAnalytics_CSMP_DeleteViews to delete all views, then use attached SQL query to ALTER spITAnalytics_CSMP_CreateViews, then execute it as well.

After changes in CMDB, please process the ITA cubes and you won't see duplicates anymore.

Note: During execution of updated stored procedure, you may get following messages:

"The module 'spITAnalytics_CSMP_CreateViews' depends on the missing object 'dbo.spITAnalytics_CMDB_GetFullyQualifiedDataSource'. The module will still be created; however, it cannot run successfully until the object exists"

You can simply ignore them.

Updated version will be added into upcoming IT Analytics 8.1 as well.