If you click on a computer name from the Consumers > Devices menu in PGP Universal Server administrative interface, you can view a list of Authorized Users for the computer. These are users who have been enrolled using the computer.
However, it is not possible to run a report showing how many users are authorized for each computer.
Accessing the PGP Universal Server command line for read-only purposes (such as to view settings, services, logs, processes, disk space, query the database, etc) is supported. However, performing configuration modifications or customizations via the command line may void your Symantec Support agreement unless the following procedures are followed. Any changes made to the PGP Universal Server via the command line must be:
Authorized in writing by Symantec Support.
Implemented by a Symantec Partner, reseller or Symantec Technical Support.
Summarized and documented in a text file in /var/lib/ovid/customization on the PGP Universal Server itself.
Changes made through the command line may not persist through reboots and may be incompatible with future releases. Symantec Technical Support may also require reverting any custom configurations on the PGP Universal Server back to a default state when troubleshooting new issues.
The following SQL script generates a CSV file called users_per_computer.csv that contains two columns:
computer - the name of each computer
total_users - the total number of authorized users for each computer
Simply log in to PGP Universal Server using SSH and copy and paste the script.
psql oviddb ovidr -c "COPY( SELECT hostname as computer, COUNT(iucm.internal_user_uuid) AS total_users FROM client_machine cm LEFT JOIN internal_user_client_machine iucm ON cm.uuid = iucm.client_machine_uuid GROUP BY hostname ) TO STDOUT WITH CSV HEADER;" > users_per_computer.csv
Imported Document ID: TECH200655
Subscribing will provide email updates when this Article is updated. Login is required.
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
Subscribed to the Article.
Unable to subscribe
Thanks for your additional feedback !!!
Enterprise Support Virtual Agent
Rate Me :
Tell us more:
Welcome! My name is Sami, the Enterprise Support Virtual Agent answering technical support questions.