V_USAGEREPORT_CUSTOMCATALOGCOMPONENTS

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



                select TABLESPECXML.value('declare namespace bbspec="bb_appfx_table";/bbspec:TableSpec[1]/@Author','varchar(max)') as AUTHOR, TABLENAME as NAME, DESCRIPTION, 'Table Spec' as TYPE
                    from dbo.TABLECATALOG
                    where TABLESPECXML.value('declare namespace bbspec="bb_appfx_table";/bbspec:TableSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SPECXML.value('declare namespace bbspec="bb_appfx_batchtype";/bbspec:BatchTypeSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Batch Type Spec' as TYPE
                    from dbo.BATCHTYPECATALOG
                    where SPECXML.value('declare namespace bbspec="bb_appfx_batchtype";/bbspec:BatchTypeSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  DATALISTSPEC.value('declare namespace bbspec="bb_appfx_datalist";/bbspec:DataListSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Data List Spec' as TYPE
                    from dbo.DATALISTCATALOG
                    where DATALISTSPEC.value('declare namespace bbspec="bb_appfx_datalist";/bbspec:DataListSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  IDMAPPERSPECXML.value('declare namespace bbspec="bb_appfx_idmapper";/bbspec:IDMapperSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'ID Mapper Spec' as TYPE
                    from dbo.IDMAPPERCATALOG
                    where IDMAPPERSPECXML.value('declare namespace bbspec="bb_appfx_idmapper";/bbspec:IDMapperSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SPECXML.value('declare namespace bbspec="bb_appfx_flashdash";/bbspec:FlashDashSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Flash Dash Spec' as TYPE
                    from dbo.DASHBOARDCATALOG
                    where SPECXML.value('declare namespace bbspec="bb_appfx_flashdash";/bbspec:FlashDashSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SQLPROCEDURESPECXML.value('declare namespace bbspec="bb_appfx_sqlstoredprocedure";/bbspec:SQLStoredProcedureSpec[1]/@Author','varchar(max)') as AUTHOR, PROCEDURENAME as NAME, DESCRIPTION, 'SQL Stored Procedure Spec' as TYPE
                    from dbo.SQLPROCEDURECATALOG
                    where SQLPROCEDURESPECXML.value('declare namespace bbspec="bb_appfx_sqlstoredprocedure";/bbspec:SQLStoredProcedureSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  FUNCTIONALAREASPECXML.value('declare namespace bbspec="bb_appfx_functionalarea";/bbspec:FunctionalAreaSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Functional Area Spec' as TYPE
                    from dbo.FUNCTIONALAREACATALOG
                    where FUNCTIONALAREASPECXML.value('declare namespace bbspec="bb_appfx_functionalarea";/bbspec:FunctionalAreaSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  PACKAGESPECXML.value('declare namespace bbspec="bb_appfx_package";/bbspec:PackageSpec[1]/@Author','varchar(max)') as AUTHOR, PACKAGENAME as NAME, DESCRIPTION, 'Package Spec' as TYPE
                    from dbo.PACKAGECATALOG
                    where PACKAGESPECXML.value('declare namespace bbspec="bb_appfx_package";/bbspec:PackageSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  CODETABLESPECXML.value('declare namespace bbspec="bb_appfx_codetable";/bbspec:CodeTableSpec[1]/@Author','varchar(max)') as AUTHOR, CODETABLENAME as NAME, '' as DESCRIPTION, 'Code Table Spec' as TYPE
                    from dbo.CODETABLECATALOG
                    where CODETABLESPECXML.value('declare namespace bbspec="bb_appfx_codetable";/bbspec:CodeTableSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SMARTFIELDSPECXML.value('declare namespace bbspec="bb_appfx_smartfield";/bbspec:SmartFieldSpec[1]/@Author','varchar(max)') as AUTHOR, DISPLAYNAME as NAME, DESCRIPTION, 'Smart Field Spec' as TYPE
                    from dbo.SMARTFIELDCATALOG
                    where SMARTFIELDSPECXML.value('declare namespace bbspec="bb_appfx_smartfield";/bbspec:SmartFieldSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  TRANSLATIONFUNCTIONSPEC.value('declare namespace bbspec="bb_appfx_translationfunction";/bbspec:TranslationFunctionSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Translation Function Spec' as TYPE
                    from dbo.TRANSLATIONFUNCTIONCATALOG
                    where TRANSLATIONFUNCTIONSPEC.value('declare namespace bbspec="bb_appfx_translationfunction";/bbspec:TranslationFunctionSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SMARTQUERYSPEC.value('declare namespace bbspec="bb_appfx_smartquery";/bbspec:SmartQuerySpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Smart Query Spec' as TYPE
                    from dbo.SMARTQUERYCATALOG
                    where SMARTQUERYSPEC.value('declare namespace bbspec="bb_appfx_smartquery";/bbspec:SmartQuerySpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  TASKSPECXML.value('declare namespace bbspec="bb_appfx_task";/bbspec:TaskSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Task Spec' as TYPE
                    from dbo.TASKCATALOG
                    where TASKSPECXML.value('declare namespace bbspec="bb_appfx_task";/bbspec:TaskSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  BUSINESSPROCESSSPECXML.value('declare namespace bbspec="bb_appfx_businessprocess";/bbspec:BusinessProcessSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Business Process Spec' as TYPE
                    from dbo.BUSINESSPROCESSCATALOG
                    where BUSINESSPROCESSSPECXML.value('declare namespace bbspec="bb_appfx_businessprocess";/bbspec:BusinessProcessSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  GLOBALCHANGESPECXML.value('declare namespace bbspec="bb_appfx_globalchange";/bbspec:GlobalChangeSpec[1]/@Author','varchar(max)') as AUTHOR, DISPLAYNAME as NAME, DESCRIPTION, 'Global Change Spec' as TYPE
                    from dbo.GLOBALCHANGECATALOG
                    where GLOBALCHANGESPECXML.value('declare namespace bbspec="bb_appfx_globalchange";/bbspec:GlobalChangeSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  REPORTSPECXML.value('declare namespace bbspec="bb_appfx_report";/bbspec:ReportSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Report Spec' as TYPE
                    from dbo.REPORTCATALOG
                    where REPORTSPECXML.value('declare namespace bbspec="bb_appfx_report";/bbspec:ReportSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SPECXML.value('declare namespace bbspec="bb_appfx_mergetask";/bbspec:MergeTaskSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Merge Task Spec' as TYPE
                    from dbo.MERGETASKCATALOG
                    where SPECXML.value('declare namespace bbspec="bb_appfx_mergetask";/bbspec:MergeTaskSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SEARCHLISTSPEC.value('declare namespace bbspec="bb_appfx_searchlist";/bbspec:SearchListSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Search List Spec' as TYPE
                    from dbo.SEARCHLISTCATALOG
                    where SEARCHLISTSPEC.value('declare namespace bbspec="bb_appfx_searchlist";/bbspec:SearchListSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SQLFUNCTIONSPECXML.value('declare namespace bbspec="bb_appfx_sqlfunction";/bbspec:SQLFunctionSpec[1]/@Author','varchar(max)') as AUTHOR, FUNCTIONNAME as NAME, DESCRIPTION, 'SQL Function Spec' as TYPE
                    from dbo.SQLFUNCTIONCATALOG
                    where SQLFUNCTIONSPECXML.value('declare namespace bbspec="bb_appfx_sqlfunction";/bbspec:SQLFunctionSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  RECORDOPERATIONSPECXML.value('declare namespace bbspec="bb_appfx_recordoperation";/bbspec:RecordOperationSpec[1]/@Author','varchar(max)') as AUTHOR, DISPLAYNAME as NAME, DESCRIPTION, 'Record Operation Spec' as TYPE
                    from dbo.RECORDOPERATIONCATALOG
                    where RECORDOPERATIONSPECXML.value('declare namespace bbspec="bb_appfx_recordoperation";/bbspec:RecordOperationSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SPECXML.value('declare namespace bbspec="bb_appfx_kpi";/bbspec:KpiSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Kpi Spec' as TYPE
                    from dbo.KPICATALOG
                    where SPECXML.value('declare namespace bbspec="bb_appfx_kpi";/bbspec:KpiSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  TEMPLATESPECXML.value('declare namespace bbspec="bb_appfx_viewdataformtemplate";/bbspec:ViewDataFormTemplateSpec[1]/@Author','varchar(max)') as AUTHOR, TEMPLATENAME as NAME, DESCRIPTION, 'View Data Form Template Spec' as TYPE
                    from dbo.DATAFORMTEMPLATECATALOG
                    where TEMPLATESPECXML.value('declare namespace bbspec="bb_appfx_viewdataformtemplate";/bbspec:ViewDataFormTemplateSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development' and MODE = 0
                union all
                    select  TEMPLATESPECXML.value('declare namespace bbspec="bb_appfx_editdataformtemplate";/bbspec:EditDataFormTemplateSpec[1]/@Author','varchar(max)') as AUTHOR, TEMPLATENAME as NAME, DESCRIPTION, 'Edit Data Form Template Spec' as TYPE
                    from dbo.DATAFORMTEMPLATECATALOG
                    where TEMPLATESPECXML.value('declare namespace bbspec="bb_appfx_editdataformtemplate";/bbspec:EditDataFormTemplateSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development' and MODE = 1
                union all
                    select  TEMPLATESPECXML.value('declare namespace bbspec="bb_appfx_adddataformtemplate";/bbspec:AddDataFormTemplateSpec[1]/@Author','varchar(max)') as AUTHOR, TEMPLATENAME as NAME, DESCRIPTION, 'Add Data Form Template Spec' as TYPE
                    from dbo.DATAFORMTEMPLATECATALOG
                    where TEMPLATESPECXML.value('declare namespace bbspec="bb_appfx_adddataformtemplate";/bbspec:AddDataFormTemplateSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development' and MODE = 2
                union all
                    select QUERYVIEWSPEC.value('declare namespace bbspec="bb_appfx_queryview";/bbspec:QueryViewSpec[1]/@Author','varchar(max)') as AUTHOR, DISPLAYNAME as NAME, DESCRIPTION, 'Query View Spec' as TYPE
                    from dbo.QUERYVIEWCATALOG
                    where QUERYVIEWSPEC.value('declare namespace bbspec="bb_appfx_queryview";/bbspec:QueryViewSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  PAGEDEFINITIONSPEC.value('declare namespace bbspec="bb_appfx_pagedefinition";/bbspec:PageDefinitionSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Page Definition Spec' as TYPE
                    from dbo.PAGEDEFINITIONCATALOG
                    where PAGEDEFINITIONSPEC.value('declare namespace bbspec="bb_appfx_pagedefinition";/bbspec:PageDefinitionSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'
                union all
                    select  SIMPLEDATALISTSPECXML.value('declare namespace bbspec="bb_appfx_simpledatalist";/bbspec:SimpleDataListSpec[1]/@Author','varchar(max)') as AUTHOR, NAME, DESCRIPTION, 'Simple Data List Spec' as TYPE
                    from dbo.SIMPLEDATALISTCATALOG
                    where SIMPLEDATALISTSPECXML.value('declare namespace bbspec="bb_appfx_simpledatalist";/bbspec:SimpleDataListSpec[1]/@Author','varchar(max)') <> 'Blackbaud Product Development'