Back to OIM Explorer

LDAPGroup Publication

Saved relation query: LDAPGroup AccProduct ITShopOrg OpenDJ

1Synced LDAPGroup
2Product metadata
3ITShopOrg shelf relation
4Assignment/order test path
5Provisioning verification

Related Evidence

Database TriggerSandbox DB
dbo.LDP_TULDAPGroup

Database Trigger on LDAPGroup. Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 60; References QBM_PJobCreate*; References QBM_PDBQueueInsert_Bulk; Trigger parent table: LDAPGroup

Open source
Stored ProcedureSandbox DB
dbo.QER_PITShopProductNodeCreate_b

Stored Procedure. References QBM_PJobCreate*

Open source
Object MethodWorkspace Evidence
LDAPGroup.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Database TriggerSandbox DB
dbo.ADS_TUAdsGroup

Database Trigger on ADSGroup. Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 81; Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 81; Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 81; Bulk DBQueue insert -> ADS-K-ADSAccountInADSGroup / ADS_ZAccountInADSGroup at line 81

Open source
Database TriggerSandbox DB
dbo.LDP_TATTULDAPGroup

Database Trigger on LDAPGroup. Trigger parent table: LDAPGroup

Open source
Database TriggerSandbox DB
dbo.QER_TUQERAssign

Database Trigger on QERAssign. Bulk DBQueue insert -> QER-K-PersonHasQERAssign / QER_ZPersonHasQERAssign at line 12; Bulk DBQueue insert -> QER-K-OrgHasQERAssign / QER_ZOrgHasQERAssign at line 12; Bulk DBQueue insert -> QER-K-PersonHasQERAssign / QER_ZPersonHasQERAssign at line 12; Bulk DBQueue insert -> QER-K-OrgHasQERAssign / QER_ZOrgHasQERAssign at line 16

Open source
Database TriggerSandbox DB
dbo.QER_TUQERResource

Database Trigger on QERResource. Bulk DBQueue insert -> QER-K-PersonHasQERResource / QER_ZPersonHasQERResource at line 16; Bulk DBQueue insert -> QER-K-PersonHasQERResource / QER_ZPersonHasQERResource at line 16; Bulk DBQueue insert -> QER-K-OrgHasQERResource / QER_ZOrgHasQERResource at line 16; Bulk DBQueue insert -> QER-K-PersonHasQERResource / QER_ZPersonHasQERResource at line 19

Open source
Database TriggerSandbox DB
dbo.QER_TUQERReuse

Database Trigger on QERReuse. Bulk DBQueue insert -> QER-K-PersonHasQERReuse / QER_ZPersonHasQERReuse at line 12; Bulk DBQueue insert -> QER-K-OrgHasQERReuse / QER_ZOrgHasQERReuse at line 12; Bulk DBQueue insert -> QER-K-PersonHasQERReuse / QER_ZPersonHasQERReuse at line 12; Bulk DBQueue insert -> QER-K-OrgHasQERReuse / QER_ZOrgHasQERReuse at line 16

Open source
Database TriggerSandbox DB
dbo.QER_TUQERReuseUS

Database Trigger on QERReuseUS. Bulk DBQueue insert -> QER-K-PersonHasQERReuseUS / QER_ZPersonHasQERReuseUS at line 13; Bulk DBQueue insert -> QER-K-OrgHasQERReuseUS / QER_ZOrgHasQERReuseUS at line 13; Bulk DBQueue insert -> QER-K-PersonHasQERReuseUS / QER_ZPersonHasQERReuseUS at line 13; Bulk DBQueue insert -> QER-K-OrgHasQERReuseUS / QER_ZOrgHasQERReuseUS at line 16

Open source
Database TriggerSandbox DB
dbo.RMS_TUESet

Database Trigger on ESet. Bulk DBQueue insert -> RMS-K-ESetCollection / RMS_ZESetCollection at line 32; Bulk DBQueue insert -> RMS-K-OrgHasESet / RMS_ZOrgHasESet at line 32; Bulk DBQueue insert -> RMS-K-PersonHasESet / RMS_ZPersonHasESet at line 32; Bulk DBQueue insert -> RMS-K-WorkdeskHasESet / RMS_ZWorkDeskHasESet at line 32

Open source
Database TriggerSandbox DB
dbo.RPS_TURPSReport

