dbo.LDP_TIBaseTreeHasLDAPGroup

1    create   trigger LDP_TIBaseTreeHasLDAPGroup on BaseTreeHasLDAPGroup  for Insert not for Replication as begin  declare @QBM_BitPatternXOrigin_Direct
2 int = dbo.QBM_FGIBitPatternXOrigin('|Direct|', 0) declare @QBM_BitPatternXOrigin_Inherit_inv int = dbo.QBM_FGIBitPatternXOrigin('|Inherit|', 1)  BEGIN
3 TRY if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')
4 declare @AssignCheckValues QBM_YparameterList insert into @AssignCheckValues(Parameter1, Parameter2) select i.UID_Org, i.XOrigin from inserted i exec 
5QER_PAssignmentCheckValid 'LDP-AsgnBT-LDAPGroup', @AssignCheckValues, @GenProcID  if exists (select top 1 1 from inserted i join LDAPGroup t on i.uid_LDAPGroup
6 = t.uid_LDAPGroup and t.IsDynamicGroup = 1 ) begin  raiserror( '#LDS#Cannot make assignment because it involves a dynamic LDAP group.|', 18, 2) with nowait
7 end  if exists (select top 1 1 from inserted i join BaseTree dest on i.uid_Org = dest.uid_Org  join LDAPGroup elem on i.uid_LDAPGroup = elem.uid_LDAPGroup
8 where dbo.QER_FGIITShopFlagCombineValid(dest.XObjectKey, null, null, elem.XObjectKey, elem.IsForITShop, elem.IsITShopOnly) = 0 and i.XOrigin & @QBM_BitPatternXOrigin_Direct
9 > 0 ) begin  raiserror ('#LDS#Assignment is not permitted due to the combination of IT Shop flags.|', 18, 2) with nowait end  if exists (select top 1 
101 from inserted i join LDAPGroup g on i.uid_LDAPGroup = g.uid_LDAPGroup and g.IsDynamicGroup = 1 ) begin  raiserror( '#LDS#Cannot add {0} because assignments for dynamic groups are not permitted.|BaseTreeHasLDAPGroup|'
11, 18, 2) with nowait end   declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, 'LDP-K-OrgHasLDAPGroup'
12, @GenProcID from ( select distinct d.uid_org as uid from inserted d  where d.XOrigin & @QBM_BitPatternXOrigin_Inherit_inv > 0  ) as x exec QBM_PDBQueueInsert_Bulk
13 'QER-K-AllChildrenOfOrg', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid
14) select x.uid, null, @GenProcID from ( select distinct b.uid_org as uid from inserted d join BaseTree b on d.uid_org = b.uid_org where b.ITShopInfo = 
15'BO' and d.XIsInEffect = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-OrgAutoChild', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert
16 into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct uid_org as uid from inserted where XIsInEffect
17 = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-BaseTreeHasObject', @DBQueueElements_03  declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04
18 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct LDAP.uid_LDAPaccount as uid from inserted i join (select pio.uid_person
19, pio.uid_org from personinBaseTree pio where pio.XOrigin > 0 union all select uid_person, uid_org from helperPersonOrg ) hpo on i.uid_org = hpo.uid_org
20 join LDAPaccount LDAP on LDAP.uid_person = hpo.uid_person and LDAP.isgroupaccount = 1 where i.XIsInEffect = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-LDAPAccountInLDAPGroup'
21, @DBQueueElements_04  declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID
22 from ( select m.uid_LDPMachine as uid from inserted i join (select pio.uid_WorkDesk, pio.uid_org from WorkDeskinBaseTree pio where pio.XOrigin > 0 union
23 all select uid_WorkDesk, uid_org from helperWorkDeskOrg ) hwo on hwo.uid_org = i.uid_org join Hardware LDAP on LDAP.uid_WorkDesk = hwo.uid_WorkDesk join
24 LDPMachine m on LDAP.uid_Hardware = m.uid_Hardware where '1' = dbo.QBM_FGIConfigparmValue('TargetSystem\LDAP\HardwareInGroupFromOrg') and i.XIsInEffect
25 = 1 union  select m.uid_LDPMachine from inserted i join (select pio.uid_Hardware, pio.uid_org from HardwareinBaseTree pio where pio.XOrigin > 0 union 
26all select uid_Hardware, uid_org from helperHardwareOrg ) hwo on hwo.uid_org = i.uid_org join Hardware LDAP on LDAP.uid_Hardware = hwo.uid_Hardware join
27 LDPMachine m on LDAP.uid_Hardware = m.uid_Hardware where '1' = dbo.QBM_FGIConfigparmValue('TargetSystem\LDAP\HardwareInGroupFromOrg') and i.XIsInEffect
28 = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'LDP-K-LDPMachineInLDAPGroup', @DBQueueElements_05 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR
29 ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
30