Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
vendors:cisco:uc:ece:sql [2023/03/16 11:54] – [Number of chats sent / receipts per chat conversation (activityId)] gerardorourkevendors:cisco:uc:ece:sql [2024/12/05 08:55] (current) – [SQL User <> CCE Mapping] gerardorourke
Line 606: Line 606:
      
 GROUP BY ENTRYPOINT_ID GROUP BY ENTRYPOINT_ID
 +</code>
 +
 +==== SQL User <> CCE Mapping ====
 +
 +<code sql>
 +SELECT *
 +FROM EGICM_USER
 +    LEFT JOIN EGPL_USER ON EGPL_USER.user_id = EGICM_USER.user_id
 +    
 +ORDER BY FIRST_NAME, LAST_NAME
 </code> </code>
  • vendors/cisco/uc/ece/sql.1678967656.txt.gz
  • Last modified: 2023/03/16 11:54
  • by gerardorourke