Back to OIM Explorer

dbo.ADS_FGIElementManagerValid

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 6.476 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_FCVObjectkeyToElement source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL252 lines
1CREATE FUNCTION dbo.ADS_FGIElementManagerValid(2  @ObjectKeyElement varchar(138),3  @ObjectKeyManager varchar(138)4) RETURNS BIT5AS6BEGIN7  DECLARE @erg BIT = 08  DECLARE @TableElement varchar(30)9  DECLARE @TableManager varchar(30)10  SELECT11    @TableElement = dbo.QBM_FCVObjectkeyToElement('TableName',12    @ObjectKeyElement)13  SELECT14    @TableManager = dbo.QBM_FCVObjectkeyToElement('TableName',15    @ObjectKeyManager)16  IF @TableElement = 'ADSGroup' AND @TableManager = 'ADSAccount'17  BEGIN18    IF EXISTS(19      SELECT TOP 1 120      FROM ADS_VElementManagerValid v21      WHERE22        v.ElementTable = 'ADSGroup' AND v.ManagerTable = 'ADSAccount' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager23    )24    BEGIN25      SELECT @erg = 126    END27    RETURN(@erg)28  END29  IF @TableElement = 'ADSGroup' AND @TableManager = 'ADSContact'30  BEGIN31    IF EXISTS(32      SELECT TOP 1 133      FROM ADS_VElementManagerValid v34      WHERE35        v.ElementTable = 'ADSGroup' AND v.ManagerTable = 'ADSContact' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager36    )37    BEGIN38      SELECT @erg = 139    END40    RETURN(@erg)41  END42  IF @TableElement = 'ADSGroup' AND @TableManager = 'ADSGroup'43  BEGIN44    IF EXISTS(45      SELECT TOP 1 146      FROM ADS_VElementManagerValid v47      WHERE48        v.ElementTable = 'ADSGroup' AND v.ManagerTable = 'ADSGroup' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager49    )50    BEGIN51      SELECT @erg = 152    END53    RETURN(@erg)54  END55  IF @TableElement = 'ADSAccount' AND @TableManager = 'ADSAccount'56  BEGIN57    IF EXISTS(58      SELECT TOP 1 159      FROM ADS_VElementManagerValid v60      WHERE61        v.ElementTable = 'ADSAccount' AND v.ManagerTable = 'ADSAccount' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager62    )63    BEGIN64      SELECT @erg = 165    END66    RETURN(@erg)67  END68  IF @TableElement = 'ADSAccount' AND @TableManager = 'ADSContact'69  BEGIN70    IF EXISTS(71      SELECT TOP 1 172      FROM ADS_VElementManagerValid v73      WHERE74        v.ElementTable = 'ADSAccount' AND v.ManagerTable = 'ADSContact' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager75    )76    BEGIN77      SELECT @erg = 178    END79    RETURN(@erg)80  END81  IF @TableElement = 'ADSAccount' AND @TableManager = 'ADSGroup'82  BEGIN83    IF EXISTS(84      SELECT TOP 1 185      FROM ADS_VElementManagerValid v86      WHERE87        v.ElementTable = 'ADSAccount' AND v.ManagerTable = 'ADSGroup' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager88    )89    BEGIN90      SELECT @erg = 191    END92    RETURN(@erg)93  END94  IF @TableElement = 'ADSContact' AND @TableManager = 'ADSAccount'95  BEGIN96    IF EXISTS(97      SELECT TOP 1 198      FROM ADS_VElementManagerValid v99      WHERE100        v.ElementTable = 'ADSContact' AND v.ManagerTable = 'ADSAccount' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager101    )102    BEGIN103      SELECT @erg = 1104    END105    RETURN(@erg)106  END107  IF @TableElement = 'ADSContact' AND @TableManager = 'ADSContact'108  BEGIN109    IF EXISTS(110      SELECT TOP 1 1111      FROM ADS_VElementManagerValid v112      WHERE113        v.ElementTable = 'ADSContact' AND v.ManagerTable = 'ADSContact' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager114    )115    BEGIN116      SELECT @erg = 1117    END118    RETURN(@erg)119  END120  IF @TableElement = 'ADSContact' AND @TableManager = 'ADSGroup'121  BEGIN122    IF EXISTS(123      SELECT TOP 1 1124      FROM ADS_VElementManagerValid v125      WHERE126        v.ElementTable = 'ADSContact' AND v.ManagerTable = 'ADSGroup' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager127    )128    BEGIN129      SELECT @erg = 1130    END131    RETURN(@erg)132  END133  IF @TableElement = 'ADSMachine' AND @TableManager = 'ADSAccount'134  BEGIN135    IF EXISTS(136      SELECT TOP 1 1137      FROM ADS_VElementManagerValid v138      WHERE139        v.ElementTable = 'ADSMachine' AND v.ManagerTable = 'ADSAccount' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager140    )141    BEGIN142      SELECT @erg = 1143    END144    RETURN(@erg)145  END146  IF @TableElement = 'ADSMachine' AND @TableManager = 'ADSContact'147  BEGIN148    IF EXISTS(149      SELECT TOP 1 1150      FROM ADS_VElementManagerValid v151      WHERE152        v.ElementTable = 'ADSMachine' AND v.ManagerTable = 'ADSContact' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager153    )154    BEGIN155      SELECT @erg = 1156    END157    RETURN(@erg)158  END159  IF @TableElement = 'ADSMachine' AND @TableManager = 'ADSGroup'160  BEGIN161    IF EXISTS(162      SELECT TOP 1 1163      FROM ADS_VElementManagerValid v164      WHERE165        v.ElementTable = 'ADSMachine' AND v.ManagerTable = 'ADSGroup' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager166    )167    BEGIN168      SELECT @erg = 1169    END170    RETURN(@erg)171  END172  IF @TableElement = 'ADSDomain' AND @TableManager = 'ADSAccount'173  BEGIN174    IF EXISTS(175      SELECT TOP 1 1176      FROM ADS_VElementManagerValid v177      WHERE178        v.ElementTable = 'ADSDomain' AND v.ManagerTable = 'ADSAccount' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager179    )180    BEGIN181      SELECT @erg = 1182    END183    RETURN(@erg)184  END185  IF @TableElement = 'ADSDomain' AND @TableManager = 'ADSContact'186  BEGIN187    IF EXISTS(188      SELECT TOP 1 1189      FROM ADS_VElementManagerValid v190      WHERE191        v.ElementTable = 'ADSDomain' AND v.ManagerTable = 'ADSContact' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager192    )193    BEGIN194      SELECT @erg = 1195    END196    RETURN(@erg)197  END198  IF @TableElement = 'ADSDomain' AND @TableManager = 'ADSGroup'199  BEGIN200    IF EXISTS(201      SELECT TOP 1 1202      FROM ADS_VElementManagerValid v203      WHERE204        v.ElementTable = 'ADSDomain' AND v.ManagerTable = 'ADSGroup' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager205    )206    BEGIN207      SELECT @erg = 1208    END209    RETURN(@erg)210  END211  IF @TableElement = 'ADSContainer' AND @TableManager = 'ADSAccount'212  BEGIN213    IF EXISTS(214      SELECT TOP 1 1215      FROM ADS_VElementManagerValid v216      WHERE217        v.ElementTable = 'ADSContainer' AND v.ManagerTable = 'ADSAccount' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager218    )219    BEGIN220      SELECT @erg = 1221    END222    RETURN(@erg)223  END224  IF @TableElement = 'ADSContainer' AND @TableManager = 'ADSContact'225  BEGIN226    IF EXISTS(227      SELECT TOP 1 1228      FROM ADS_VElementManagerValid v229      WHERE230        v.ElementTable = 'ADSContainer' AND v.ManagerTable = 'ADSContact' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager231    )232    BEGIN233      SELECT @erg = 1234    END235    RETURN(@erg)236  END237  IF @TableElement = 'ADSContainer' AND @TableManager = 'ADSGroup'238  BEGIN239    IF EXISTS(240      SELECT TOP 1 1241      FROM ADS_VElementManagerValid v242      WHERE243        v.ElementTable = 'ADSContainer' AND v.ManagerTable = 'ADSGroup' AND v.ObjectKeyElement = @ObjectKeyElement AND v.ObjectKeyManager = @ObjectKeyManager244    )245    BEGIN246      SELECT @erg = 1247    END248    RETURN(@erg)249  END250  endlabel:251  RETURN(@erg)252END
Open raw exported source
SQL ยท Raw42 lines
1   create   function dbo.ADS_FGIElementManagerValid (@ObjectKeyElement varchar(138) , @ObjectKeyManager varchar(138) ) returns bit as begin   declare2 @erg bit = 0 declare @TableElement varchar(30) declare @TableManager varchar(30) select @TableElement = dbo.QBM_FCVObjectkeyToElement('TableName', @ObjectKeyElement3) select @TableManager = dbo.QBM_FCVObjectkeyToElement('TableName', @ObjectKeyManager) if @TableElement = 'ADSGroup' and @TableManager = 'ADSAccount' begin4 if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSGroup' and v.ManagerTable = 'ADSAccount' and v.ObjectKeyElement =5 @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSGroup' and @TableManager6 = 'ADSContact' begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSGroup' and v.ManagerTable = 'ADSContact' and7 v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSGroup'8 and @TableManager = 'ADSGroup' begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSGroup' and v.ManagerTable = 9'ADSGroup' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if @TableElement10 = 'ADSAccount' and @TableManager = 'ADSAccount' begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSAccount' and11 v.ManagerTable = 'ADSAccount' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return12 (@erg)  end if @TableElement = 'ADSAccount' and @TableManager = 'ADSContact' begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable13 = 'ADSAccount' and v.ManagerTable = 'ADSContact' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select 14@erg = 1 end  return (@erg)  end if @TableElement = 'ADSAccount' and @TableManager = 'ADSGroup' begin if exists (select top 1 1 from ADS_VElementManagerValid15 v where v.ElementTable = 'ADSAccount' and v.ManagerTable = 'ADSGroup' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager16 ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSContact' and @TableManager = 'ADSAccount' begin if exists (select top 1 1 from 17ADS_VElementManagerValid v where v.ElementTable = 'ADSContact' and v.ManagerTable = 'ADSAccount' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager18 = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSContact' and @TableManager = 'ADSContact' begin if exists (select19 top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSContact' and v.ManagerTable = 'ADSContact' and v.ObjectKeyElement = @ObjectKeyElement20 and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSContact' and @TableManager = 'ADSGroup'21 begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSContact' and v.ManagerTable = 'ADSGroup' and v.ObjectKeyElement22 = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSMachine' and @TableManager23 = 'ADSAccount' begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSMachine' and v.ManagerTable = 'ADSAccount' and24 v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSMachine'25 and @TableManager = 'ADSContact' begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSMachine' and v.ManagerTable26 = 'ADSContact' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if27 @TableElement = 'ADSMachine' and @TableManager = 'ADSGroup' begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSMachine'28 and v.ManagerTable = 'ADSGroup' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return29 (@erg)  end if @TableElement = 'ADSDomain' and @TableManager = 'ADSAccount' begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable30 = 'ADSDomain' and v.ManagerTable = 'ADSAccount' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg31 = 1 end  return (@erg)  end if @TableElement = 'ADSDomain' and @TableManager = 'ADSContact' begin if exists (select top 1 1 from ADS_VElementManagerValid32 v where v.ElementTable = 'ADSDomain' and v.ManagerTable = 'ADSContact' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager33 ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSDomain' and @TableManager = 'ADSGroup' begin if exists (select top 1 1 from ADS_VElementManagerValid34 v where v.ElementTable = 'ADSDomain' and v.ManagerTable = 'ADSGroup' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager35 ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSContainer' and @TableManager = 'ADSAccount' begin if exists (select top 1 1 from36 ADS_VElementManagerValid v where v.ElementTable = 'ADSContainer' and v.ManagerTable = 'ADSAccount' and v.ObjectKeyElement = @ObjectKeyElement and v.ObjectKeyManager37 = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSContainer' and @TableManager = 'ADSContact' begin if exists38 (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSContainer' and v.ManagerTable = 'ADSContact' and v.ObjectKeyElement = @ObjectKeyElement39 and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end if @TableElement = 'ADSContainer' and @TableManager = 'ADSGroup'40 begin if exists (select top 1 1 from ADS_VElementManagerValid v where v.ElementTable = 'ADSContainer' and v.ManagerTable = 'ADSGroup' and v.ObjectKeyElement41 = @ObjectKeyElement and v.ObjectKeyManager = @ObjectKeyManager ) begin select @erg = 1 end  return (@erg)  end endlabel:  return (@erg) end 42