dbo.LDP_TDLDAPGroupExclusion
Database TriggerSQL_TRIGGERSandbox DB
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 5
- Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 5
- Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 5
- Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 9
- Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 9
- Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 12
- References QBM_PDBQueueInsert_Bulk
- Trigger parent table: LDAPGroupExclusion
Typed Edges
- queues DBQueue task LDP_ZAccountInLDAPGroup at line 5 Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 5
- queues DBQueue task LDP_ZLDPMachineInLDAPGroup at line 5 Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 5
- queues DBQueue task LDP_ZOrgHasLDAPGroup at line 5 Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 5
- queues DBQueue task LDP_ZLDPMachineInLDAPGroup at line 9 Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 9
- queues DBQueue task LDP_ZOrgHasLDAPGroup at line 9 Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 9
- queues DBQueue task LDP_ZOrgHasLDAPGroup at line 12 Bulk DBQueue insert -> LDP-K-OrgHasLDAPGroup / LDP_ZOrgHasLDAPGroup at line 12
- trigger on table LDAPGroupExclusion Trigger parent table: LDAPGroupExclusion
- 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
Referenced By
- No direct source references extracted.
Complete Source
1CREATE trigger LDP_TDLDAPGroupExclusion2 ON LDAPGroupExclusion FOR3DELETE NOT FOR Replication4AS5BEGIN6 BEGIN TRY7 IF EXISTS(8 SELECT TOP 1 19 FROM deleted)10 GOTO start11 RETURN start:12 DECLARE @GenProcID varchar(38)13 SELECT @GenProcID = dbo.QBM_FGISessionContext('')14 DECLARE @DBQueueElements_01 QBM_YDBQueueRaw15 INSERT INTO @DBQueueElements_01(object,16 subobject,17 genprocid)18 SELECT19 x.uid,20 NULL,21 @GenProcID22 FROM(23 SELECT uig.UID_LDAPAccount AS uid24 FROM(25 SELECT UID_LDAPGroupLower AS UID_LDAPGroup26 FROM deleted27 UNION28 SELECT UID_LDAPGroupHigher29 FROM deleted) AS y30 JOIN LDAPGroupCollection coll31 ON y.UID_LDAPGroup = coll.UID_LDAPGroupParent32 JOIN LDAPAccountInLDAPGroup uig33 ON coll.UID_LDAPGroupChild = uig.uid_LDAPGroup AND uig.XOrigin > 0) AS x34 EXEC QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup',35 @DBQueueElements_0136 DECLARE @DBQueueElements_02 QBM_YDBQueueRaw37 INSERT INTO @DBQueueElements_02(object,38 subobject,39 genprocid)40 SELECT41 x.uid,42 NULL,43 @GenProcID44 FROM(45 SELECT uig.UID_LDPMachine AS uid46 FROM(47 SELECT UID_LDAPGroupLower AS UID_LDAPGroup48 FROM deleted49 UNION50 SELECT UID_LDAPGroupHigher51 FROM deleted) AS y52 JOIN LDAPGroupCollection coll53 ON y.UID_LDAPGroup = coll.UID_LDAPGroupParent54 JOIN LDPMachineInLDAPGroup uig55 ON coll.UID_LDAPGroupChild = uig.uid_LDAPGroup AND uig.XOrigin > 0) AS x56 EXEC QBM_PDBQueueInsert_Bulk 'LDP-K-LDPMachineInLDAPGroup',57 @DBQueueElements_0258 DECLARE @DBQueueElements_03 QBM_YDBQueueRaw59 INSERT INTO @DBQueueElements_03(object,60 subobject,61 genprocid)62 SELECT63 x.uid,64 NULL,65 @GenProcID66 FROM(67 SELECT g.UID_Org AS uid68 FROM(69 SELECT UID_LDAPGroupLower AS UID_LDAPGroup70 FROM deleted71 UNION72 SELECT UID_LDAPGroupHigher73 FROM deleted) AS y74 JOIN BaseTreeHasLDAPGroup g75 ON y.UID_LDAPGroup = g.UID_LDAPGroup) AS x76 EXEC QBM_PDBQueueInsert_Bulk 'LDP-K-OrgHasLDAPGroup',77 @DBQueueElements_0378 END TRY79 BEGIN CATCH80 EXEC QBM_PSessionErrorAdd DEFAULT81 RAISERROR('',82 18,83 1)84 WITH NOWAIT85 END CATCH86 ende:87 RETURN88ENDOpen raw exported source
1create trigger LDP_TDLDAPGroupExclusion on LDAPGroupExclusion for Delete not for Replication as begin BEGIN TRY if exists (select top 1 1 from2 deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') declare @DBQueueElements_01 QBM_YDBQueueRaw3 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_LDAPAccount as uid from ( select 4UID_LDAPGroupLower as UID_LDAPGroup from deleted union select UID_LDAPGroupHigher from deleted ) as y join LDAPGroupCollection coll on y.UID_LDAPGroup5 = coll.UID_LDAPGroupParent join LDAPAccountInLDAPGroup uig on coll.UID_LDAPGroupChild = uig.uid_LDAPGroup and uig.XOrigin > 0 ) as x exec QBM_PDBQueueInsert_Bulk6 'LDP-K-LDAPAccountInLDAPGroup', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid7) select x.uid, null, @GenProcID from ( select uig.UID_LDPMachine as uid from ( select UID_LDAPGroupLower as UID_LDAPGroup from deleted union select UID_LDAPGroupHigher8 from deleted ) as y join LDAPGroupCollection coll on y.UID_LDAPGroup = coll.UID_LDAPGroupParent join LDPMachineInLDAPGroup uig on coll.UID_LDAPGroupChild9 = uig.uid_LDAPGroup and uig.XOrigin > 0 ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-LDPMachineInLDAPGroup', @DBQueueElements_02 declare @DBQueueElements_0310 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select g.UID_Org as uid from ( select11 UID_LDAPGroupLower as UID_LDAPGroup from deleted union select UID_LDAPGroupHigher from deleted ) as y join BaseTreeHasLDAPGroup g on y.UID_LDAPGroup =12 g.UID_LDAPGroup ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-OrgHasLDAPGroup', @DBQueueElements_03 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default13 RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 14