How to decode/convert the data source version field in the netqosportal.data_sources_2 table to the data source version.
Release : 22.2
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