Environment
NetIQ Security Solutions for iSeries 8.0
NetIQ Secure Configuration Manager 5.6
Situation
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'