Saviynt Solutions

     

  SELECT   analyticsname ,         Substring_index ( Substring_index ( metadata ,   '"totalData":' ,   - 1 ) ,   ',' ,   1 )   AS         totalData FROM     analyticsconfiges WHERE    Substring_index ( Substring_index ( metadata ,   '"totalData":' ,   - 1 ) ,   ',' ,   1 )   =         0  

  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    

 https://onecompiler.com/groovy/3zyat7sk6

SELECT   DISTINCT   us . isreassigned ,                  CASE                    WHEN   us . isreassigned   =   0   THEN   Concat ( cm . campaign_name ,   ' - ' ,                                                  u . username ,   ' ('                                                  ,  ...