Looking for and SQL query to match CTI OS agent login ID with the Directory Number (instrument)

[NICNGUYEN]

Hi All,

I am looking for an SQL query to request the HDS database to find out which Directory Number / instrument  was associated with a specific CTI OS agent login ID.

Has anyone done such a query before ?

Thanks and Regards

Nick

[Gergely Szabo]

Hi,

yes, of course. What is your ICM version?

G.

[NICNGUYEN]

The ICM version is 8.0

Thanks

Nick

[Gergely Szabo · Accepted solution]

Hi,

this should work in 8.0 and 8.5:

SELECT

ag.PeripheralNumber AS [LoginID],

al.Extension,

al.LogoutDateTime

FROM [instance]_hds.dbo.Agent_Logout al

JOIN [instance]_awdb.dbo.Agent ag ON al.SkillTargetID = ag.SkillTargetID

Of course, replace [instance] with the ICM instance.

The query returns a table with three columns, first is the login ID aka PeripheralNumber, Extension is... well, the agent's extension, and LogoutDateTime is the timestamp when the agent logged out.

G.

[NICNGUYEN]

Hi Gergely,

Thank you very much for this query. This is exactly what I was looking for !

Best Regards

Nick