Back to OIM Explorer

BaseTreeHasADSGroup

Generated table/view profile from relation entities, typed edges, trigger evidence, source references, and object-layer metadata.

56relations
74typed edges
7triggers
54queue edges
0method edges
0event edges

Typed Edges

TypeSourceTargetEvidence
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupQER_ZAllChildrenOfOrg at line 11Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupQER_ZITShopProductNodeCheck at line 11Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZAccountInADSGroup at line 11Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZContactInADSGroup at line 11Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZBaseTreeHasObject at line 11Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 11Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupQER_ZITShopProductNodeCheck at line 14Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZAccountInADSGroup at line 14Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZContactInADSGroup at line 14Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZBaseTreeHasObject at line 14Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 14Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZAccountInADSGroup at line 17Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZContactInADSGroup at line 17Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZBaseTreeHasObject at line 17Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 17Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZContactInADSGroup at line 21Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZBaseTreeHasObject at line 21Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 21Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZBaseTreeHasObject at line 23Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 23Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 30Sandbox DB
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroup on BaseTreeHasADSGroupQER-K-AllChildrenOfOrg -> QER_ZAllChildrenOfOrgWorkspace Evidence
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroup on BaseTreeHasADSGroupQER-K-OrgAutoChild -> QER_ZITShopProductNodeCheckWorkspace Evidence
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroup on BaseTreeHasADSGroupADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroupWorkspace Evidence
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroup on BaseTreeHasADSGroupADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroupWorkspace Evidence
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroup on BaseTreeHasADSGroupADS-K-BaseTreeHasObject -> ADS_ZBaseTreeHasObjectWorkspace Evidence
queues DBQueue taskdbo.ADS_TIBaseTreeHasADSGroup on BaseTreeHasADSGroupADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroupWorkspace Evidence
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZBaseTreeHasObject at line 6Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupQER_ZAllChildrenOfOrg at line 6Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupQER_ZITShopProductNodeCheck at line 6Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZAccountInADSGroup at line 6Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZContactInADSGroup at line 6Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 6Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupQER_ZAllChildrenOfOrg at line 9Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupQER_ZITShopProductNodeCheck at line 9Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZAccountInADSGroup at line 9Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZContactInADSGroup at line 9Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 9Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupQER_ZITShopProductNodeCheck at line 12Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZAccountInADSGroup at line 12Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZContactInADSGroup at line 12Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 12Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZAccountInADSGroup at line 16Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZContactInADSGroup at line 16Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 16Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZContactInADSGroup at line 20Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 20Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroupADS_ZADSMachineInADSGroup at line 28Sandbox DB
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroup on BaseTreeHasADSGroupADS-K-BaseTreeHasObject -> ADS_ZBaseTreeHasObjectWorkspace Evidence
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroup on BaseTreeHasADSGroupQER-K-AllChildrenOfOrg -> QER_ZAllChildrenOfOrgWorkspace Evidence
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroup on BaseTreeHasADSGroupQER-K-OrgAutoChild -> QER_ZITShopProductNodeCheckWorkspace Evidence
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroup on BaseTreeHasADSGroupADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroupWorkspace Evidence
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroup on BaseTreeHasADSGroupADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroupWorkspace Evidence
queues DBQueue taskdbo.ADS_TUBaseTreeHasADSGroup on BaseTreeHasADSGroupADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroupWorkspace Evidence
references sourcedbo.ADS_TIBaseTreeHasADSGroupdbo.QBM_FGIBitPatternXOriginSandbox DB
references sourcedbo.ADS_TIBaseTreeHasADSGroupdbo.QBM_FGIConfigparmValueSandbox DB
references sourcedbo.ADS_TIBaseTreeHasADSGroupdbo.QBM_FGISessionContextSandbox DB
references sourcedbo.ADS_TIBaseTreeHasADSGroupdbo.QER_FGIITShopFlagCombineValidSandbox DB
references sourcedbo.ADS_TIBaseTreeHasADSGroupdbo.QBM_PDBQueueInsert_BulkSandbox DB
references sourcedbo.ADS_TIBaseTreeHasADSGroupdbo.QBM_PSessionErrorAddSandbox DB
references sourcedbo.ADS_TIBaseTreeHasADSGroupdbo.QER_PAssignmentCheckValidSandbox DB
references sourcedbo.ADS_TUBaseTreeHasADSGroupdbo.QBM_FGIConfigparmValueSandbox DB
references sourcedbo.ADS_TUBaseTreeHasADSGroupdbo.QBM_FGISessionContextSandbox DB
references sourcedbo.ADS_TUBaseTreeHasADSGroupdbo.QBM_FGIXOriginChanged_EffectSandbox DB
references sourcedbo.ADS_TUBaseTreeHasADSGroupdbo.QER_FCVXOriginToInheritInfoSandbox DB
references sourcedbo.ADS_TUBaseTreeHasADSGroupdbo.QBM_PDBQueueInsert_BulkSandbox DB
references sourcedbo.ADS_TUBaseTreeHasADSGroupdbo.QBM_PSessionErrorAddSandbox DB
trigger on tableBaseTreeHasADSGroupads_tibasetreehasadsgroupWorkspace Evidence
trigger on tableBaseTreeHasADSGroupads_tubasetreehasadsgroupWorkspace Evidence
trigger on tableBaseTreeHasADSGroupgen_t515b87b621ffe0ad5bf63943dWorkspace Evidence
trigger on tabledbo.ADS_TIBaseTreeHasADSGroupBaseTreeHasADSGroupSandbox DB
trigger on tabledbo.ADS_TUBaseTreeHasADSGroupBaseTreeHasADSGroupSandbox DB
trigger on tableSQL_TRIGGERads_tibasetreehasadsgroupSandbox DB
trigger on tableSQL_TRIGGERads_tubasetreehasadsgroupSandbox DB

