How to extract session statistics for the entire day in IGL

[shaktinayak]

There is a statistics section under Admin > Monitoring.

I have a requirement to extract the "session statistics" report for an entire week.

can anybody suggest how to extract this report. Is there a DB table which stores this data for a week.

Please suggest.

[KristianNordman · Accepted solution]

Hi!

There is a view which has part of this information (and others): PV_AUDIT_EVENTS

Selecting all with a name of LoginUserId we get a list of all users which have ever attempted a login.

SELECT * FROM PV_AUDIT_EVENTS pvae 
WHERE PVAE.name = 'LoginUserId';
‍‍‍‍‍

This presents results with timestamp and client_identity (username) as well as MEU_ID if available.

This can be further filtered using the pvae.TIMESTAMP column to only get the past N days/weeks/months.

I've had no luck in finding the information for last visited page or loading time.

Regards

Kristian