To track concurrent usage of P6 EPPM, 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 EPPM product at a given time:
select count (*) from usession where delete_session_id is null and app_name=''where P6 EPPM 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 EPPM on a specific date during a specified time range. You can alter the date, time range, and P6 EPPM product as needed. The following example will search for all users who logged into P6 Professional on February 17, 2010 between 9am and 10am:
For an Oracle database:
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'For a Microsoft SQL Server database:
select * from usessaud where login_date between'2010-02-17 09:00' and '2011-02-17 10:00' and app_name='Project Management'
Tips
See "Counting Users" in the P6 EPPM System Administration Guide for information on counting users and how to view the total number of licenses assigned for each module.