search

trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool
MIT License
269 stars 63 forks source link

Built In SA Report #1055

Closed aachaemenes closed 1 month ago

aachaemenes commented 1 month ago

Can we have Built in SA report right under the Service Account Report you have added to the latest build.

It would be a great feature to see which accounts have SA rights. We use tempSA access a lot to get things done and then expire it.

Having a report that who has SA and for how many days if possible that would be great.

DavidWiseman commented 1 month ago

Hi, the data is already collected for this. If you run the script attached to this discussion #1018 it will create a custom report for you. Note: The history isn't tracked so it's not possible to see how long someone has had the sysadmin role for.

aachaemenes commented 1 month ago

can you make it as build in with the next release? I think it is really valuable. Just a suggestion.

DavidWiseman commented 1 month ago

This will be included in the next release.

DavidWiseman commented 1 month ago

Included in 3.12 🚀