The Invalid Sign On Attempts iSeries task in Secure Configuration Manager (SCM ), formerly NetIQ Vu (NETIQKB55747)

  • 7755747
  • 02-Feb-2007
  • 08-Oct-2007

Resolution

fact
NetIQ Security Solutions for iSeries 8.0

fact
NetIQ Secure Configuration Manager 5.6

fact

NetIQ Vulnerability Manger 5.x



symptom

The Invalid Sign On Attempts iSeries task in Secure Configuration Manager (SCM ), formerly NetIQ Vulnerability Manager (NVM), has uninformative field names, for example User0 and PWDEVN.



symptom
Some of the column names in the Invalid Sign On Attempts iSeries report do not make any sense.

fix

To have the column names displayed correctly, you will have to modify a file on the iSeries system where iSeries agent
resides.

Please backup the PSEMETA file in library PSCOMMON prior to make the proposed changes using the following command:

  • CPYF FROMFILE(PSCOMMON/PSEMETA)  TOFILE(QGPL/PSEMETAX)  CRTFILE(*YES)            


Then, issue command STRSQL from a command line and run the following statement in the interactive SQL environment:

  • update pscommon/psemeta                                            
    SET MCSELECT =  'SELECT PWDATE AS DATE, PWTIME AS TIME, PWUSRN as USER_NAME, PWDEVN AS DEVICE_NAME, PWTYPE as VIOLATION_TYPE, PWSYNM as SYSTEM_NAME FROM
     QTEMP/PSAUDIT' WHERE MCMETA = 'AACL28PW'                                         

This fixes the column names.

    If you are not familiar with command STRSQL, please use the following commands

  • ADDLIBLE PSCOMMON
  • PSRUNSQL REQUEST('update pscommon/psemeta SET MCSELECT = ''SELECT PWDATE AS DATE, PWTIME AS TIME, PWUSRN as USER_NAME,
    PWDEVN AS DEVICE_NAME, PWTYPE as VIOLATION_TYPE, PWSYNM as SYSTEM_NAME FROM  QTEMP/PSAUDIT'' WHERE MCMETA = ''AACL28PW''')                                           

After these changes are applied, please rerun the "Invalid Sign on Attempts" report using VM/SCM.



Additional Information

Formerly known as NETIQKB55747