cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
1972
Views
0
Helpful
4
Replies
NICNGUYEN
Beginner

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

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

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

4 REPLIES 4
Gergely Szabo
Advocate

Hi,

yes, of course. What is your ICM version?

G.

The ICM version is 8.0

Thanks

Nick

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.

View solution in original post

Hi Gergely,

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

Best Regards

Nick

Content for Community-Ad

Spotlight Awards 2021