NetIQ Security Solutions for iSeries 8.0
NetIQ Vulnerability Manager 5.x
NetIQ Secure Configuration Manager 5.6
The "Library Analysis by Library" iSeries report in Secure Configuration Manager (SCM), formerly NetIQ Vulnerability Manager (NVM), shows jumbled text as column names.
I am having trouble reading the "Library Analysis by Library report" report due to the column names being cryptic.
To have the column names displayed correctly, you will have to modify a file on the iSeries system where the iSeries agent
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 AAASPNM as ASPGroup,AA20LB as Library_Name,AA20#O as
Number_of_objects,AA20SZ as Size,AA20STG as Storage_Percentage,
AA20PO as Previous_number_of_objects,AA20PZ as Previous_Size,AA20DT
as Audit_Date,MBMTXT as Library_Text FROM QTEMP/PSAUDIT'
WHERE MCMETA ='AACL31LL'
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 AAASPNM as ASPGroup,AA20LB as Library_Name,AA20#O as Number_of_objects,AA20SZ as Size,AA20STG as Storage_Percentage, AA20PO as Previous_number_of_objects, AA20PZ as Previous_Size,AA20DT as Audit_Date,MBMTXT as Library_Text FROM QTEMP/PSAUDIT'' WHERE MCMETA = ''AACL31LL''')
After these changes are applied, please rerun the "Library Analysis by Library" report using VM/SCM.