Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Gef Buneri on July 15, 2021, 10:05:32 AM

Title: Not ordinary ConnID format on DB
Post by: Gef Buneri on July 15, 2021, 10:05:32 AM

Hi all, hope all fine around there, and everyone's fine; in a DB I've got a table for stats that writes ConnID in a format like 3,xxxx instead of usual hex format; any clue on how to convert it? ( a doc will fit too).


Best regards,

Gef.

Title: Re: Not ordinary ConnID format on DB
Post by: gen_rtfm on July 15, 2021, 10:13:47 AM

Is it like the format of connids that are stored in infomart?

I had this problem a while back, for an ms-sql query; would that be of any use to you?

Br

Skickat från min Mi MIX 3 5G via Tapatalk

Title: Re: Not ordinary ConnID format on DB
Post by: Gef Buneri on July 15, 2021, 10:19:55 AM

Thx Gen, it could be; any idea?

Title: Re: Not ordinary ConnID format on DB
Post by: gen_rtfm on July 15, 2021, 10:39:39 AM

I'll get back to you, need to be where my workstation is at to get the expression. Might be a few hours.

Skickat från min Mi MIX 3 5G via Tapatalk

Title: Re: Not ordinary ConnID format on DB
Post by: gen_rtfm on July 15, 2021, 05:11:03 PM

Edit to give more of a complete answer:

I used
convert(varchar(16),cast(convert(bigint,[SOURCE FIELD NAME]) as varbinary(8)),2)

to restore connid to hex.

Hope it helps.

Br

Title: Re: Not ordinary ConnID format on DB
Post by: Gef Buneri on July 16, 2021, 08:20:21 AM

Thank you very much in any case for the answer, I'll try it and let you know.