General Issues

From DocWiki

(Difference between revisions)
Jump to: navigation, search
(New page: == '''QUERIES: (eGActive DB)''' ==)
Line 1: Line 1:
-
 
== '''QUERIES: (eGActive DB)''' ==
== '''QUERIES: (eGActive DB)''' ==
 +
 +
 +
'''Note:'''
 +
Open SQL Query window, '''Note''' to change to eGActive DB.
 +
 +
 +
:* '''How do we monitor Chat/eMail activities at CIM level ?'''
 +
: Run below SQL query selecting eGain Active DB.
 +
: select * from egpl_casemgmt_activity where activity_id > activityid
 +
: example :activityid = 27789
 +
: The above Query is used to check whether Chat/email requests are comming into CIM and their states.(request queued,request assigned to an agent,request completion,exit status of request).
 +
 +
 +
:* '''How do we map chat/email agent details at with ICM/CIM level ?'''
 +
: Run below SQL query selecting eGain Active DB.
 +
: select * from egpl_user
 +
: The above query displays agent information at CIM Level with skillTarget id.
 +
: select * from egicm_user
 +
: The above query displays agent information at ICM Level with skillTarget id with ICM Agent ID.
 +
 +
 +
:* '''How do we see event history for a particular activity ?'''
 +
: Run below SQL query selecting eGain Active DB.
 +
: select * from egpl_event_history_case_mgmt where activity_id > activityid.
 +
 +
 +
:* '''How do we see event history for a CIM user ?'''
 +
:select * from egpl_event_history_user
 +
 +
 +
:* '''How do we see event history for a CIM user ?'''
 +
:select DATEADD(ss, event_date/1000, '1/1/1970') from egpl_event_history_user;
 +
 +
 +
:* '''How to check status of CIM Services from DB ?'''
 +
: '''System:'''
 +
: select * from EGPL_DSM_PROCESS
 +
 +
: '''Instance:'''
 +
: select * from EGPL_DSM_INSTANCE
 +
 +
: '''State:'''
 +
: - running
 +
: - stopped
 +
: - starting

Revision as of 06:39, 11 January 2011

QUERIES: (eGActive DB)

Note: Open SQL Query window, Note to change to eGActive DB.


  • How do we monitor Chat/eMail activities at CIM level ?
Run below SQL query selecting eGain Active DB.
select * from egpl_casemgmt_activity where activity_id > activityid
example :activityid = 27789
The above Query is used to check whether Chat/email requests are comming into CIM and their states.(request queued,request assigned to an agent,request completion,exit status of request).


  • How do we map chat/email agent details at with ICM/CIM level ?
Run below SQL query selecting eGain Active DB.
select * from egpl_user
The above query displays agent information at CIM Level with skillTarget id.
select * from egicm_user
The above query displays agent information at ICM Level with skillTarget id with ICM Agent ID.


  • How do we see event history for a particular activity ?
Run below SQL query selecting eGain Active DB.
select * from egpl_event_history_case_mgmt where activity_id > activityid.


  • How do we see event history for a CIM user ?
select * from egpl_event_history_user


  • How do we see event history for a CIM user ?
select DATEADD(ss, event_date/1000, '1/1/1970') from egpl_event_history_user;


  • How to check status of CIM Services from DB ?
System:
select * from EGPL_DSM_PROCESS
Instance:
select * from EGPL_DSM_INSTANCE
State:
- running
- stopped
- starting

Rating: 3.0/5 (1 vote cast)

Personal tools