Resolution
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.