Search This Blog

2011-08-31

Genesys Hacking - Login/Logout SQL

Genesys stored agent login and logout entry into database table LOGIN.

Uses following SQL to determine agent login and logout event in GMT time


 SELECT "LOGIN"."SWITCHDBID",
 "LOGIN"."DNDBID",
 "LOGIN"."QUEUEDBID",
 "LOGIN"."AGENTDBID",
 "LOGIN"."PLACEDBID",
 "LOGIN"."TIME" Login_Time, login_1.time Logout_Time,
 DateAdd(s, "LOGIN"."TIME", '1970-01-01') Login_Time_gmt,
 DateAdd(s, login_1.time, '1970-01-01') Logout_Time_gmt
 FROM   LOGIN LEFT OUTER JOIN LOGIN LOGIN_1 ON
 "LOGIN"."SWITCHDBID"="LOGIN_1"."SWITCHDBID"
 AND "LOGIN"."DNDBID"="LOGIN_1"."DNDBID"
 AND "LOGIN"."QUEUEDBID"="LOGIN_1"."QUEUEDBID"
 AND "LOGIN"."AGENTDBID"="LOGIN_1"."AGENTDBID"
 AND "LOGIN"."PLACEDBID"="LOGIN_1"."PLACEDBID"
 AND "LOGIN"."TIME"<"LOGIN_1"."TIME"
 WHERE
 "LOGIN"."TIME" between 1312416000 AND 1312502400
 and login.status = 1 and login_1.status = 0
 and login_1."TIME" between 1312416000 AND 1312502400

No comments:

Blog Archive