USP_DATALIST_SYSTEMROLEKPIINSTANCE

Returns a list of KPI instances for a given system role.

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SYSTEMROLEKPIINSTANCE(@SYSTEMROLEID uniqueidentifier)
as
    set nocount on;

    select SYSTEMROLEKPIINSTANCE.ID,
        KPIINSTANCE.ID KPIINSTANCEID,
        KPIINSTANCE.NAME,
        KPIINSTANCE.DESCRIPTION,
        KPICATALOG.NAME KPINAME
    from dbo.SYSTEMROLEKPIINSTANCE
    inner join dbo.KPIINSTANCE on SYSTEMROLEKPIINSTANCE.KPIINSTANCEID = KPIINSTANCE.ID
    inner join dbo.KPICATALOG on KPIINSTANCE.KPICATALOGID = KPICATALOG.ID
    where SYSTEMROLEKPIINSTANCE.SYSTEMROLEID = @SYSTEMROLEID;