Database Trigger on RPSReport. Bulk DBQueue insert -> RPS-K-AllForOneRPSReport / RPS_ZAllForOneRPSReport at line 31; Bulk DBQueue insert -> RPS-K-PrepropRPSReport / RPS_ZPrePropRPSReport at line 31; Bulk DBQueue insert -> RPS-K-PrepropRPSReport / RPS_ZPrePropRPSReport at line 34; References QBM_PJobCreate*

Open source
Database TriggerSandbox DB
dbo.TSB_TUTSBAccountDef

Database Trigger on TSBAccountDef. Bulk DBQueue insert -> TSB-K-TSBAccountDefFlags / TSB_ZTSBAccountDefFlags at line 22; Bulk DBQueue insert -> TSB-K-PersonHasTSBAccountDef / TSB_ZPersonHasTSBAccountDef at line 22; Bulk DBQueue insert -> TSB-K-OrgHasTSBAccountDef / TSB_ZOrgHasTSBAccountDef at line 22; Bulk DBQueue insert -> TSB-K-PersonHasTSBAccountDef / TSB_ZPersonHasTSBAccountDef at line 25

Open source
Database TriggerSandbox DB
dbo.TSB_TUUNSGroupB

Database Trigger on UNSGroupB. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB / TSB_ZUNSAccountBInUNSGroupB at line 40; References QBM_PJobCreate*; References QBM_PDBQueueInsert_Bulk; Trigger parent table: UNSGroupB

Open source
Database TriggerSandbox DB
dbo.TSB_TUUNSGroupB1

Database Trigger on UNSGroupB1. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB1 / TSB_ZUNSAccountBInUNSGroupB1 at line 40; References QBM_PJobCreate*; References QBM_PDBQueueInsert_Bulk; Trigger parent table: UNSGroupB1

Open source
Database TriggerSandbox DB
dbo.TSB_TUUNSGroupB2

Database Trigger on UNSGroupB2. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB2 / TSB_ZUNSAccountBInUNSGroupB2 at line 40; References QBM_PJobCreate*; References QBM_PDBQueueInsert_Bulk; Trigger parent table: UNSGroupB2

Open source
Database TriggerSandbox DB
dbo.TSB_TUUNSGroupB3

Database Trigger on UNSGroupB3. Bulk DBQueue insert -> TSB-K-UNSAccountBInUNSGroupB3 / TSB_ZUNSAccountBInUNSGroupB3 at line 40; References QBM_PJobCreate*; References QBM_PDBQueueInsert_Bulk; Trigger parent table: UNSGroupB3

Open source
Scalar FunctionSandbox DB
dbo.QER_FGIPWOOrderPerson

Scalar Function.

Open source
Table FunctionSandbox DB
dbo.QER_FTPWOOrderPerson

Table Function.

Open source
Inline Table FunctionSandbox DB
dbo.QER_FTPWOOrderPerson_000

Inline Table Function.

Open source
Inline Table FunctionSandbox DB
dbo.QER_FTPWOOrderPerson_001

Inline Table Function.

Open source
Inline Table FunctionSandbox DB
dbo.QER_FTPWOOrderPerson_010

Inline Table Function.

Open source
Inline Table FunctionSandbox DB
dbo.QER_FTPWOOrderPerson_011

Inline Table Function.

Open source
Inline Table FunctionSandbox DB
dbo.QER_FTPWOOrderPerson_100

Inline Table Function.

Open source
Inline Table FunctionSandbox DB
dbo.QER_FTPWOOrderPerson_101

Inline Table Function.

Open source
Inline Table FunctionSandbox DB
dbo.QER_FTPWOOrderPerson_110

Inline Table Function.

Open source
Inline Table FunctionSandbox DB
dbo.QER_FTPWOOrderPerson_111

Inline Table Function.

Open source
API EndpointWorkspace Evidence
portal_shop_serviceitemimage_get

uidserviceitem: string accproduct, itshoporg

API EndpointWorkspace Evidence
portal_shop_serviceitems_datamodel_get

filter: FilterData[] accproduct, itshoporg

API EndpointWorkspace Evidence
portal_shop_serviceitems_dependencies_get

UID_Person: string, uid: string accproduct, itshoporg

API EndpointWorkspace Evidence
portal_shop_serviceitems_entitlements_get

UID_AccProduct: string, OrderBy: string, StartIndex: number, PageSize: number, filter: FilterData[], withProperties: string, search: string, ParentKey: string accproduct, itshoporg

API EndpointWorkspace Evidence
portal_shop_serviceitems_get

