1 Reply Latest reply on Mar 27, 2017 3:57 PM by Ben Newell

    Server Reports

    Manigandan Arumugam

      I would like to create a report on when a user is added and removed from the server. Any idea which table is will give us that values in PostGRE?. I am new to admin side. Please don't mind if this is silly.

        • 1. Re: Server Reports
          Ben Newell

          Manigandan,

           

          Try this statement... Should be a good start for you

           

          Select *

          from historical_events

          left join historical_event_types on

          historical_event_types.type_id=historical_events.historical_event_type_id

          limit 1000

           

          My statement may have spelling errors, as I had to hand type this...