Programmatically determining Audit levels across servers

11/09/2006, 15h20

I have multiple SQL servers and want to run a remote query on each of them to
determine their Audit level... (None, Success, Failure, All). Where is this
information stored, that i might query it?

Thanks!
--
The Spirit gives life; the flesh counts for nothing! (Jn 6:63)

11/09/2006, 16h16

You can execute the extended.stored procedure
xp_loginconfig:
exec master..xp_loginconfig 'audit level'

It's also located in the registry . Which key depends on
what version, instances, etc. but it's the value for
AuditLevel
For a default instance of SQL Server 2000, the location is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer
For a default instance of SQL Server 2005, the location is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer
The values for AuditLevel are:
0 = None
1 = Success
2 = Failure
3 = All

-Sue

On Mon, 11 Sep 2006 07:20:02 -0700, Blue Sky
<BlueSky@discussions.microsoft.com> wrote:

>I have multiple SQL servers and want to run a remote query on each of them to
>determine their Audit level... (None, Success, Failure, All). Where is this
>information stored, that i might query it?
>
>Thanks!

19/09/2006, 15h32

Sue, Thanks!
--
The Spirit gives life; the flesh counts for nothing! (Jn 6:63)

"Sue Hoegemeier" wrote:

> You can execute the extended.stored procedure
> xp_loginconfig:
> exec master..xp_loginconfig 'audit level'
>
> It's also located in the registry . Which key depends on
> what version, instances, etc. but it's the value for
> AuditLevel
> For a default instance of SQL Server 2000, the location is:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer
> For a default instance of SQL Server 2005, the location is:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\MSSQL.1\MSSQLServer
> The values for AuditLevel are:
> 0 = None
> 1 = Success
> 2 = Failure
> 3 = All
>
> -Sue
>
> On Mon, 11 Sep 2006 07:20:02 -0700, Blue Sky
> <BlueSky@discussions.microsoft.com> wrote:
>
> >I have multiple SQL servers and want to run a remote query on each of them to
> >determine their Audit level... (None, Success, Failure, All). Where is this
> >information stored, that i might query it?
> >
> >Thanks!
>
>

11/09/2006, 15h20	#1
Blue Sky Messages: n/a Hébergeur:	Programmatically determining Audit levels across servers I have multiple SQL servers and want to run a remote query on each of them to determine their Audit level... (None, Success, Failure, All). Where is this information stored, that i might query it? Thanks! -- The Spirit gives life; the flesh counts for nothing! (Jn 6:63)

11/09/2006, 16h16	#2
Sue Hoegemeier Messages: n/a Hébergeur:	Re: Programmatically determining Audit levels across servers You can execute the extended.stored procedure xp_loginconfig: exec master..xp_loginconfig 'audit level' It's also located in the registry . Which key depends on what version, instances, etc. but it's the value for AuditLevel For a default instance of SQL Server 2000, the location is: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer For a default instance of SQL Server 2005, the location is: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer The values for AuditLevel are: 0 = None 1 = Success 2 = Failure 3 = All -Sue On Mon, 11 Sep 2006 07:20:02 -0700, Blue Sky <BlueSky@discussions.microsoft.com> wrote: >I have multiple SQL servers and want to run a remote query on each of them to >determine their Audit level... (None, Success, Failure, All). Where is this >information stored, that i might query it? > >Thanks!

19/09/2006, 15h32	#3
Blue Sky Messages: n/a Hébergeur:	Re: Programmatically determining Audit levels across servers Sue, Thanks! -- The Spirit gives life; the flesh counts for nothing! (Jn 6:63) "Sue Hoegemeier" wrote: > You can execute the extended.stored procedure > xp_loginconfig: > exec master..xp_loginconfig 'audit level' > > It's also located in the registry . Which key depends on > what version, instances, etc. but it's the value for > AuditLevel > For a default instance of SQL Server 2000, the location is: > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer > For a default instance of SQL Server 2005, the location is: > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL > Server\MSSQL.1\MSSQLServer > The values for AuditLevel are: > 0 = None > 1 = Success > 2 = Failure > 3 = All > > -Sue > > On Mon, 11 Sep 2006 07:20:02 -0700, Blue Sky > <BlueSky@discussions.microsoft.com> wrote: > > >I have multiple SQL servers and want to run a remote query on each of them to > >determine their Audit level... (None, Success, Failure, All). Where is this > >information stored, that i might query it? > > > >Thanks! > >

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email