How to generate the list of users having specific access types in openvms server?

[Meen]

Hello All,

I am new to the openvms server commands and trying to generate the list of users who are having specific set of access privilege in open vms servers.

For example, Please look into the below log data..

STVS10_bm952393> set def sys$system
STVS10_bm952393> run authorize
UAF> sh bm952393

Username: BM952393 Owner: Meen
Account: UIC: [100,1882] ([BM952393])
CLI: DCL Tables: DCLTABLES
Default: DKA0:[USERS.BM952393]
LGICMD: LOGIN
Flags: DisPwdDic DisPwdHis
Primary days: Mon Tue Wed Thu Fri
Secondary days: Sat Sun
No access restrictions
Expiration: (none) Pwdminimum: 7 Login Fails: 0
Pwdlifetime: 30 00:00 Pwdchange: 31-DEC-2019 15:10
Last Login: 29-JAN-2020 09:25 (interactive), 31-DEC-2019 15:18 (non-interactive)
Maxjobs: 0 Fillm: 100 Bytlm: 200000
Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0
Maxdetach: 0 BIOlm: 150 JTquota: 8192
Prclm: 8 DIOlm: 150 WSdef: 2048
Prio: 4 ASTlm: 250 WSquo: 4096
Queprio: 4 TQElm: 50 WSextent: 16384
CPU: (none) Enqlm: 2000 Pgflquo: 400000
Authorized Privileges:
ACNT EXQUOTA GROUP GRPNAM NETMBX OPER
PRMCEB PRMGBL PRMMBX PSWAPM SETPRV SYSNAM
SYSPRV TMPMBX WORLD
Default Privileges:
GRPPRV NETMBX OPER TMPMBX
UAF> exit

We have similar set of data for all of our users in openvms server. Also, we have many types of access privileges such as ACNT, EXQUOTA, GROUP, GRPNAM, NETMBX, OPER,PRMCEB, PRMGBL, PRMMBX, PSWAPM,SETPRV, SYSNAM,SYSPRV, TMPMBX ,WORLD ,etc which can be assigned to users based on the requirement. By default,we will give  "NETMBX" and "TMPMBX" access privilege to all the users. But now we are trying to generate the users data who are having access privileges other than "NETMBX" and "TMPMBX".

I am trying to generate the list of users who having access privileges other than "NETMBX" and "TMPMBX" under "Authorized Privileges:" field.

I am unable to find the command.. could anyone please help me with the command to generate the users having any other access privilege more than "NETMBX" and "TMPMBX" 

Thanks in advance

[Dave Lennon]

Hi,

    Using included OpenVMS commands, it would be something like:

$ pipe mcr authorize show/brief * | search/exact/match=nor sys$pipe " Normal "

  For more granular results, you'd have to get a tool like the free SCANUAF...

- Dave

[Steven Schweda]

> I am unable to find the command.. [...]

   I doubt that one exists, but there is a freeware utility which might
help.  I've never touched it, so I know nothing, but:

      https://www.digiater.nl/openvms/freeware/v80/getuai/freeware_readme.txt

[Craigers01]

"mcr authorize LIST/FULL" gets you close. Here is a Command Procedure I created to help you out. Put this in a file (uaf.com), then run it (@uaf.com):

$ on control_y then goto XIT
$ mcr authorize LIST/FULL
$ open/read InFile SYSUAF.LIS
$ WriteLine = 0
$ LOOP:
$   read/end_of_file=DONE InFile TextLine
$   if f$extract(0,9,"''TextLine'")  .EQS. "Username:"
$     then
$     write sys$output TextLine
$   endif
$   if f$extract(0,22,"''TextLine'") .EQS. "Authorized Privileges:" 
$     then WriteLine = 1
$   endif
$   if f$extract(0,19,"''TextLine'") .EQS. "Default Privileges:"    
$     then WriteLine = 0
$     write sys$output "--------------------------------"
$   endif
$   if 'WriteLine .EQ. 1
$     then write sys$output TextLine
$   endif
$   GOTO LOOP
$ close InFile
$ exit
$XIT:
$ close InFile