Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- With EvtData
- As (Select CAST(event_data as XML) as EvtData
- From sys.fn_xe_file_target_read_file (
- 'S:\Path\To\File\FileName*.xel', null, null, null))
- SELECT EvtData.value('(event/data[@name="object_name"]/value)[1]', 'sysname') AS ObjectName,
- EvtData.value('(event/action[@name="object_name"]/value)[1]', 'sysname') AS ObjectName,
- EvtData
- FROM EvtData;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement