I would like to apply a PSAUDIT filter on the SCM iSeries task Database server requests , is this p (NETIQKB56388)

  • 7756388
  • 02-Feb-2007
  • 29-Mar-2012

Environment

NetIQ Security Solutions for iSeries 8.0

NetIQ Secure Configuration Manager 5.6

 

Situation

I would like to apply a PSAUDIT filter on the SCM iSeries task "Database server requests", is this possible?
How can I apply a PSAUDIT filter to the SCM iSeries task "Database server requests"?

Resolution

From a command line, use command STRSQL to start the interactive SQL environment and then use the following queries:

The following query will modify the "Command usage by command" report to use the filter "FILTER" vs. the default filter.

UPDATE PSCOMMON/PSEMETA SET MCCMD =                                
'PSRUNRPT RPTID(NW000002) OUTFILE(QTEMP/PSAUDIT) OPT(*REPLACE) FILTE
R(FILTER)  RUNI(*YES) SCHD(*NO)    @NEWVALB(RCVRNG, @META(STRJRNRCV)
 @META(ENDJRNRCV)) @NEWVALB(FROMTIME, @META(STARTDATE) @META(STARTTI
ME)) @NEWVALB(TOTIME, @META(ENDDATE) @META(ENDTIME))' WHERE MCMETA 
='NW000002'                                                                                                


The following query will set the report back to it's defaults.

UPDATE PSCOMMON/PSEMETA SET MCCMD =                               
'PSRUNRPT RPTID(NW000002) OUTFILE(QTEMP/PSAUDIT) OPT(*REPLACE)     
FILTER(*NONE) RUNI(*YES) SCHD(*NO) @NEWVALB(RCVRNG, @META(STRJRNRCV)
 @META(ENDJRNRCV)) @NEWVALB(FROMTIME, @META(STARTDATE) @META(STARTTI
ME)) @NEWVALB(TOTIME, @META(ENDDATE) @META(ENDTIME))'              
WHERE MCMETA ='NW000002'                                           



Additional Information

Formerly known as NETIQKB56388