1 Reply Latest reply on Dec 29, 2018 9:49 AM by Yuriy Fal

    Help on Postgres data model/table relation ships

    Koti D

      Hi All,

       

      I have to create a server audit report with the below fields . could any one help me to find out the right tables and fields /relation ships between tables.it's little urgency , dont have much time to go through the data dictionary(due to lot of tables and fields) .

       

      Report 1 :

      SiteProjectWorkbookownerdata sourceExtract/ Liveviewsuser name(who's having the access)

       

       

      Report 2:

       

      Total No Of sitesTotal No of ProjectsTotal No of workbooksTotal No of users

       

       

      Report 3:

       

      Total Server admins(name and count)Site Admins(Name and count)Role wise users (ex: intractor,publisher etc names and count)

       

       

      Thanks in advance .

       

      regards,