Back to OIM Explorer

dbo.ADS_FTGroupMembersValid_M

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

Source size: 1.686 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

  • No direct source references extracted.

Complete Source

SQL74 lines
1CREATE FUNCTION dbo.ADS_FTGroupMembersValid_M(2  @ObjectKeyMember varchar(138)3) RETURNS @erg TABLE(UID_ADSGroup varchar(38) collate database_default,4UID_ADSDomainMember varchar(38) collate database_default,5ObjectKeyMember varchar(138) collate database_default6)7AS8BEGIN9  DECLARE @UID_ADSDomainMember varchar(38)10  DECLARE @ObjectClassMember nvarchar(256)11  DECLARE @IsDistribution_M int,12  @IsGlobal_M int,13  @IsLocal_M int,14  @IsUniversal_M int,15  @IsSecurity_M int16  IF @ObjectKeyMember LIKE '<Key><T>ADSAccount</T>%'17  BEGIN18    INSERT INTO @erg(UID_ADSGroup,19    UID_ADSDomainMember,20    ObjectKeyMember)21    SELECT22      v.UID_ADSGroupContainer,23      v.UID_ADSDomainMember,24      @ObjectKeyMember25    FROM ADS_VGroupMemberValid_Account v26    WHERE27      v.XObjectKeyMember = @ObjectKeyMember28    GOTO endLabel29  END30  IF @ObjectKeyMember LIKE '<Key><T>ADSContact</T>%'31  BEGIN32    INSERT INTO @erg(UID_ADSGroup,33    UID_ADSDomainMember,34    ObjectKeyMember)35    SELECT36      v.UID_ADSGroupContainer,37      v.UID_ADSDomainMember,38      @ObjectKeyMember39    FROM ADS_VGroupMemberValid_Contact v40    WHERE41      v.XObjectKeyMember = @ObjectKeyMember42    GOTO endLabel43  END44  IF @ObjectKeyMember LIKE '<Key><T>ADSMachine</T>%'45  BEGIN46    INSERT INTO @erg(UID_ADSGroup,47    UID_ADSDomainMember,48    ObjectKeyMember)49    SELECT50      v.UID_ADSGroupContainer,51      v.UID_ADSDomainMember,52      @ObjectKeyMember53    FROM ADS_VGroupMemberValid_Machine v54    WHERE55      v.XObjectKeyMember = @ObjectKeyMember56    GOTO endLabel57  END58  IF @ObjectKeyMember LIKE '<Key><T>ADSGroup</T>%'59  BEGIN60    INSERT INTO @erg(UID_ADSGroup,61    UID_ADSDomainMember,62    ObjectKeyMember)63    SELECT64      v.UID_ADSGroupContainer,65      v.UID_ADSDomainMember,66      @ObjectKeyMember67    FROM ADS_VGroupMemberValid_Group v68    WHERE69      v.XObjectKeyMember = @ObjectKeyMember70    GOTO endLabel71  END72  endLabel:73  RETURN74END
Open raw exported source
SQL ยท Raw12 lines
1create function dbo.ADS_FTGroupMembersValid_M (@ObjectKeyMember varchar(138) ) returns @erg table (UID_ADSGroup varchar(38) collate database_default , 2UID_ADSDomainMember varchar(38) collate database_default , ObjectKeyMember varchar(138) collate database_default ) as begin declare @UID_ADSDomainMember3 varchar(38) declare @ObjectClassMember nvarchar(256) declare @IsDistribution_M int, @IsGlobal_M int, @IsLocal_M int, @IsUniversal_M int, @IsSecurity_M4 int if @ObjectKeyMember like '<Key><T>ADSAccount</T>%' begin insert into @erg(UID_ADSGroup, UID_ADSDomainMember, ObjectKeyMember) select v.UID_ADSGroupContainer5, v.UID_ADSDomainMember, @ObjectKeyMember from ADS_VGroupMemberValid_Account v where v.XObjectKeyMember = @ObjectKeyMember goto endLabel end if @ObjectKeyMember6 like '<Key><T>ADSContact</T>%' begin insert into @erg(UID_ADSGroup, UID_ADSDomainMember, ObjectKeyMember) select v.UID_ADSGroupContainer, v.UID_ADSDomainMember7, @ObjectKeyMember from ADS_VGroupMemberValid_Contact v where v.XObjectKeyMember = @ObjectKeyMember goto endLabel end if @ObjectKeyMember like '<Key><T>ADSMachine</T>%'8 begin insert into @erg(UID_ADSGroup, UID_ADSDomainMember, ObjectKeyMember) select v.UID_ADSGroupContainer, v.UID_ADSDomainMember, @ObjectKeyMember from9 ADS_VGroupMemberValid_Machine v where v.XObjectKeyMember = @ObjectKeyMember goto endLabel end if @ObjectKeyMember like '<Key><T>ADSGroup</T>%' begin insert10 into @erg(UID_ADSGroup, UID_ADSDomainMember, ObjectKeyMember) select v.UID_ADSGroupContainer, v.UID_ADSDomainMember, @ObjectKeyMember from ADS_VGroupMemberValid_Group11 v where v.XObjectKeyMember = @ObjectKeyMember goto endLabel end endLabel: return end 12