How to audit only admin account user logins

• alow

  Grasshopper

  Points: 23

  More actions

  January 20, 2016 at 7:08 pm

  #307267

  I'm running sharepoint on SQL Server 2008 and 2012. If I turn on auditing of successful logins I find that there is a large number of logins each second. Is there a way to only audit successful logins by my admin accounts, eg username=admin1, admin2 ?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734459

  More actions

  January 22, 2016 at 2:58 am

  #1853731

  I'd use trace or extended events with a filter that looks at the name.