Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

ASA User Connections Report - Grouped By Day

I want to get a solid report that I can run for clients to show trends on user connections per day on ASA's. I have the tables in SQL I need for this(I think) but just can't seem to get what I want with the report writer and using the ASA resources in report writer throw a big error every time which I've asked support about and its a known issue with no fix at this time. So here I am asking the pros! I've tried it endless ways with no luck.

Anyone have a SQL query out there that would pull this?

I'm running 12.3

Thanks!

Find more posts tagged with

Accepted answers

All comments

mesverrum

Where I am we were able to make a perfstack chart of the asa usage metrics and just sent that page as a scheduled report.

shack

What are they getting...? A PDF? I just tested that and it leaves a lot to be desired. Not to mention the in the picture below these things are backwards? Is there a way to send them an interactive HTML page that doesn't require authentication?

mesverrum

I have seen that issue with the backward stuff before, i think here I am actually using some custom sql for the report and also sending them a link to our dashboard if they actually want to interact with it.

As far as not authenticating users you can use this method, but the directlink thing usually does require some experimentation in the permissions to make sure you are comfortable with the amount of stuff people can and can't see.
https://support.solarwinds.com/SuccessCenter/s/article/Use-DirectLink-account-to-share-views-with-non-Orion-Web-Console-users

mesverrum

This is an example of the sql i am feeding into a custom chart, cleaned up to protect the innocent.

select
rad.ActiveUsers
, rad.ObservationTimestamp
, concat(n.CustomProperties.City, ' - ', n.Caption) as Site
from orion.asa.RemoteAccessDetail rad
join orion.nodes n on n.nodeid=rad.NodeID and n.caption like '%FWASA0%'

where rad.ObservationTimestamp > ADDDAY(-8,GETUTCDATE())