Query required for fetching security data from Audit_Event table

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

How can we query data from the audit probe?

Environment

Release : 9.02

Component : UIM Audit Probe

Resolution

you can use a query like this example: 

 select * from Audit_event where event_time <= '2019-03-01 02:52:23.000' 

 based on your language and regional settings in the sql server you might see a different date / time format. 

You just need to adjust this according to your settings.