Back to OIM Explorer

dbo.ADS_TDADSGroupCollection

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on ADSGroupCollection. Bulk DBQueue insert -> ADS-K-PersonHasObject / ADS_ZPersonHasObject at line 8; Bulk DBQueue insert -> ADS-K-BaseTreeHasObject / ADS_ZBaseTreeHasObject at line 8; Bulk DBQueue insert -> ADS-K-BaseTreeHasObject / ADS_ZBaseTreeHasObject at line 10; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.745 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 -> ADS-K-PersonHasObject / ADS_ZPersonHasObject at line 8
  • Bulk DBQueue insert -> ADS-K-BaseTreeHasObject / ADS_ZBaseTreeHasObject at line 8
  • Bulk DBQueue insert -> ADS-K-BaseTreeHasObject / ADS_ZBaseTreeHasObject at line 10
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: ADSGroupCollection

Typed Edges

  • queues DBQueue task ADS_ZPersonHasObject at line 8 Bulk DBQueue insert -> ADS-K-PersonHasObject / ADS_ZPersonHasObject at line 8
  • queues DBQueue task ADS_ZBaseTreeHasObject at line 8 Bulk DBQueue insert -> ADS-K-BaseTreeHasObject / ADS_ZBaseTreeHasObject at line 8
  • queues DBQueue task ADS_ZBaseTreeHasObject at line 10 Bulk DBQueue insert -> ADS-K-BaseTreeHasObject / ADS_ZBaseTreeHasObject at line 10
  • trigger on table ADSGroupCollection Trigger parent table: ADSGroupCollection
  • 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.ADS_TDAdsGroup source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL83 lines
1CREATE trigger ADS_TDADSGroupCollection2  ON ADSGroupCollection FOR3DELETE NOT FOR Replication4AS5BEGIN6  IF EXISTS(7    SELECT TOP 1 18    FROM deleted)9  GOTO start10  RETURN start:11  BEGIN TRY12    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 a.uid_person AS uid24    FROM ADSAccountInADSGroup uig25    JOIN(26    SELECT uid_ADSGroupParent AS UID_Group27    FROM deleted28    UNION29    SELECT UID_ADSGroupChild30    FROM deleted) AS x31      ON x.uid_group = uig.uid_ADSGroup AND uig.XOrigin > 0 AND uig.XIsInEffect = 132    JOIN ADSAccount a33      ON uig.UID_ADSAccount = a.uid_ADSaccount34    WHERE35      a.uid_person > ' '36    UNION37    SELECT a.uid_person AS uid38    FROM ADSContactInADSGroup uig39    JOIN(40    SELECT uid_ADSGroupParent AS UID_Group41    FROM deleted42    UNION43    SELECT UID_ADSGroupChild44    FROM deleted) AS x45      ON x.uid_group = uig.uid_ADSGroup AND uig.XOrigin > 0 AND uig.XIsInEffect = 146    JOIN ADSContact a47      ON uig.UID_ADSContact = a.uid_ADSContact48    WHERE49      a.uid_person > ' ') AS x50    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-PersonHasObject',51      @DBQueueElements_0152    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw53    INSERT INTO @DBQueueElements_02(object,54    subobject,55    genprocid)56    SELECT57      x.uid,58      NULL,59      @GenProcID60    FROM(61    SELECT62      DISTINCT uig.UID_Org AS uid63    FROM BaseTreeHasADSGroup uig64    JOIN(65    SELECT uid_ADSGroupParent AS UID_Group66    FROM deleted67    UNION68    SELECT UID_ADSGroupChild69    FROM deleted) AS x70      ON x.uid_group = uig.uid_ADSGroup AND uig.XOrigin > 0) AS x71    EXEC QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeHasObject',72      @DBQueueElements_0273  END TRY74  BEGIN CATCH75    EXEC QBM_PSessionErrorAdd DEFAULT76    RAISERROR('',77    18,78    1)79      WITH NOWAIT80  END CATCH81  ende:82  RETURN83END
Open raw exported source
SQL ยท Raw13 lines
1create   trigger ADS_TDADSGroupCollection on ADSGroupCollection  for Delete not for Replication as begin  if exists (select top 1 1 from deleted2) goto start return start: BEGIN TRY 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 a.uid_person as uid from ADSAccountInADSGroup4 uig join (select uid_ADSGroupParent as UID_Group from deleted union select UID_ADSGroupChild from deleted ) as x on x.uid_group = uig.uid_ADSGroup and5 uig.XOrigin > 0 and uig.XIsInEffect = 1 join ADSAccount a on uig.UID_ADSAccount = a.uid_ADSaccount where a.uid_person > ' ' union select a.uid_person 6as uid from ADSContactInADSGroup uig join (select uid_ADSGroupParent as UID_Group from deleted union select UID_ADSGroupChild from deleted ) as x on x.uid_group7 = uig.uid_ADSGroup and uig.XOrigin > 0 and uig.XIsInEffect = 1 join ADSContact a on uig.UID_ADSContact = a.uid_ADSContact where a.uid_person > ' ' ) as8 x exec QBM_PDBQueueInsert_Bulk 'ADS-K-PersonHasObject', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_029 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct uig.UID_Org as uid from BaseTreeHasADSGroup uig join (select uid_ADSGroupParent10 as UID_Group from deleted union select UID_ADSGroupChild from deleted ) as x on x.uid_group = uig.uid_ADSGroup and uig.XOrigin > 0  ) as x exec QBM_PDBQueueInsert_Bulk11 'ADS-K-BaseTreeHasObject', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende:12 return end 13