1 Reply Latest reply on Mar 10, 2014 8:02 AM by josh.richau

    Correspondence for JIVE_ENGAGE.JIVEUSERPROP into JIVE_ANALYTICS (Jive 7)

    astan

      Hi Jive team,

       

      Please, help me to understand whether there is a correspondence for JIVEUSERPROP from JIVE_ENGAGE table into JIVE_ANALYTICS schema. Practically, I want to retrieve the home page and the time zone for a user (member). Using JIVE_ENGAGE, I do the following queries:

       

      -- Home Page

      select propvalue

      from jive_engage.JIVEUSERPROP

      where name = 'jive.homepage'

      and userid = 592702;

       

      --Time Zone

      select propvalue

      from jive_engage.JIVEUSERPROP

      where name = 'jiveTimeZoneID'

      and userid = 592702;

       

      Are these information available into JIVE_ANALYTICS schema (Jive 7 version). If YES, how can I retrieve them?

       

      Appreciate your help!

       

      Thank you,

      Adrian