Differences

This shows you the differences between two versions of the page.

--- vendors:verint:home [2018/05/17 19:56] – ↷ Page moved from code:java:vendors:verint:home to vendors:verint:home gerardorourke
+++ vendors:verint:home [2019/07/30 10:31] (current) – gerardorourke
@@ Line 1: / Line 1: @@
-==== Verint ====
+======Verint======
-[[vendors:verint:pause-and-resume]]
+  * https://www.verint.com/engagement/our-story/webinars/
+  *[[http://robingoossen.nl/blog/?p=256|CTI Tagging]]
+  *[[vendors:verint:pause-and-resume]]
+  *[[vendors:verint:SQL|SQL Queries]]
 \\
@@ Line 17: / Line 19: @@
 </code>
 \\
-===SQL Querys===
-<code>
-USE CentralContact
-SELECT
-start_time,
-end_time,
-dbs_id,
-audio_module_no,
-audio_ch_no,
-extension,
-dnis_code,
-ani,
-switch_id,
-Switch_call_id
-FROM dbo.Sessions
-WHERE
-start_time > GetDate()-1
-AND SWITCH_ID is NULL
-ORDER BY extension
-</code>
-== NO CTI SQL Queries ==
-<code>
-USE CentralContact
-SELECT
-extension, Count(*) As Count
-FROM dbo.Sessions
-WHERE
-start_time > GetDate()-1
-AND SWITCH_ID is NULL
-Group BY extension
-ORDER BY Count DESC
-</code>
-<code>
-USE CentralContact
-SELECT
-extension, Count(*) As Count
-FROM dbo.Sessions
-WHERE
-start_time > GetDate()-30
-AND Switch_call_id like 'SIP%'
-Group BY extension
-ORDER BY Count DESC
-</code>
-Shows which calls are not tagged with an Agent Name
-<code>
-USE CentralContact
-SELECT
-extension
-FROM dbo.Sessions
-WHERE
-start_time > GetDate()-20
-AND agent_id = '0'
-AND extension like '7%'
-Group By extension
-order by extension
-</code>
-User <> Groups
-<code>
-USE CentralContact
-SELECT
-Users.user_name,
-Users.role_id,
-Groups.group_name,
-Groups_to_users.group_id,
-Users.pbx_id,
-Users.winnt_login,
-Users.user_id
-FROM
-Groups_to_users
-INNER JOIN
-Groups ON Groups_to_users.group_id = Groups.group_id
-INNER JOIN
-Users ON Groups_to_users.user_id = Users.user_id
-</code>
-==USER <> specific ROLES==
-<code>
-USE BPMAINDB
-SELECT P.FIRSTNAME AS 'First Name', P.LASTNAME AS 'Last Name', B.USERNAME AS 'User Name', B.EMPLOYEEID AS 'Employee ID', A.NAME AS 'Role Name'
-FROM AUTHACCESSRIGHT AA
-INNER JOIN AUTHROLE A
-ON AA.AUTHROLEID = A.ID
-INNER JOIN BPUSER B
-ON AA.BPUSERID = B.ID
-INNER JOIN PERSON P
-ON B.EMPLOYEEID = P.ID
-WHERE A.NAME = 'Basic Replay Role'
-GROUP BY B.USERNAME, P.FIRSTNAME, P.LASTNAME, B.EMPLOYEEID, A.NAME
-ORDER BY P.LASTNAME
-</code>
-==USER <> All ROLES==
-<code>
-USE BPMAINDB
-SELECT P.FIRSTNAME AS 'First Name', P.LASTNAME AS 'Last Name', B.USERNAME AS 'User Name', B.EMPLOYEEID AS 'Employee ID', A.NAME AS 'Role Name'
-FROM AUTHACCESSRIGHT AA
-INNER JOIN AUTHROLE A
-ON AA.AUTHROLEID = A.ID
-INNER JOIN BPUSER B
-ON AA.BPUSERID = B.ID
-INNER JOIN PERSON P
-ON B.EMPLOYEEID = P.ID
---WHERE A.NAME = 'Basic Replay Role'
-GROUP BY B.USERNAME, P.FIRSTNAME, P.LASTNAME, B.EMPLOYEEID, A.NAME
-ORDER BY P.LASTNAME
-</code>
-<code>
-use BPMAINDB
-select P.firstname as 'first name', p.lastname as 'last name',
-b.username as 'username', b.employeeid as 'employee id', a.name as 'role name',
-CASE eam.ISSUPERVISOR WHEN 1 then 'True' ELSE 'False' END AS 'Supervisor',
-CASE eam.ISTEAMLEAD WHEN 1 then 'True' ELSE 'False' END AS 'TeamLead',
-qmf.fromvalue as 'Restriction From', qmf.tovalue as 'Restriction To'
-from AUTHACCESSRIGHT AA
-inner join AUTHROLE a on aa.AUTHROLEID = a.ID
-inner join BPUSER b on AA.BPUSERID = b.ID
-inner join PERSON p on b.EMPLOYEEID = p.ID
-inner join EMPLOYEEAM eam on p.ID = eam.id
-inner join EMPLOYEEQMFILTER qmf on p.ID = qmf.employeeid
---where a.name = 'Basic Replay Role'
-group by b.USERNAME,p.firstname,p.LASTNAME,b.EMPLOYEEID,a.NAME,eam.ISSUPERVISOR,
-eam.ISTEAMLEAD, qmf.FROMVALUE,qmf.TOVALUE
-</code>
-Script to collect login / logput events on Citrix servers
-<code>
-@echo off
-:SORTDATE Variable
-FOR /f "tokens=1-4 delims=/ " %%A IN ('date /t') DO (
-set nday=%%A
-set nmonth=%%B
-set nyear=%%C
-)
-set SORTDATE=%nyear%%nmonth%%nday%
-FOR /f "tokens=1-2 delims=: " %%A IN ('time /t') DO (
-set hour=%%A
-set min=%%B
-)
-set SORTTIME=%hour%%min%
-set TIMESTAMP=%sortdate%-%sorttime%
-:GatherLogs
-set outputfile=VerintUserLoginoutDetails-%sortdate%.txt
-echo. ===== Start of log file Filter - Capture Started at %date%-%time% ===== > %outputfile%
-FOR /F %%i IN (CitrixServers.conf) DO (
-echo Gathering Logs from %%i ...
-findstr "sendLogonLogoffMessage" \\%%i\d$\CaptureService\Logs\captureservice\captureservice*.log >> %outputfile%
-)
-echo. ===== End of log file Filter - Capture Completed at %date%-%time% ===== >> %outputfile%
-echo.
-echo Finished!!!
-pause
-</code>