How to decode/convert the data source version field in the netqosportal.data_sources_2 table to the data source version.

Products

• CA Performance Management
• Network Observability

Issue/Introduction

How to decode/convert the data source version field in the netqosportal.data_sources_2 table to the data source version.

Environment

Release : 22.2

Resolution

1) Convert the version number to hex.

2) Break this into sets of 4 digits starting from the right.

3) Convert each set into decimal


For example, using the Windows calculator

Using the Spectrum Version from the data_sources2 table:

6192458077831207 

Start Programmer mode in Windows Calculator, and choose DEC line. Paste the version in:



Then look at the hex number.  Each set of 4 is a part of the version.  A.B.C.D

Converted to hex:

16000200040027

Break this into sets of 4 digits, starting from the right.

16 0002 0004 0027

Convert each hex to decimal and we get the version:

22.2.4.39