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

User login and useage report, last login

Is there a way to get the list of users who have access to SW orion website and last login in a report? I know you can see who and when they logged in with the admin account but we would like to be able to have a report on this.

Thanks

Find more posts tagged with

Accepted answers

All comments

GregD

You could write a custom SQL report based on the Accounts table in the NetPerfMon database. I'm covered up at the moment, but if you need help just post back and I'll throw together a quick SQL query that you should be able to turn into a report.

sedmo

I believe you could use the following SQL in an advanced SQL report to get what you want.

select AccountID, LastLogin from accounts order by AccountID

profzoom1

Yes, I would need this created for me since I am not a SQL writer or know anything more then what the report writer can do and not able to do the sql queuries on the fly.

Thanks much

sedmo

Prof,

The SQL query posted earlier can be used in report writer by creating a new report and then selecting Advanced SQL for the report type. Then select the SQL tab and enter the query.

profzoom1

Thanks much that worked great.

pogostyx

adding DESC to the end will sort descending:

select AccountID, LastLogin from accounts order by LastLogin DESC