Related Evidence

Database TriggerSandbox DB
dbo.ADS_TIBaseTreeHasADSGroup

Database Trigger on BaseTreeHasADSGroup. Bulk DBQueue insert -> QER-K-AllChildrenOfOrg / QER_ZAllChildrenOfOrg at line 11; Bulk DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 11; Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 11; Bulk DBQueue insert -> ADS-K-ADSContactInADSGroup / ADS_ZContactInADSGroup at line 11

Open source
Database TriggerSandbox DB
dbo.ADS_TUBaseTreeHasADSGroup

Database Trigger on BaseTreeHasADSGroup. Bulk DBQueue insert -> ADS-K-BaseTreeHasObject / ADS_ZBaseTreeHasObject at line 6; Bulk DBQueue insert -> QER-K-AllChildrenOfOrg / QER_ZAllChildrenOfOrg at line 6; Bulk DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 6; Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 6

Open source
Database TriggerWorkspace Evidence
ADS_TIBaseTreeHasADSGroup

References: QBM_PDBQueueInsert_Bulk.

Open source
Database TriggerWorkspace Evidence
ADS_TUBaseTreeHasADSGroup

References: QBM_PDBQueueInsert_Bulk.

Open source
Table FunctionSandbox DB
dbo.ARS_FTITShopRulerPA

Table Function.

Open source
Database TriggerWorkspace Evidence
GEN_T515B87B621FFE0AD5BF63943D

References: QBM_PJobCreate.

