NetIQ Vulnerability Manager report 'Users with Programming Functions' provides incorrect results. (NETIQKB53647)

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

To correct this report, complete the following steps:

1. On an iSeries command line, run the following command: STRSQL
2. Run the following statement on the 'Enter SQL Statements' screen:

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'''

3. 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 use DISCONNECT server, where server, user, and password are your own values.
   

Formerly known as NETIQKB53647