USP_USAGEREPORT_REPORTDEFINITIONS

Returns the sql definitions of the functions, views, and stored procedures used to calculate the application usage report.

Definition

Copy



            create procedure dbo.USP_USAGEREPORT_REPORTDEFINITIONS
            with execute as caller
            as
                set nocount on;

                select 
                    OBJECTS.NAME, 
                    MODULES.DEFINITION 
                from 
                    SYS.ALL_SQL_MODULES as Modules
                    inner join SYS.OBJECTS as OBJECTS on OBJECTS.OBJECT_ID = MODULES.OBJECT_ID
                where 
                    OBJECTS.NAME in ('UFN_USAGEREPORT_GETREPORTVALUES', 'USP_USAGEREPORT_REPORTDEFINITIONS', 'V_USAGEREPORT_CUSTOMCATALOGCOMPONENTS', 'V_USAGEREPORT_USERSWITHEDITRIGHTS')