We have the requirement to provide a SQL Server logon report only for Sysadmin. This would have date and time of login when any person log in to the SQL server with system administrator privileges.
Anyway, we can get a report of the SQL server with details of the logins of only those users who are system administrators in the database server.
I suppose that, in the security tab, we can enable the successful and unsuccessful logins; however, enabling this would add a lot of overhead to the server, currently we have enabled it only for unsuccessful logins. And I do not know if there is any way to enable the correct login just for sysadmin and not for others.
Any help would be appreciated.