UID_Person: string, UID_AccProductGroup: string, IncludeChildCategories: boolean, UID_AccProductParent: string, UID_PersonReference: string, UID_PersonPeerGroup: string, OrderBy: string, StartIndex: number, PageSize: number, filter: FilterData[], withProperti... accproduct, itshoporg

API EndpointWorkspace Evidence
portal_shop_serviceitems_group_get

by: string, def: string, filter: FilterData[], StartIndex: number, PageSize: number, withcount: boolean accproduct, itshoporg

Knowledge PageWorkspace Evidence
LDAP Shop Seeding - Plan v0.1

LDAP Shop Seeding Plan v0.1 Goal Create a small fictional LDAP entitlement catalog in the sandbox OpenDJ directory so One Identity Manager can be used to test: LDAP group synchronization into LDAPGroup LDAP account to group assignments through LDAPAccountInLDAPGroup requestable LDAP group products in the IT Shop produc

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

OIM KB Update — Run 2026 04 27 12 What changed in sandbox? Sandbox DB: SELECT only no DML . Sandbox host: read only WinRM file inspection no changes . New sandbox DB evidence captured ITShopOrg required columns NOT NULL : Ident Org , UID ITShopOrg , UID OrgRoot , XObjectKey . AccProduct links to service categories via

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 24

OIM KB Update Run 24 Goal Clarify the sandbox specific “availability wiring” around AccProductInBaseTree / AccProductInITShopOrg , and record the concrete trigger/procedure hooks that fire when: ADSGroup IT Shop flags change, ADSGroup.UID AccProduct changes, AccProductGroup service category hierarchy/decision method ch

Knowledge PageSandbox DB
Sandbox DB Evidence — AccProductInBaseTree, views, and trigger hooks (2026-04-27)

Sandbox DB Evidence — AccProductInBaseTree, views, and trigger hooks 2026 04 27 Scope This note captures live sandbox DB evidence about: why some “availability” views can appear empty AccProductInITShopOrg , which views back common troubleshooting queries ITShopOrg , ITShopOrgHasADSGroup , which triggers/procs are dire

Knowledge PageSandbox DB
Sandbox DB Evidence — IT Shop entitlement link tables + flags (2026-04-27)

Sandbox DB Evidence — IT Shop entitlement link tables + flags 2026 04 27 Method Sandbox DB: OneIM on im.sandbox.local Tooling: scripts/sandbox/Invoke SandboxSql.ps1 SELECT only Evidence 1 ITShopOrg + ITShopOrgHas are views filtering to UID OrgRoot='QER V ITShopOrg' Query object types Result Name Type AccProductInITShop

SQL -> EventWorkspace Evidence
ITShopOrg.DeletePRNode

QBM_PJobCreate_HOFireEvent_L 'ITShopOrg', @EntriesToFire ,'DeletePRNode', @GenProcID , @CheckForExisting = 1 , @AdditionalObjectKeysAffected = DEFAULT select @RowCounterNodeCheck += 1 select @ElementIndex += 1 end select @SQLCmd = string_a…

Open source
Object MethodWorkspace Evidence
AccProduct.ITShop_ExpiredProduct

UI-visible method assignment. Behavior: n/a. Enabled for: 3. Decompiled registrations: 0.

Object MethodWorkspace Evidence
AccProductParamCategory.AccProductParamCategory.Copy

UI-visible method assignment. Behavior: n/a. Enabled for: 3. Decompiled registrations: 0.

Object MethodWorkspace Evidence
ADSGroup.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Stored ProcedureSandbox DB
dbo.LDP_RAccountInLDAPGroup

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.LDP_RGroupInLDAPGroup

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.LDP_RLDPMachineInLDAPGroup

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.LDP_ROrgHasLDAPGroup

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.LDP_ZAccountInLDAPGroup

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.LDP_ZAllForOneHardware

Stored Procedure. Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 3; References QBM_PDBQueueInsert_Bulk

Open source
Stored ProcedureSandbox DB
dbo.LDP_ZAllForOneWorkDesk

Stored Procedure. Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 4; References QBM_PDBQueueInsert_Bulk

Open source
Stored ProcedureSandbox DB
dbo.LDP_ZGroupInLDAPGroup

Stored Procedure. Single DBQueue insert -> LDP-K-LDAPGroupInLDAPGroup-Circ / LDP_ZGroupInLDAPGroup_Circ at line 23; References QBM_PDBQueueInsert_Single

