To track concurrent usage of P6 Professional, you can run queries against the USESSION and USESSAUD tables to perform self-audits. See sample queries below.
Note: See DAMON (Data Monitor) Procedures for information on how to set up the USESSAUD procedure. To ensure accuracy of these queries, run them before physically deleting remaining USESSION records and cleaning up the USESSAUD table.
- Against the USESSION table, run the following query to determine how many users are logged in at a given time:
select count(*) from usession where delete_session_id is null
- Against the USESSION table, run the following query to determine how many users are logged into a specific P6 Professional product at a given time:
P6 Professional product nameselect count (*) from usession where delete_session_id is null and app_name='
'
where P6 Professional product name is the application abbreviation.
Note: You can view all available application abbreviations by running the following query as an administrative database user:
select distinct(db_engine_type) from usereng
- Against the USESSAUD table, run a query similar to the following to determine how many users logged into P6 Professional on a specific date during a specified time range. You can alter the date, time range, and P6 Professional product as needed. The following example will search for all users who logged into P6 Professional on February 17, 2010 between 9am and 10am:
select * from usessaud where login_date between to_date('17-FEB-10 09:00:00','DD-MON-YY HH:MI:SS') and to_date('17-FEB-10 10:00:00','DD-MON-YY HH:MI:SS') and app_name='Project Management'