Sunday, March 11, 2012

Auditing Config

I need to query system tables for various config options. Anyone know if the auditing options(login-success/fail/all) are stored in a table and what that table might be?
Jeffexec sp_configure is the supported way to query this, or you can look at
master.dbo.spt_values
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Jeff Ericson" <jeff.ericson@.mbna.com> wrote in message
news:FB99D88D-62D5-44D2-8D01-9AC00EF28731@.microsoft.com...
> I need to query system tables for various config options. Anyone know if
the auditing options(login-success/fail/all) are stored in a table and what
that table might be?
> Jeff|||Couple of options
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jeff Ericson" <jeff.ericson@.mbna.com> wrote in message
news:FB99D88D-62D5-44D2-8D01-9AC00EF28731@.microsoft.com...
I need to query system tables for various config options. Anyone know if
the auditing options(login-success/fail/all) are stored in a table and what
that table might be?
Jeff|||Oops sent that last post a bit quick
Easiest way would be
exec xp_loginconfig 'audit level'
Details are in BOL
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jeff Ericson" <jeff.ericson@.mbna.com> wrote in message
news:FB99D88D-62D5-44D2-8D01-9AC00EF28731@.microsoft.com...
I need to query system tables for various config options. Anyone know if
the auditing options(login-success/fail/all) are stored in a table and what
that table might be?
Jeff|||the detail actually is stored in registry...
>--Original Message--
>I need to query system tables for various config
options. Anyone know if the auditing options(login-
success/fail/all) are stored in a table and what that
table might be?
>Jeff
>.
>|||Hi Jeff
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
You can get the Audit Level in the database security option from the
registry table or by extensive stored procedure 'xp_loginconfig'.
From the 'Start' menu of you Windows system, click 'Run', and run
'regedit'. You will get the a registration key 'AuditLevel' at the location
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer'
I should explain more about this key.
If your Audit Level is set to:
'None', the value would be 0x00000000(0);
'Success', the value would be 0x00000001(1);
'Failure', the value would be 0x00000002(2);
'All', the value would be 0x00000003(3).
You can also use the following code to retrieve the value of the Audit
Level:
Use master
exec xp_loginconfig 'audit level'
go
You will get
name config_value
----
audit_level success
I hope this would answer your question. If you still have questions, please
feel free to post any new message here and I am ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks for all the replies, I'll thry the extended SP, we don't have access to the registry(or the server (&%*(&()!!!!).

No comments:

Post a Comment