1 Reply Latest reply on Dec 30, 2014 10:48 AM by Caton Guilbault

    SocialID Data?

    datasci

      Do you know if you can extract the social ID for anyone that registered an account in Jive using a social sign on authentication from either the analytics or App DB's?

        • Re: SocialID Data?
          Caton Guilbault

          Hi Jason,

           

          Yes you can, the table is jiveexternalidentity and its in the system DB.

           

          Here is the query I use:

           

          select externalidentityid,userid,identityvalue, 
          CASE 
              WHEN identityvalue like '%google%' THEN 'Google'
              WHEN identityvalue like '%yahoo%' THEN 'Yahoo'
              WHEN identityvalue ~ '^[0-9]' THEN 'Facebook'
              ELSE 'OpenID'
              END as "Site"
          from jiveexternalidentity
          
          order by identityvalue desc