Report on the Number of Authorized Users per Computer in Universal Server

Article:TECH200655  |  Created: 2012-12-07  |  Updated: 2013-01-02  |  Article URL http://www.symantec.com/docs/TECH200655
Article Type
Technical Solution


Issue



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.

 


Solution



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




Article URL http://www.symantec.com/docs/TECH200655


Terms of use for this information are found in Legal Notices