title: How to get SQL Server login audit setting using T-SQL or sys view
body: <p>In SSMS > Server Properties > Secuirty page, I can view/change the "Login Auditing" to "None, Failed Only, Successful Only..." 
  Is there a way though to get the property value using TSQL/system catalog/view/DMV? I would like to incorperate that into a script to generate a report.</p>
  
  <p>Thanks</p>