search cancel

Spectrumgtw Probe Incremental Sync not working

book

Article ID: 243738

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have set Incremental Inventory sync for 30 minutes from UIM OC Spectrum container inventory to Spectrum.  We are noticing that inventory only gets synced once per day (Full Inventory Sync 1:00:00)

However Incremental Synchronization is not working as intended.  Log looks fine.  If we add a server to the Spectrum Container in OC it does not sync after 30 minutes.

 

Environment

Release : 20.4

Component : UIM - SPECTRUMGTW

Resolution

The incremental sync is based on the system alive time as recorded in the UIM database CM_COMPUTER_SYSTEM table column alive_time. 

The alive_time is set via discovery_server when the device is last discovered, 
Note: credentials are not needed to reset the alive_time, if you rediscover the device using just the IP address for the scope and no credentials the alive_time will be reset. 

For all pre-existing systems that were moved into a UIM group in the Spectrum container their alive_time will be old and so the incremental sync will ignore it and only the full sync will process it. 

For newly discovered system the alive_time will be less than the 30 minute sync time and so it will be processed. 

Additional Information

This query can be used to see the alive_time for a device:
SELECT * FROM CM_COMPUTER_SYSTEM where ip = 'IP address of the device' 
or for multiple devices:
SELECT * FROM CM_COMPUTER_SYSTEM where ip IN ('IP address', 'IP address')
example:
SELECT * FROM CM_COMPUTER_SYSTEM where ip IN ('10.10.11.11', '10.11.12.12')

Note: If direct access to the UIM database is not available go to OC > SLM > 3 bar menu > SQL Query Editor. 
From here the query can be run and exported.