V_QUERY_AUDITTABLES

Used to query audit tables for the system.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
AUDITTABLENAME	nvarchar(105)		Audit table name
TABLENAME	nvarchar(100)		System table name
AUDITENABLED	bit	yes	Audit enabled

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:20:43 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_AUDITTABLES AS



select
    TABLECATALOG.ID,
    TABLECATALOG.TABLENAME + 'AUDIT' AUDITTABLENAME,
    TABLECATALOG.TABLENAME,
    dbo.UFN_AUDITENABLED(TABLECATALOG.TABLENAME) AUDITENABLED
from
    dbo.TABLECATALOG
where
    coalesce(TABLESPECXML.value('declare namespace bbfa="bb_appfx_table";/bbfa:TableSpec[1]/@EnableAuditTrail','bit'), 1) = 1
    and exists (select 1 from INFORMATION_SCHEMA.TABLES TABLES where TABLES.TABLE_NAME = TABLECATALOG.TABLENAME + 'AUDIT')

union

select
    CODETABLECATALOG.ID,
    CODETABLECATALOG.DBTABLENAME + 'AUDIT' AUDITTABLENAME,
    CODETABLECATALOG.DBTABLENAME,
    dbo.UFN_AUDITENABLED(CODETABLECATALOG.DBTABLENAME) AUDITENABLED
from
    dbo.CODETABLECATALOG
where
    exists (select 1 from INFORMATION_SCHEMA.TABLES TABLES where TABLES.TABLE_NAME = CODETABLECATALOG.DBTABLENAME + 'AUDIT')