I would like to apply a PSAUDIT filter on the SCM iSeries task Command usage by command , is this p (NETIQKB56209)

  • Document ID:7756209
  • Creation Date:02-Feb-2007
  • Modified Date:08-Oct-2007
    • Micro Focus Products:
      Security Solutions for iSeries

Resolution

goal
I would like to apply a PSAUDIT filter on the SCM iSeries task "Command usage by command", is this possible?

goal
How can I apply a PSAUDIT filter to the SCM iSeries task "Command usage by command"?

fact
NetIQ Security Solutions for iSeries 8.0

fact
NetIQ Secure Configuration Manager 5.6

fix

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 =                          
'@PSALIB()/STRAAAPI REPORT(AACL28CC) QRY(FILTER) OFILE(PSAUDIT)
 OLIB(QTEMP) OPT(*REPLACE) RUNI(*YES) SEND(*NO) @m(FROMDATE)  
 @m(TODATE) LIBRARY(@META(COMMAND))'                          
WHERE MCMETA ='AACL28CC'                                      

 

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

UPDATE  pscommon/psemeta set MCCMD =                          
'@PSALIB()/STRAAAPI REPORT(AACL28CC) OFILE(PSAUDIT)           
 OLIB(QTEMP) OPT(*REPLACE) RUNI(*YES) SEND(*NO) @m(FROMDATE)  
 @m(TODATE) LIBRARY(@META(COMMAND))'                          
WHERE MCMETA ='AACL28CC'                                      



Additional Information

Formerly known as NETIQKB56209