Audit result

• zi

  SSCrazy

  Points: 2387

  More actions

  November 1, 2014 at 12:28 pm

  #397596

  Dear Experts

  I have made a server security audit and specify from database audit specification to audit "select" on a certain user and on a certain table. I logged in by this user and made the select statement

  when i run this query "select * from sys.fn_get_audit_file('d:\Audit\audit1*',null,null)"

  it return a value at which time the query has done

  after 15 minutes i repeated the same action, i run the audit query and the same result is showed off on the panel

  is it suppose to return a list of values by how many times this user has made the select statement on that table ?

  for example at 5:00 pm then 6:00 pm and so on

  Thanks lot

• zi

  SSCrazy

  Points: 2387

  More actions

  November 29, 2014 at 7:15 am

  #1761509

  Can any one explain to me how to make an audit in steps

  and how to be sure that the audit runs successfully or how to test it

  Thanks lot