Get Email template where email used
select name,MAILTO,MAILCC,MAILBCC from ecmemailtemplate where ( MAILTO like 'int' OR MAILBCC like '%lnt%' OR MAILCC like '%int%' )
Posts
Get Entitlement Owners Query
SELECT distinct ss.systemname AS `Security System`, e.endpointname AS `Endpoint`, et.entitlementname AS `Entitlement Type`, ev.entitlement_value AS `Entitlement Name`, u.username AS `Owner`, eo.rank AS `Owner Rank` FROM securitysystems ss JOIN endpoints e ON ss.systemkey = e.securitysystemkey JOIN entitlement_types et ON et.endpointkey = e.endpointkey JOIN entitlement_values ev ON ev.entitlementtypekey = et.entitlementtypekey and ev.status=1 LEFT JOIN entitlement_owners eo ON eo.entitlement_valuekey = ev.entitlement_valuekey LEFT JOIN Users u ON eo.USERKEY = u.userkey;
Workflow Approval
Type Requestor End User LM User Group - LM+1 User Group - LM+2 Results Status Comments Request for Other R1 E1 Any A1 For Approval @ A1 Pass 7923481 Request for Other A1 E1 Any A1 Auto Approved By A1 Pass 7923544 Request for Other A1 E1 Any A1,A2 Auto Approved By A1 Pass 7923612 Request for Self E1 E1 Any E1 For Approval @ admin Pass 7923745 Request for Self E1 E1 Any E1,E2 For Approval @ E2 Pass 7923680 Request for Other MGR1 E1 MGR1 A3,A4 MGR1,A1 Auto Approved by MGR1 on LM, LM+2 Level Pass 7924071 Request for Other MGR1 E1 MGR1 A3,A4 MGR1 Auto Approved by MGR1 on LM, LM+2 Level Pass 7923944 Request for Other R1 E1 MGR1 A3,A4 MGR1 After LM action LM+2 will be auto approved LM+2 is pending for MGR1 Approval 7923874 Request for Other R1 E1 MGR1 A3,A4 MGR1,A1 After LM action LM+2 will be auto approved LM+2 is pending for MGR1,A1 approval 7923807 Request for Other R1 E1 MGR1 A3,A4,MGR1 MG...
SQL - Analytics with Zero Records
SELECT analyticsname , Substring_index ( Substring_index ( metadata , '"totalData":' , - 1 ) , ',' , 1 ) AS totalData FROM analyticsconfiges WHERE Substring_index ( Substring_index ( metadata , '"totalData":' , - 1 ) , ',' , 1 ) = 0
Query Connection Certificate List
SELECT E . CONNECTIONNAME , S . ALIAS , S . VALID_FROM , S . VALID_TO AS certificate_expiry FROM EXTERNALCONNECTION E , SAV_SSLCERT S WHERE S . CERT_KEY = E . SSLCERTIFICATE AND E . SSLCERTIFICATE IS NOT NULL