Back to OIM Explorer

dbo.ADS_FGIUserInGroupValid

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.551 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVStringToList source text reference
  • references source dbo.QBM_FCVStringToListSplitted source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL84 lines
1CREATE FUNCTION dbo.ADS_FGIUserInGroupValid(2  @UID_ADSDomainGroup varchar(38),3  @uid_ADSGroup varchar(38),4  @UID_ADSDomainMember varchar(38),5  @ObjectClassMember nvarchar(256)6) RETURNS int7AS8BEGIN9  DECLARE @erg int = 010  DECLARE @type int = -111  SELECT @type = CASE @ObjectClassMember12  WHEN 'User' THEN13  114  WHEN 'Contact' THEN15  216  WHEN 'Computer' THEN17  318  ELSE -119  END20  IF @type = -121  BEGIN22    SELECT TOP 1 @type = x.marker23    FROM(24    SELECT25      'User' AS ObjectClass,26      1 AS marker27    UNION all28    SELECT29      'Contact',30      231    UNION all32    SELECT33      'Computer',34      3) AS x35    JOIN dbo.QBM_FCVStringToListSplitted(@ObjectClassMember,36    nchar(7),37    1,38    0,39    '') AS o40      ON o.ParameterName = x.ObjectClass41  END42  Auswerten:43  IF @type = 144  BEGIN45    IF EXISTS(46      SELECT TOP 1 147      FROM ADS_VGroupMemberValid_Account v48      WHERE49        v.UID_ADSDomainContainer = @UID_ADSDomainGroup AND v.UID_ADSGroupContainer = @uid_ADSGroup AND v.UID_ADSDomainMember = @UID_ADSDomainMember50    )51    BEGIN52      SELECT @erg = 153    END54    RETURN(@erg)55  END56  IF @type = 257  BEGIN58    IF EXISTS(59      SELECT TOP 1 160      FROM ADS_VGroupMemberValid_Contact v61      WHERE62        v.UID_ADSDomainContainer = @UID_ADSDomainGroup AND v.UID_ADSGroupContainer = @uid_ADSGroup AND v.UID_ADSDomainMember = @UID_ADSDomainMember63    )64    BEGIN65      SELECT @erg = 166    END67    RETURN(@erg)68  END69  IF @type = 370  BEGIN71    IF EXISTS(72      SELECT TOP 1 173      FROM ADS_VGroupMemberValid_Machine v74      WHERE75        v.UID_ADSDomainContainer = @UID_ADSDomainGroup AND v.UID_ADSGroupContainer = @uid_ADSGroup AND v.UID_ADSDomainMember = @UID_ADSDomainMember76    )77    BEGIN78      SELECT @erg = 179    END80    RETURN(@erg)81  END82  endLabel:83  RETURN(@erg)84END
Open raw exported source
SQL ยท Raw11 lines
1    create   function dbo.ADS_FGIUserInGroupValid ( @UID_ADSDomainGroup varchar(38) , @uid_ADSGroup varchar(38) , @UID_ADSDomainMember varchar(382)  , @ObjectClassMember nvarchar(256)   ) returns int as begin declare @erg int = 0 declare @type int = -1     select @type = case @ObjectClassMember when3 'User' then 1 when 'Contact' then 2 when 'Computer' then 3 else -1 end if @type = -1 begin select top 1 @type = x.marker from ( select 'User' as ObjectClass4, 1 as marker union all select 'Contact' , 2 union all select 'Computer' , 3 ) as x join dbo.QBM_FCVStringToListSplitted (@ObjectClassMember, nchar(7),5 1, 0, '') as o on o.ParameterName = x.ObjectClass end Auswerten: if @type = 1 begin if exists (select top 1 1 from ADS_VGroupMemberValid_Account v where6 v.UID_ADSDomainContainer = @UID_ADSDomainGroup and v.UID_ADSGroupContainer = @uid_ADSGroup and v.UID_ADSDomainMember = @UID_ADSDomainMember  ) begin select7 @erg = 1 end  return (@erg)  end if @type = 2 begin if exists (select top 1 1 from ADS_VGroupMemberValid_Contact v where v.UID_ADSDomainContainer = @UID_ADSDomainGroup8 and v.UID_ADSGroupContainer = @uid_ADSGroup and v.UID_ADSDomainMember = @UID_ADSDomainMember  ) begin select @erg = 1 end  return (@erg)  end if @type9 = 3 begin if exists (select top 1 1 from ADS_VGroupMemberValid_Machine v where v.UID_ADSDomainContainer = @UID_ADSDomainGroup and v.UID_ADSGroupContainer10 = @uid_ADSGroup and v.UID_ADSDomainMember = @UID_ADSDomainMember  ) begin select @erg = 1 end  return (@erg)  end endLabel: return(@erg) end 11