Back to OIM Explorer

dbo.LDP_TILDAPGroupExclusion

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on LDAPGroupExclusion. Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 11; Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 11; Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 11; Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 15

Source: sandbox-db sys.sql_modules

Source size: 2.869 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 11
  • Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 11
  • Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 11
  • Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 15
  • Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 15
  • Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 17
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: LDAPGroupExclusion

Typed Edges

  • queues DBQueue task LDP_ZAccountInLDAPGroup at line 11 Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 11
  • queues DBQueue task LDP_ZLDPMachineInLDAPGroup at line 11 Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 11
  • queues DBQueue task LDP_ZOrgHasLDAPGroup at line 11 Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 11
  • queues DBQueue task LDP_ZLDPMachineInLDAPGroup at line 15 Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 15
  • queues DBQueue task LDP_ZOrgHasLDAPGroup at line 15 Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 15
  • queues DBQueue task LDP_ZOrgHasLDAPGroup at line 17 Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 17
  • trigger on table LDAPGroupExclusion Trigger parent table: LDAPGroupExclusion
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PExclusionCheckCircular source text reference
  • references source dbo.LDP_TILDAPGroup source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL121 lines
1CREATE trigger LDP_TILDAPGroupExclusion2  ON LDAPGroupExclusion FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @exclusions QBM_YParameterList7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GenProcID varchar(38)14    SELECT @GenProcID = dbo.QBM_FGISessionContext('')15    IF dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\GroupExclusion') = ''16    BEGIN17      RAISERROR('#LDS#Cannot make a definition because exclusion is not enabled by config parm.|',18      18,19      2)20        WITH nowait21    END22    INSERT INTO @exclusions(Parameter1,23    Parameter2)24    SELECT25      UID_LDAPGroupHigher,26      UID_LDAPGroupLower27    FROM inserted28    EXEC QER_PExclusionCheckCircular @TargetTable = 'LDAPGroupExclusion',29      @HigherColumn = 'UID_LDAPGroupHigher',30      @LowerColumn = 'UID_LDAPGroupLower',31      @exclusions = @exclusions32    IF EXISTS(33      SELECT TOP 1 134      FROM LDAPGroup t35      JOIN inserted i36        ON t.uid_LDAPGroup = i.uid_LDAPGroupLower AND t.IsDynamicGroup = 1) OR EXISTS(37    SELECT TOP 1 138    FROM LDAPGroup t39    JOIN inserted i40      ON t.uid_LDAPGroup = i.uid_LDAPGroupHigher AND t.IsDynamicGroup = 1)41    BEGIN42      RAISERROR('#LDS#Cannot make assignment because dynamic groups are involved.|',43      18,44      1)45        WITH nowait46    END47    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw48    INSERT INTO @DBQueueElements_01(object,49    subobject,50    genprocid)51    SELECT52      x.uid,53      NULL,54      @GenProcID55    FROM(56    SELECT uig.uid_LDAPAccount AS uid57    FROM(58    SELECT UID_LDAPGroupLower AS UID_LDAPGroup59    FROM inserted60    UNION61    SELECT UID_LDAPGroupHigher62    FROM inserted) AS y63    JOIN LDAPGroupCollection coll64      ON y.UID_LDAPGroup = coll.UID_LDAPGroupParent65    JOIN LDAPAccountInLDAPGroup uig66      ON coll.UID_LDAPGroupChild = uig.uid_LDAPGroup AND uig.XOrigin > 0) AS x67    EXEC QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup',68      @DBQueueElements_0169    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw70    INSERT INTO @DBQueueElements_02(object,71    subobject,72    genprocid)73    SELECT74      x.uid,75      NULL,76      @GenProcID77    FROM(78    SELECT uig.uid_LDPMachine AS uid79    FROM(80    SELECT UID_LDAPGroupLower AS UID_LDAPGroup81    FROM inserted82    UNION83    SELECT UID_LDAPGroupHigher84    FROM inserted) AS y85    JOIN LDAPGroupCollection coll86      ON y.UID_LDAPGroup = coll.UID_LDAPGroupParent87    JOIN LDPMachineInLDAPGroup uig88      ON coll.UID_LDAPGroupChild = uig.uid_LDAPGroup AND uig.XOrigin > 0) AS x89    EXEC QBM_PDBQueueInsert_Bulk 'LDP-K-LDPMachineInLDAPGroup',90      @DBQueueElements_0291    DECLARE @DBQueueElements_03 QBM_YDBQueueRaw92    INSERT INTO @DBQueueElements_03(object,93    subobject,94    genprocid)95    SELECT96      x.uid,97      NULL,98      @GenProcID99    FROM(100    SELECT g.UID_Org AS uid101    FROM(102    SELECT UID_LDAPGroupLower AS UID_LDAPGroup103    FROM inserted104    UNION105    SELECT UID_LDAPGroupHigher106    FROM inserted) AS y107    JOIN BaseTreeHasLDAPGroup g108      ON y.UID_LDAPGroup = g.UID_LDAPGroup) AS x109    EXEC QBM_PDBQueueInsert_Bulk 'LDP-K-OrgHasLDAPGroup',110      @DBQueueElements_03111  END TRY112  BEGIN CATCH113    EXEC QBM_PSessionErrorAdd DEFAULT114    RAISERROR('',115    18,116    1)117      WITH NOWAIT118  END CATCH119  ende:120  RETURN121END
Open raw exported source
SQL ยท Raw20 lines
1    create   trigger LDP_TILDAPGroupExclusion on LDAPGroupExclusion  for Insert not for Replication as begin  declare @exclusions QBM_YParameterList2 BEGIN TRY if exists (select top 1 1 from inserted) goto start return start:  declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext3('') if dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\GroupExclusion') = '' begin raiserror( '#LDS#Cannot make a definition because exclusion is not enabled by config parm.|'4, 18, 2) with nowait end insert into @exclusions (Parameter1, Parameter2) select UID_LDAPGroupHigher, UID_LDAPGroupLower from inserted exec QER_PExclusionCheckCircular5 @TargetTable = 'LDAPGroupExclusion' , @HigherColumn = 'UID_LDAPGroupHigher' , @LowerColumn = 'UID_LDAPGroupLower' , @exclusions = @exclusions  if exists6 (select top 1 1 from LDAPGroup t join inserted i on t.uid_LDAPGroup = i.uid_LDAPGroupLower and t.IsDynamicGroup = 1 ) or exists (select top 1 1 from LDAPGroup7 t join inserted i on t.uid_LDAPGroup = i.uid_LDAPGroupHigher and t.IsDynamicGroup = 1 ) begin  raiserror('#LDS#Cannot make assignment because dynamic groups are involved.|'8, 18, 1) with nowait end  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null9, @GenProcID from ( select uig.uid_LDAPAccount as uid from ( select UID_LDAPGroupLower as UID_LDAPGroup from inserted union select UID_LDAPGroupHigher 10from inserted ) as y  join LDAPGroupCollection coll on y.UID_LDAPGroup = coll.UID_LDAPGroupParent join LDAPAccountInLDAPGroup uig on coll.UID_LDAPGroupChild11 = uig.uid_LDAPGroup and uig.XOrigin > 0  ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup', @DBQueueElements_01  declare @DBQueueElements_0212 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.uid_LDPMachine as uid 13from ( select UID_LDAPGroupLower as UID_LDAPGroup from inserted union select UID_LDAPGroupHigher from inserted ) as y  join LDAPGroupCollection coll on14 y.UID_LDAPGroup = coll.UID_LDAPGroupParent join LDPMachineInLDAPGroup uig on coll.UID_LDAPGroupChild = uig.uid_LDAPGroup and uig.XOrigin > 0  ) as x exec15 QBM_PDBQueueInsert_Bulk 'LDP-K-LDPMachineInLDAPGroup', @DBQueueElements_02  declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_0316 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select g.UID_Org as uid from ( select UID_LDAPGroupLower as UID_LDAPGroup from inserted17 union select UID_LDAPGroupHigher from inserted ) as y join BaseTreeHasLDAPGroup g on y.UID_LDAPGroup = g.UID_LDAPGroup ) as x exec QBM_PDBQueueInsert_Bulk18 'LDP-K-OrgHasLDAPGroup', @DBQueueElements_03 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return19 end 20