DBQueue InsertWorkspace Evidence
ADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup' , @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct ADS…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup' , @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct ADS…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup' , @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct ADS…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ADS.UID_ADSCo…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ADS.UID_ADSCo…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ADS.UID_ADSCo…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSAccountInADSGroup -> ADS_ZAccountInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSAccountInADSGroup', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ADS.UID_ADSCo…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct i.ui…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct i.ui…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct i.ui…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_04 declare @DBQueueElements_05 QBM_YDBQueueRaw insert into @DBQueueElements_05 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct i.ui…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_05 if '1' = dbo.QBM_FGIConfigparmValue('TargetSystem\ADS\HardwareInGroupFromOrg' ) begin declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (ob…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_05 if '1' = dbo.QBM_FGIConfigparmValue('TargetSystem\ADS\HardwareInGroupFromOrg' ) begin declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (ob…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_05 if '1' = dbo.QBM_FGIConfigparmValue('TargetSystem\ADS\HardwareInGroupFromOrg' ) begin declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (ob…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_05 if '1' = dbo.QBM_FGIConfigparmValue('TargetSystem\ADS\HardwareInGroupFromOrg' ) begin declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (ob…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSContactInADSGroup -> ADS_ZContactInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSContactInADSGroup', @DBQueueElements_05 if '1' = dbo.QBM_FGIConfigparmValue('TargetSystem\ADS\HardwareInGroupFromOrg' ) begin declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (ob…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-ADSMachineInADSGroup -> ADS_ZADSMachineInADSGroup

QBM_PDBQueueInsert_Bulk 'ADS-K-ADSMachineInADSGroup', @DBQueueElements_06 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

Open source
DBQueue InsertWorkspace Evidence
ADS-K-BaseTreeHasObject -> ADS_ZBaseTreeHasObject

QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeHasObject', @DBQueueElements_05 declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select m.uid_ADSMachine…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-BaseTreeHasObject -> ADS_ZBaseTreeHasObject

QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeHasObject', @DBQueueElements_05 declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select m.uid_ADSMachine…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-BaseTreeHasObject -> ADS_ZBaseTreeHasObject

QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeHasObject', @DBQueueElements_05 declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select m.uid_ADSMachine…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-BaseTreeHasObject -> ADS_ZBaseTreeHasObject

QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeHasObject', @DBQueueElements_05 declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select m.uid_ADSMachine…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-BaseTreeHasObject -> ADS_ZBaseTreeHasObject

QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeHasObject', @DBQueueElements_05 declare @DBQueueElements_06 QBM_YDBQueueRaw insert into @DBQueueElements_06 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select m.uid_ADSMachine…

Open source
DBQueue InsertWorkspace Evidence
ADS-K-BaseTreeHasObject -> ADS_ZBaseTreeHasObject

QBM_PDBQueueInsert_Bulk 'ADS-K-BaseTreeHasObject', @DBQueueElements_01 insert into @ChangedOrg (UID_SingleGuid) select distinct d.UID_Org as uid from BaseTreeHasADSGroup a join deleted d on a.XObjectKey = d.XObjectKey where dbo.QBM_FGIXOri…

Open source
DBQueue InsertWorkspace Evidence
QER-K-AllChildrenOfOrg -> QER_ZAllChildrenOfOrg

QBM_PDBQueueInsert_Bulk 'QER-K-AllChildrenOfOrg' , @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct b.uid_o…

Open source
DBQueue InsertWorkspace Evidence
QER-K-AllChildrenOfOrg -> QER_ZAllChildrenOfOrg

QBM_PDBQueueInsert_Bulk 'QER-K-AllChildrenOfOrg', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid ) select x.uid, null, @GenProcID from ( select b.UID_Org as uid…

Open source
DBQueue InsertWorkspace Evidence
QER-K-AllChildrenOfOrg -> QER_ZAllChildrenOfOrg

QBM_PDBQueueInsert_Bulk 'QER-K-AllChildrenOfOrg', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid ) select x.uid, null, @GenProcID from ( select b.UID_Org as uid…

Open source
DBQueue InsertWorkspace Evidence
QER-K-ITSHOPOrder-ABORT -> QER_ZITShopOrderAbort

QBM_PDBQueueInsert_Bulk 'QER-K-ITSHOPOrder-ABORT', @DBQueueElements update BaseTreeHasADSGroup Set XOrigin = 0 , XDateUpdated = @Xdate , XUserUpdated = @XUser from BaseTreeHasADSGroup,deleted

DBQueue InsertWorkspace Evidence
QER-K-ITSHOPOrder-ABORT -> QER_ZITShopOrderAbort

QBM_PDBQueueInsert_Bulk 'QER-K-ITSHOPOrder-ABORT', @DBQueueElements update BaseTreeHasADSGroup Set XOrigin = 0 , XDateUpdated = @Xdate , XUserUpdated = @XUser from BaseTreeHasADSGroup,deleted where deleted.UID_ADSGroup = BaseTreeHasADSGrou…

DBQueue InsertWorkspace Evidence
QER-K-ITSHOPOrder-ABORT -> QER_ZITShopOrderAbort

QBM_PDBQueueInsert_Bulk 'QER-K-ITSHOPOrder-ABORT', @DBQueueElements update BaseTreeHasADSGroup Set XOrigin = 0 , XDateUpdated = @Xdate , XUserUpdated = @XUser from BaseTreeHasADSGroup,deleted

DBQueue InsertWorkspace Evidence
QER-K-ITSHOPOrder-ABORT -> QER_ZITShopOrderAbort

QBM_PDBQueueInsert_Bulk 'QER-K-ITSHOPOrder-ABORT', @DBQueueElements update BaseTreeHasADSGroup Set XOrigin = 0 , XDateUpdated = @Xdate , XUserUpdated = @XUser from BaseTreeHasADSGroup,deleted where deleted.UID_Org = BaseTreeHasADSGroup.UID…

DBQueue InsertWorkspace Evidence
QER-K-OrgAutoChild -> QER_ZITShopProductNodeCheck

QBM_PDBQueueInsert_Bulk 'QER-K-OrgAutoChild', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object , subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct ADS.uid_ADS…

Open source
DBQueue InsertWorkspace Evidence
QER-K-OrgAutoChild -> QER_ZITShopProductNodeCheck

QBM_PDBQueueInsert_Bulk 'QER-K-OrgAutoChild', @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object , subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct ADS.uid_ADS…

Open source
DBQueue InsertWorkspace Evidence
QER-K-OrgAutoChild -> QER_ZITShopProductNodeCheck

QBM_PDBQueueInsert_Bulk 'QER-K-OrgAutoChild', @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ADS.UID_ADSAccount as…

Open source
DBQueue InsertWorkspace Evidence
QER-K-OrgAutoChild -> QER_ZITShopProductNodeCheck

QBM_PDBQueueInsert_Bulk 'QER-K-OrgAutoChild', @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ADS.UID_ADSAccount as…

Open source
DBQueue InsertWorkspace Evidence
QER-K-OrgAutoChild -> QER_ZITShopProductNodeCheck

QBM_PDBQueueInsert_Bulk 'QER-K-OrgAutoChild', @DBQueueElements_03 declare @DBQueueElements_04 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select ADS.UID_ADSAccount as…

Open source
Knowledge PageWorkspace Evidence
OIM KB Update — Run 2026-04-27 (27)

OIM KB Update — Run 2026 04 27 27 Goal Close a concrete troubleshooting gap: explain why ITShopOrgHasADSGroup / BaseTreeHasADSGroup often shows “double” rows per published AD group, and document the precise DB link semantics between: ADSGroup entitlement AccProduct service item BaseTree / ITShopOrg PR nodes BaseTreeHas

Knowledge PageWorkspace Evidence
OIM KB Update — Run 2026-04-27 (3)

OIM KB Update — Run 2026 04 27 3 Focus: IT Shop availability for AD groups and the DB backed enforcement mechanisms behind IsForITShop / IsITShopOnly . What changed in understanding new findings ADSGroup is “IT Shop enabled” as an element type BaseTreeAssign maps it to BaseTreeHasADSGroup , but in this sandbox: all 287

Knowledge PageSandbox DB
Sandbox DB evidence: BaseTreeHasADSGroup PR links + BaseTreeHasObject (ADSGroup)

BaseTreeHasADSGroup PR links + BaseTreeHasObject ADSGroup — Live sandbox evidence Environment: Host: im.sandbox.local Database: OIM OneIM Access: scripts/sandbox/Invoke SandboxSql.ps1 direct TCP 1433 , SELECT only Observed: 2026 04 27 1 BaseTreeHasObject schema key columns BaseTreeHasObject is the “generic” link table

Knowledge PageWorkspace Evidence
Sandbox host evidence: ADS BaseTreeHasADSGroup + BaseTreeHasObject shipped SQL

ADS BaseTreeHasADSGroup + BaseTreeHasObject shipped SQL — Sandbox host evidence Environment: Host: im.sandbox.local WinRM HTTP 5985 Paths inspected read only : C:\Dev\OneIdentityManager.10.0\Modules\ADS\database\MSSQL\050Triggers\ADS TBaseTreeHasADSGroup.sql C:\Dev\OneIdentityManager.10.0\Modules\ADS\database\MSSQL\040