" /> QInfo / Status Tables - ConnID format - Genesys CTI User Forum

Author Topic: QInfo / Status Tables - ConnID format  (Read 4276 times)

Offline Adam_W

  • Full Member
  • ***
  • Posts: 171
  • Karma: 0
QInfo / Status Tables - ConnID format
« on: March 03, 2009, 02:43:08 PM »
Advertisement
I notice that the ConnIDs which appear in the statserver tables are not in the same hexadecimal format as we see in the T Server logs / attached data.

Here is an example from my Status table: 38845362651778950

Is this correct or should I be using a different datatype for this column or something?  I'm using SQL 2005.

Is there any way to convert it?

Offline Timur Karimov

  • Sr. Member
  • ****
  • Posts: 415
  • Karma: 2
Re: QInfo / Status Tables - ConnID format
« Reply #1 on: March 03, 2009, 03:33:55 PM »
it's simple conversion from hex to dec. u can use MS T-SQL function "convert" for do it.