UFN_SYSTEMROLEADGROUP_GETSITES

Returns a table of sites assigned to a system role active directory group.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEADGROUPID	uniqueidentifier	IN

Definition

Copy



            CREATE FUNCTION dbo.UFN_SYSTEMROLEADGROUP_GETSITES
            (
                @SYSTEMROLEADGROUPID uniqueidentifier
            )
            returns table
            as
            return 
            (
                select 
                    SYSTEMROLEADGROUPSITE.ID,
                    SYSTEMROLEADGROUPSITE.SITEID
                from 
                    dbo.SYSTEMROLEADGROUPSITE
                where 
                    SYSTEMROLEADGROUPSITE.SYSTEMROLEADGROUPID = @SYSTEMROLEADGROUPID
            )