Saviynt Solutions

 select name,MAILTO,MAILCC,MAILBCC   from ecmemailtemplate where   ( MAILTO  like 'int' OR MAILBCC like '%lnt%' OR MAILCC like '%int%' )

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;