Cisco AnyConnect reporting

ps_matt

Hello, I'd like to write a custom report for Cisco AnyConnect that finds the average length of a session.  It doesn't look like there's a way to do this within standard reporting.  I'm very comfortable with writing SQL reports and do not think I'll have any issues with SWQL.  My issue is that I am not sure where in the database this data is stored.  Can anyone point me to which table would be a good starting point for finding which table stores these sessions?

vispetto

try using this query but first change the bolded to what you believe the column name may be. The output will be the tables and columns of the search string.

SELECT t.name AS table_name,

SCHEMA_NAME(schema_id) AS schema_name,

c.name AS column_name

FROM sys.tables AS t

INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

WHERE c.name LIKE '%XXXX%'

ORDER BY schema_name, table_name;