Open source
Stored ProcedureSandbox DB
dbo.LDP_ZGroupInLDAPGroup_Circ

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.LDP_ZLDPMachineInLDAPGroup

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.LDP_ZOrgHasLDAPGroup

Stored Procedure. Bulk DBQueue insert -> LDP-K-BaseTreeHasObject / LDP_ZBaseTreeHasObject at line 21; References QBM_PDBQueueInsert_Bulk

Open source
Stored ProcedureSandbox DB
dbo.LDP_ZPersonHasLDAPGroup

Stored Procedure. Bulk DBQueue insert -> LDP-K-LDAPAccountInLDAPGroup / LDP_ZAccountInLDAPGroup at line 3; References QBM_PDBQueueInsert_Bulk

Open source
Stored ProcedureSandbox DB
dbo.LDP_ZWorkDeskInLDAPGroup

Stored Procedure. Bulk DBQueue insert -> LDP-K-LDPMachineInLDAPGroup / LDP_ZLDPMachineInLDAPGroup at line 4; References QBM_PDBQueueInsert_Bulk

Open source
Stored ProcedureSandbox DB
dbo.QER_PITShop_BoardMove

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.QER_PITShop_PRNodesMove

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.QER_PITShopOrderMove_bulk

Stored Procedure. HOCallMethod -> PersonWantsOrg.Abort at line 140; HOCallMethod -> PersonWantsOrg.Abort at line 140; HOCallMethod -> PersonWantsOrg.Abort at line 140; HOCallMethod -> PersonWantsOrg.MakeDecision at line 140

Open source
Stored ProcedureSandbox DB
dbo.QER_PITShopProductNodeCheck

Stored Procedure. HOFireEvent -> ITShopOrg.DeletePRNode at line 72; Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 72; Single DBQueue insert -> QER-K-OrgAutoChild / QER_ZITShopProductNodeCheck at line 96; References QBM_PJobCreate*

Open source
Stored ProcedureSandbox DB
dbo.QER_PITShopProductNodeMove

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.QER_RAccProductGroupCollection

Stored Procedure.

Open source
Stored ProcedureSandbox DB
dbo.QER_ZAccProductGroupCollection

Stored Procedure.

Open source
Object MethodWorkspace Evidence
ESet.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Object MethodWorkspace Evidence
ITShopOrg.CreateDynamicGroup_for_ITShopOrgCustomer

UI-visible method assignment. Behavior: 2. Enabled for: 3. Decompiled registrations: 0.

Object MethodWorkspace Evidence
ITShopOrg.ITShop_ChangeBoard

UI-visible method assignment. Behavior: 2. Enabled for: 3. Decompiled registrations: 0.

Object MethodWorkspace Evidence
ITShopOrg.ITShop_ChangeBoardMultiple

UI-visible method assignment. Behavior: 2. Enabled for: 3. Decompiled registrations: 0.

Object MethodWorkspace Evidence
ITShopOrg.ITShop_ChangeShop

UI-visible method assignment. Behavior: 2. Enabled for: 3. Decompiled registrations: 0.

Object MethodWorkspace Evidence
ITShopOrg.ITShop_ChangeShoppingCenter

UI-visible method assignment. Behavior: 2. Enabled for: 3. Decompiled registrations: 0.

Object MethodWorkspace Evidence
QERAssign.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Object MethodWorkspace Evidence
QERResource.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Object MethodWorkspace Evidence
QERReuse.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Object MethodWorkspace Evidence
QERReuseUS.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Object MethodWorkspace Evidence
RPSReport.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Object MethodWorkspace Evidence
UNSGroupB.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Object MethodWorkspace Evidence
UNSGroupB1.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Object MethodWorkspace Evidence
UNSGroupB2.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Object MethodWorkspace Evidence
UNSGroupB3.RemoveFromITShopBoards

UI-visible method assignment. Behavior: 5. Enabled for: 1. Decompiled registrations: 0.

Event CatalogWorkspace Evidence
AccProduct.TAKEOWNERSHIP

QBMEvent table/event pair. Display: TAKEOWNERSHIP - AccProduct. Decompiled generated events: 0. Event handlers: 0.

Event CatalogWorkspace Evidence
AccProduct.Update

QBMEvent table/event pair. Display: Update - AccProduct. Decompiled generated events: 0. Event handlers: 0.

Database TriggerSandbox DB
dbo.ADS_TATTUADSGroup

Database Trigger on ADSGroup. Trigger parent table: ADSGroup

Open source