Reading multiple audit files

Question

Post reply

Reading multiple audit files

mtz676

SSCrazy Eights

Points: 9261
More actions
June 9, 2021 at 8:16 pm
Go to Answer
#3894065
Is it possible to read multiple audit files from multiple servers all placed under a single folder ?
SELECT * FROM sys.fn_get_audit_file('E:\ABC\ServerAudit\*.sqlaudit', DEFAULT, DEFAULT)
order by event_time desc
I have 10 audit files from 10 different servers all under this folder - E:\ABC\ServerAudit\
Thanks
No more an issue.
- This topic was modified 4 years, 1 month ago by mtz676.
- This topic was modified 4 years, 1 month ago by mtz676.
mtz676

SSCrazy Eights

Points: 9261
More actions
June 18, 2021 at 8:32 am
Answer
#3897890

No more an issue

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80342 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004619 More actions Follow · Answer 2

mtz676 wrote:

No more an issue

So, how did you fix it? What did you do?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

mtz676 SSCrazy Eights Points: 9261 More actions · Answer 3

mtz676

SSCrazy Eights

Points: 9261

June 20, 2021 at 3:45 pm

#3898555

I did nothing.They just became readable.

Thanks

Jeff Moden SSC Guru Points: 1004619 More actions Follow · Answer 4

K. Thanks.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Reading multiple audit files

Cookies on SQLServerCentral