2 Replies Latest reply on May 26, 2015 9:23 AM by bcarpenter@reliaslearning.com

    lastloggedin jiveuser query return results

    bcarpenter@reliaslearning.com

      Hello! I was just wondering what the lastloggedin field of the jiveuser table returns as a result?

       

      Basically, I'm trying to find a list of users who are inactive to send an email to encourage them to come back.

       

      I've run the query and have the results, but they're all huge numbers that don't reflect accurate data. For example, userid 111574 recently logged in on May 5, 2015. Thoughts?

       

         

      useridlastloggedin
      1115741430811824764.00
      1189461430811614726.00
      1314981430810810478.00
      1314971430810473433.00

       

       

      Thanks!