Exporting User Session Data

User session data can be exported from AMC to a comma-separated (CSV) file that can be displayed and edited in Microsoft Excel. Once user session data is exported to a CSV file, you may archive user session data indefinitely, create custom reports without using Secure Mobile Access Advanced Reporting (AAR), or use the file for any other special needs.

To export user session data to a CSV file

1. In the AMC, navigate to Monitoring > User Sessions.

2. Optionally, filter the displayed user data so that only the data you want to export is displayed. See Viewing User Sessions for additional filtering information.

3. Click the Export button located at the top of the user session data.

   The Export button is enabled only if the Administrator has view access to the User Sessions page.

4. When the File Download page displays, click the Save button.

5. Select the location on the local computer and file name where user data should be saved or use the defaults. The default file name is UserSessions.csv and default location is your Downloads folder.

6. Click the Save button to export user session data to the csv file. All user sessions that meet the current filter criteria are exported.

The CSV file may include the information shown in the below table for each user session, depending on the filters used.

User session data

Type of data	Description
System Version	Secure Mobile Access version number
Session ID	Unique numeric ID used to identify the session internally
State	State of user session: Login Failed, Licensed, Idle, or Ended
Username	Short username
Long Username	Full username and realm, including Common Name (CN) for AD/LDAP sessions
Start Time	Session start time in MM/DD/YYYY HH:MM:SS format, uses appliance local time
End Time	Session end time in MM/DD/YYYY HH:MM:SS format or blank if session is Idle or Licensed
Elapsed Seconds	Seconds between the session start and end times or start and current time for active and idle sessions
Average Bytes per Minute (Last Hour)	Average bytes (upload and download) per minute used by session over the last hour, used to determine high-usage users/sessions
Total bytes	Total number of bytes uploaded and downloaded by session
Realm	Realm name used to authenticate the user
Community	Community name the user was placed in
Zone	Zone the user/device was placed in
Access Agents	Access Agents used: Web only, Tunnel, Tunnel (ESP), OnDemand, Web Proxy, or Exchange
Agent Version	Connect Agent version number
Platform Version	Client platform version number
Remote Address	IP address of the client computer
Local Address	Local address assigned to the client connection, left blank for non-tunnel sessions

Following is an example of a user session csv file generated by AMC:

Version,SessionID,State,Username,LongUsername,StartTime,EndTime,ElapsedSeconds,AverageBytesPerMinuteLastHour,TotalBytes,Realm,Community,Zone,EPCAgent,AccessAgents,AgentVersion,PlatformVersionRemoteAdd ress,LocalAddress

12.4.1-02327,2,3,Licensed,"admin(admin)@(local)",5/10/2019 14:35,,157,5226,13503,local,"Default community","Default zone",,"Connect Tunnel",12.20.267,"10.0.17763 Build 17763" ,192.168.212.1,2.0.0.2