Skip to Content
0

How to find Query using which GRC reports are fetched ?

Feb 06 at 05:18 AM

44

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Alessandro Banzer Feb 06 at 01:56 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi,

Tell me about SOD report at User Level.

Thanks.!!

0

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

1