Resolution
fact
VigilEnt Security Agent for iSeries 7.5
fact
NetIQ Security Solutions for iSeries 8.0
fact
NetIQ Vulnerability Manager 5.0
fact
NetIQ Vulnerability Manager 5.5
symptom
NetIQ Vulnerability Manager report 'Users with Programming Functions' provides incorrect results.
symptom
The NetIQ Vulnerability Manager report 'Users with Programming Functions' includes user profiles that do not have User Class *PGMR.
fix
VigilEnt Security Agent for iSeries 7.5
fact
NetIQ Security Solutions for iSeries 8.0
fact
NetIQ Vulnerability Manager 5.0
fact
NetIQ Vulnerability Manager 5.5
symptom
NetIQ Vulnerability Manager report 'Users with Programming Functions' provides incorrect results.
symptom
The NetIQ Vulnerability Manager report 'Users with Programming Functions' includes user profiles that do not have User Class *PGMR.
fix
To correct this report, complete the following steps:
- On an iSeries command line, run the following command:
STRSQL
- Run the following statement on the 'Enter SQL Statements' screen:
- If you need to update the file PSCOMMON/PSEMETA on another iSeries server, on the 'Enter SQL Statements' screen, first use
CONNECT TO server USER user USING password
, run the SQL update statement shown above, then useDISCONNECT server
, where server, user, and password are your own values.
UPDATE PSCOMMON/PSEMETA SET MCMETA = '*PGMR', MCPARMLST = 1,
MCASHTML = 'N', MCSELECT =
'CREATE VIEW QTEMP/PSAUDITX AS SELECT DISTINCT * FROM QTEMP/PSAUDIT
WHERE UPUSCL = ''*PGMR''' WHERE MCMETA = '*PGMR' and MCCMD = ' '
and MCPARMLST = 1 and MCASHTML = 'N' and MCTEMPLAT = ' ' and
MCSELECT =
'CREATE VIEW QTEMP/PSAUDITX AS SELECT DISTINCT * FROM QTEMP/PSAUDIT
WHERE UPSPAU = ''*NONE'''
Additional Information
Formerly known as NETIQKB53647