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 .