Serial (hex)

PAC

0x002BFA63

0x4B6D9E8A12C6B4BB

0x002BF99C

0x57399440BFDD36D2

0x002BF9B1

0x2B7077C5384ACB07

0x002BFA71

0x4095840B77D20945

0x002BF838

0xA9C364B47D0F3810

0x002BF867

0x09D17E93B85CC0A1

0x002BF772

0xE23C7817612E2EFF

0x002BFE26

0x7A88204BBC67CEE4

0x002BF9E2

0xB85E3445C1C0A9E9

0x002BF96A

0x26F2056FCAD9C4C4

0x002BF96F

0x5D9C4E332CDE81C7

0x002BF988

0xD54616E2675AA409

0x002BF977

0x667C9296584EFFC5

0x002BF99E

0x2B6395D4F0B4DF56

0x002BF852

0x5D99AB194D0C236B

0x002BF9A5

0x52FE71348DA431FA

0x002BFA00

0x0D186A9CB95B1F6F

0x002BF84C

0xCDF799D29B9DCA0C

0x002BF83D

0x554E93625CEBFB95

0x002BF857

0x49A0872FC8D66B47

0x002C2CCA

0xAF6D7A14E25304B2

0x002C46B8

0x263950227C0CD997

0x002C47E5

0x1120B71C79F5091F

0x002C46F9

0x2FB9ABD16C0780BF

0x002C4716

0xBC5545456C1CDC6D

0x002C4FB4

0x414963145E62B809

0x002C2D9E

0x4B90B89BEFF6EE44

0x002C4749

0x3AAEA71B85950317


 

Should you need this and I’m not around, get someone with access to the production DB to run this:

  • Hex Sigfox IDs need to be converted to decimal sadly, so I use excel for that (hex2dec)


 

use DMEProduction1


 

select sSerialNumber 'Serial (decimal)', convert(varbinary(8), convert(int, sSerialNumber))  'Serial (hex)',  substring(abProductionData, 37, 16) 'PAC',  len(substring(abProductionData, 37, 16)) 'PAC Length' from  Device where sSerialNumber in 

(

2881394,

2881592,

2881597,

2881612,

2881618,

2881623,

2881639,

2881898,

2881903,

2881911,

2881928,

2881948,

2881950,

2881957,

2881969,

2882018,

2882048,

2882147,

2882161,

2883110,

2895050,

2895262,

2901688,

2901753,

2901782,

2901833,

2901989,

2903988)


 


Regards

Alex Pope