Skip to Content
avatar image
Former Member

How to find Query using which GRC reports are fetched ?

Hi,

I am working on end user dashboard, from where they will fetch GRC reports directly instead of going into portal.

For that , I have to understand, where is the query used in NWBC stored or what all tables are used , or is there any single table/report where report as a whole is stored.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 06 at 01:56 PM

    Hello,

    what do you want to report? In the Reports & Analytics work center you can find a bunch of reports that should satisfy your need.

    Let us know if you have a specific question about one of the reports or its sources.

    Regards, Alessandro

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      how did you define the spool location? Do you save the analysis in the file system or database? If file system, check the location of your 1052 parameter. If database, then depends what you run. Ad-hoc or batch risk analysis.

      Ad-hoc check tables: GRACSODREPDATA, GRACSODREPINDEX, GRACSODREPSTATUS

      Batch risk check tables: racuseractvl, gracuseractvlext, gracusercrpvl,gracuserprmvl,Gracuserprmvlext, gracusermgmtsum, gracusermgvcount, Gracroleactvl, gracroleactvlext, gracrolecrpvl, gracroleprmvl, gracroleprmvlext, gracrolemgmtsum, gracrolemgvcount, gracprofileactvl, Gracprofactvlext, Gracprofilecrpvl, Gracprofileprmvl, Gracprofprmvlext, Gracprofmgmtsum, Gracprofmgvcount, grachrobjactvl, grachrobjcrpvl, grachrobjprmvl, gracmgriskd, gracmgrulecount

      As you can see, there are a lot of things that you didn't share and hence it is tough to guide you to the write answer.

      Regards, Alessandro