Viewing 15 posts - 1 through 15 (of 265 total)
1.SQL audit files are directly writen to the shared folder from across all servers to ServerA's shared folder.
2.Yes I can access the shared folder on ServerA from ServerB or ServerC...
June 14, 2022 at 10:03 pm
@Grant Fritchey. Thanks for the response. Will do so.
January 24, 2022 at 3:15 pm
@thanks Grant/All
What I need is to track whoever(Users only...not service accounts) has logged into the server and what have those logins done...dml's ..select..insert etc) and track the hostname,application...
September 15, 2021 at 5:56 am
@Grant and All
When I run a select ... this is what I see in the result set under the statement column when all I want is...
September 6, 2021 at 7:40 am
I still see a lot of data. Is it possible to confine the result set to 1 record/row per dml activity in extended events.
September 2, 2021 at 5:29 am
@Grant
CREATE EVENT SESSION [MySession1] ON SERVER
ADD EVENT sqlserver.sql_statement_completed(
ACTION(package0.collect_system_time,sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.database_name,
sqlserver.server_principal_name,sqlserver.sql_text))
ADD TARGET package0.ring_buffer(SET max_memory=(10240))
WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,
MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
GO
I have a smiliar session which dumps data into...
August 30, 2021 at 5:47 pm
Hi All,
The host name is dependent on the connection string. If people leave this off, it's why you can't audit for it. You can use HOST_NAME to get this information...
August 30, 2021 at 5:31 am
@thanks Jeff..I can check the error log way but can I get references on how I can filter the all data but the login records into the .xel...
August 25, 2021 at 11:17 am
Sounds good to me but unless I am not responding with an answer to the original thread I wasn't sure if it would be appropriate to get into someone's thread...
August 24, 2021 at 2:15 pm
Thanks @Johan.
I settled with this...
CREATE TABLE #Results (
abc VARCHAR(MAX)
)
INSERT INTO #Results
exec sp_msforeachdb '
Select ''
USE [?]
GO
CREATE DATABASE AUDIT SPECIFICATION [DatabaseAuditSpecification ?]
FOR SERVER...
August 21, 2021 at 4:00 am
No infact it has more memory allocated
June 24, 2021 at 1:04 am
@Grant/All,absolutely, the advise I have received from this community has been unparalleled.Learnt a lot from here and I rely more here than the web.
Initially the DB was not a true...
June 22, 2021 at 11:41 pm
My bad ,I understand. Thanks again @Grant.
June 22, 2021 at 3:36 pm
Viewing 15 posts - 1 through 15 (of 265 total)