Genesys Infomart Reporting – Get ConnID from GIM database

Recently, I answered question about ‘Conn Id in Infomart?’ in SGGU(www.sggu.com) forum and referred to the link ‘Link ConnId In Infomart’.  However, requester want to retrieve Conn ID directly from Genesys Infomart. As Conn Id field is stored in decimal format in Infomart database (GIM), it was not useful as T-Server log uses hexadecimal format.

In C#, you can simply call Int64.ToString(“X”) to convert integer into hexadecimal format but there were no inbuilt functions within SQL Server. I wrote SQL Server function to convert decimal to hex as below..

Above function is Patrick Caldwell blog post about converting decimals to base numbers and big thanks to him.

Update 13-Aug-2014:

SQL query to get Conn ID from Infomart database is as below

(Visited 58 times, 1 visits today)

Tagged: , , ,

Comments: 2

  1. Mark W August 13, 2014 at 8:33 am Reply

    Thanks Lucky, this is a good one that I will take advantage of 🙂

    Mark

  2. blakshmikanth August 13, 2014 at 9:36 am Reply

    Cheers Mark

Leave a Reply

Your email address will not be published. Required fields are marked *