USP_USAGEREPORT_GETREPORTPARAMETERS

Returns business process parameters to be used for the application usage report.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_USAGEREPORT_GETREPORTPARAMETERS
            (
                @ID uniqueidentifier
            )
            with execute as caller
            as
                set nocount on;

                select 
                    STARTDATE,
                    DATAKEY,
                    APPUSERKEY,
                    COMPONENTKEY,
                    DEFINITIONKEY,
                    PUBLICKEY,
                    dbo.UFN_DATE_GETEARLIESTTIME(getdate()) as ENDDATE
                from
                    dbo.USAGEREPORTPROCESS
                where
                    ID = @ID;