Does database have activity over a time range?

by Jun 1, 2020

We need an easy way to see if a database has had any activity based on a time range. This will help determine dormant databases that were never properly decommissioned.

Also, it would be nice to filter out logins for this. For example, if the database is being backed up by a windows account, then I would like to exclude this user. Perhaps I would also like to exclude the service account that SQL Dm is using as well.


Scott Stone over 2 years ago
Do you also have SQL Inventory Manager? Would this feature make more sense in Inventory or Diagnostic Manager?

webwilliam over 2 years ago in reply to Scott Stone
Yes, I do have SQL Inventory Manager, but this would be best for SQL Dm as a new report with filters to exclude logins.