dbo.ADS_TUBaseTreeHasADSGroup

1create   trigger ADS_TUBaseTreeHasADSGroup on BaseTreeHasADSGroup  for Update not for Replication as begin  declare @ChangedOrg QBM_YSingleGUID 
2BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar
3(38) select @GenProcID = dbo.QBM_FGISessionContext('') if update(XOrigin) or update(XIsInEffect) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert
4 into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct a.UID_Org as uid from BaseTreeHasADSGroup
5 a join deleted d on a.XObjectKey = d.XObjectKey where ( dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, a.XOrigin, d.XIsInEffect, a.XIsInEffect) = 1 or dbo.QER_FCVXOriginToInheritInfo
6(d.XOrigin) <> dbo.QER_FCVXOriginToInheritInfo(a.XOrigin) ) ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeHasObject', @DBQueueElements_01 insert into
7 @ChangedOrg (UID_SingleGuid) select distinct d.UID_Org as uid from BaseTreeHasADSGroup a join deleted d on a.XObjectKey = d.XObjectKey where dbo.QBM_FGIXOriginChanged_Effect
8(d.XOrigin, a.XOrigin, d.XIsInEffect, a.XIsInEffect) = 1 if @@ROWCOUNT > 0  begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02
9 (object, subobject, genprocid) select x.uid, 'ADS-K-OrgHasADSGroup', @GenProcID from ( select c.UID_SingleGuid as uid from @ChangedOrg c ) as x exec QBM_PDBQueueInsert_Bulk
10 'QER-K-AllChildrenOfOrg', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid
11) select x.uid, null, @GenProcID from ( select b.UID_Org as uid from @ChangedOrg c join BaseTree b on c.UID_SingleGuid = b.UID_Org where b.ITShopInfo =
12 'BO' ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-OrgAutoChild', @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04
13 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ADS.UID_ADSAccount as uid from @ChangedOrg c join PersoninBaseTree pio on 
14c.UID_SingleGuid = pio.UID_Org and pio.XOrigin > 0 join ADSaccount ADS on ADS.UID_Person = pio.UID_Person and ADS.IsGroupAccount = 1 union select ADS.UID_ADSAccount
15 as uid from @ChangedOrg c join HelperPersonOrg hpo on c.UID_SingleGuid = hpo.UID_Org join ADSaccount ADS on ADS.UID_Person = hpo.UID_Person and ADS.IsGroupAccount
16 = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05
17 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ADS.UID_ADSContact as uid from @ChangedOrg c join PersoninBaseTree pio on 
18c.UID_SingleGuid = pio.UID_Org and pio.XOrigin > 0 join ADSContact ADS on ADS.UID_Person = pio.UID_Person and ADS.IsGroupAccount = 1 union select ADS.UID_ADSContact
19 as uid from @ChangedOrg c join HelperPersonOrg hpo on c.UID_SingleGuid = hpo.UID_Org join ADSContact ADS on ADS.UID_Person = hpo.UID_Person and ADS.IsGroupAccount
20 = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_05 if '1' = dbo.QBM_FGIConfigparmValue('TargetSystem\ADS\HardwareInGroupFromOrg'
21) begin declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (object, subobject, genprocid) select x.uid, null, @GenProcID from 
22(  select m.UID_ADSMachine as uid from @ChangedOrg c join WorkDeskinBaseTree pio on c.UID_SingleGuid = pio.UID_Org and pio.XOrigin > 0 join Hardware ADS
23 on ADS.uid_WorkDesk = pio.uid_WorkDesk join ADSMachine m on ADS.UID_Hardware = m.UID_Hardware union select m.UID_ADSMachine as uid from @ChangedOrg c 
24join HelperWorkDeskOrg hpo on c.UID_SingleGuid = hpo.UID_Org join Hardware ADS on ADS.uid_WorkDesk = hpo.uid_WorkDesk join ADSMachine m on ADS.UID_Hardware
25 = m.UID_Hardware union  select m.UID_ADSMachine as uid from @ChangedOrg c join HardwareinBaseTree pio on c.UID_SingleGuid = pio.UID_Org and pio.XOrigin
26 > 0 join Hardware ADS on pio.uid_Hardware = ADS.uid_Hardware join ADSMachine m on ADS.UID_Hardware = m.uid_Hardware union select m.UID_ADSMachine as uid
27 from @ChangedOrg c join HelperHardwareOrg hpo on c.UID_SingleGuid = hpo.UID_Org join Hardware ADS on hpo.uid_Hardware = ADS.uid_Hardware join ADSMachine
28 m on ADS.UID_Hardware = m.uid_Hardware ) as x exec QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 end  end  end  END TRY BEGIN
29 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
30