DBQueue module routes

Per-module route profiles for source-derived SQL modules that call QBM_PDBQueueInsert*.

640modulesQBM_PDBQueueInsert* callers
46mixed routine modulesmultiple insert routines
46multi-family modulesmultiple task families
1,177task marker refssummed per module

dbo.QER_TUBaseTree 15 tasks

SQL_TRIGGER · score 252.619 · 2 insert routines · 2 families

QBM_PDBQueueInsert_Bulk QBM_PDBQueueInsert_Single

QER · 14 tasks QBM · 1 tasks

Tasks: QBM-K-CommonReCalculate, QER-K-AllForOneHardware, QER-K-AllForOnePerson, QER-K-AllForOneWorkdesk, QER-K-BaseTreeCollectionF, QER-K-HelperHeadOrg, QER-K-ITSHOPOrder-ABORT, QER-K-ITSHOPOrder-RESET

Config refs: QER\ITShop\OnWorkflowAssign

Reads: inserted, deleted, BaseTree, PersonWantsOrg, DynamicGroup, DialogGroup, BaseTreecollection, personinBaseTree

dbo.QER_PAfterMigrationTasks 13 tasks

SQL_STORED_PROCEDURE · score 155.764 · 2 insert routines · 2 families

QBM_PDBQueueInsert_Bulk QBM_PDBQueueInsert_Single

QER · 11 tasks QBM · 2 tasks

Tasks: QBM-K-CommonReCalculate, QBM-K-CommonRecalculate, QER-K-AccProductGroupCollection, QER-K-AllChildrenOfOrg, QER-K-AllForOneOrg, QER-K-BaseTreeCollectionF, QER-K-BaseTreeHasObject, QER-K-DynamicGroupMakeTrigger

Config refs: n/a

Reads: OrgRoot, BaseTree, BaseTreeHasPWODecisionMethod, AccProduct, accproduct, accproductgroup, AccProductGroupCollection, AccProductgroup

dbo.QBM_ZPrePropTable 9 tasks

SQL_STORED_PROCEDURE · score 203.719 · 2 insert routines · 1 families

QBM_PDBQueueInsert_Bulk QBM_PDBQueueInsert_WaitForComp

QBM · 9 tasks

Tasks: QBM-K-CommonMakeWatchtrigger, QBM-K-CommonPrepropColumn, QBM-K-CommonPrepropColumnFK, QBM-K-CommonPrepropJobChain, QBM-K-CommonPrepropObject, QBM-K-CommonPrepropTable, QBM-K-CommonPrepropTree, QBM-K-CommonPrepropTreeResult

Config refs: Common\MailNotification

Reads: QBMDBQueueCurrent, dialogtable, DialogTable, QBM_VQBMRelation, Dialogtable, DialogColumn, QBMTree, QBMTreeResult

dbo.QER_ZAllForPersonInBaseTree 8 tasks

SQL_STORED_PROCEDURE · score 216.715 · 2 insert routines · 2 families

QBM_PDBQueueInsert_Bulk QBM_PDBQueueInsert_Single

QER · 7 tasks QBM · 1 tasks

Tasks: QBM-K-Commonrecalculate, QER-K-AllForOnePerson, QER-K-HelperHeadOrg, QER-K-PersonCheckDynUser, QER-K-PersonHasObject, QER-K-ShoppingRackMemberDel, QER-K-ShoppingRackPWODecisionMaker, QER-K-ShoppingRackPWOHelperPWO

Config refs: Common\ProcessState\UseGenProcIDFromPWO

Reads: QBMDBQueueCurrent, PersonInBaseTree, BaseTree, DynamicGroup, QERDynamicGroupBlackList, QERWorkingStep, PWOHelperPWO, Delegation

dbo.QER_TUPerson 8 tasks

SQL_TRIGGER · score 198.058 · 2 insert routines · 2 families

QBM_PDBQueueInsert_Bulk QBM_PDBQueueInsert_Single

QER · 7 tasks QBM · 1 tasks

Tasks: QBM-K-CommonReCalculate, QER-K-AllForOnePerson, QER-K-DynamicGroupSingleBasic, QER-K-HelperHeadOrg, QER-K-HelperHeadPerson, QER-K-HelperPersonOrg, QER-K-PersonHasObject, QER-K-ShoppingRackPWOHelperPWO

Config refs: QER\ITSHop\AutoCloseInactivePerson

Reads: inserted, deleted, QER_VPersonsAreMe, QERUniversalSubstitute, PersonWantsOrg, Person, DynamicGroup, person

dbo.ADS_TIBaseTreeHasADSGroup 7 tasks

SQL_TRIGGER · score 123.865 · 1 insert routines · 2 families

QBM_PDBQueueInsert_Bulk

ADS · 5 tasks QER · 2 tasks

Tasks: ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSMachineInADSGroup, ADS-K-BaseTreeHasObject, ADS-K-OrgHasADSGroup, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild

Config refs: TargetSystem\ADS\HardwareInGroupFromOrg

Reads: inserted, BaseTree, ADSGroup, personinBaseTree, helperPersonOrg, ADSaccount, ADSContact, WorkDeskinBaseTree

dbo.ADS_TUBaseTreeHasADSGroup 7 tasks

SQL_TRIGGER · score 113.573 · 1 insert routines · 2 families

QBM_PDBQueueInsert_Bulk

ADS · 5 tasks QER · 2 tasks

Tasks: ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSMachineInADSGroup, ADS-K-BaseTreeHasObject, ADS-K-OrgHasADSGroup, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild

Config refs: TargetSystem\ADS\HardwareInGroupFromOrg

Reads: inserted, deleted, BaseTreeHasADSGroup, BaseTree, PersoninBaseTree, ADSaccount, HelperPersonOrg, ADSContact

dbo.RMS_TIBaseTreeHasESet 6 tasks

SQL_TRIGGER · score 118.553 · 1 insert routines · 2 families

QBM_PDBQueueInsert_Bulk

RMS · 4 tasks QER · 2 tasks

Tasks: QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, RMS-K-BaseTreeHasObject, RMS-K-OrgHasESet, RMS-K-PersonHasESet, RMS-K-WorkdeskHasESet

Config refs: n/a

Reads: inserted, BaseTree, ESet, personinBaseTree, helperPersonOrg, WorkDeskinBaseTree, helperWorkDeskOrg, ESetHasEntitlement

dbo.LDP_TIBaseTreeHasLDAPGroup 6 tasks

SQL_TRIGGER · score 114.553 · 1 insert routines · 2 families

QBM_PDBQueueInsert_Bulk

LDP · 4 tasks QER · 2 tasks

Tasks: LDP-K-BaseTreeHasObject, LDP-K-LDAPAccountInLDAPGroup, LDP-K-LDPMachineInLDAPGroup, LDP-K-OrgHasLDAPGroup, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild

Config refs: TargetSystem\LDAP\HardwareInGroupFromOrg

Reads: inserted, LDAPGroup, BaseTree, personinBaseTree, helperPersonOrg, LDAPaccount, WorkDeskinBaseTree, helperWorkDeskOrg

dbo.LDP_TUBaseTreeHasLDAPGroup 6 tasks

SQL_TRIGGER · score 103.954 · 1 insert routines · 2 families

QBM_PDBQueueInsert_Bulk

LDP · 4 tasks QER · 2 tasks

Tasks: LDP-K-BaseTreeHasObject, LDP-K-LDAPAccountInLDAPGroup, LDP-K-LDPMachineInLDAPGroup, LDP-K-OrgHasLDAPGroup, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild

Config refs: TargetSystem\LDAP\HardwareInGroupFromOrg

Reads: inserted, deleted, BaseTreeHasLDAPGroup, BaseTree, PersoninBaseTree, LDAPaccount, HelperPersonOrg, WorkDeskinBaseTree

dbo.QBM_PDBQueueInsert_Int 6 tasks

SQL_STORED_PROCEDURE · score 159.795 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Single

QBM · 6 tasks

Tasks: QBM-K-BaseMigrationReady, QBM-K-CommonReCalculate, QBM-K-CommonTaskStart, QBM-K-XDateSubItemUpdate, QBM-K-XDateSubItemUpdateFU, QBM-K-XMarkedForDeletionPush

Config refs: Common\ProcessState

Reads: QBMDBQueueTaskMetric, QBMDBQueueTask, DialogDBQueue, DialogTable

dbo.QBM_PTableReload 6 tasks

SQL_STORED_PROCEDURE · score 158.903 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Single

QBM · 6 tasks

Tasks: QBM-K-CommonMakeRITrigger, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonReCalculate, QBM-K-CommonRebuildView, QBM-K-MakeConstraint, QBM-K-SetRowLockOnly

Config refs: n/a

Reads: sys, QBM_VTablesReloadAble, QBM_VHeavyLoadTables, DialogDatabase, QBM_VStartupTables, QBM_FTSchemaDependencies

dbo.TSB_TUDPRNameSpace 6 tasks

SQL_TRIGGER · score 125.172 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 6 tasks

Tasks: TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3, TSB-K-UNSGroupBHasUNSItemB

Config refs: n/a

Reads: inserted, deleted, DPRNameSpace, UNSRootB, UNSAccountB, UNSGroupB, UNSAccountBInUNSGroupB, UNSAccountBHasUNSGroupB

dbo.QBM_ZBufferTProcessDelete 6 tasks

SQL_STORED_PROCEDURE · score 96.721 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Single

QBM · 6 tasks

Tasks: QBM-K-BufferTProcessDelete, QBM-K-BufferTProcessModule, QBM-K-BufferTProcessModulePU, QBM-K-BufferTProcessTable, QBM-K-BufferTProcessTablePU, QBM-K-FillModelFinished

Config refs: n/a

Reads: DialogDBQueue, QBMDBQueueCurrent

dbo.QER_PITShopHelperFill_bulk 5 tasks

SQL_STORED_PROCEDURE · score 340.779 · 1 insert routines · 2 families

QBM_PDBQueueInsert_Bulk

QER · 3 tasks CPL · 2 tasks

Tasks: CPL-K-ShoppingRackMakeDecisionOC, CPL-K-ShoppingRackMakeDecisionOH, QER-K-ShoppingRackCheckDecision, QER-K-ShoppingRackMakeDecisionEX, QER-K-ShoppingRackPWOHelperPWO

Config refs: Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\PersonOrderedNoDecide, QER\ITShop\PersonInsertedNoDecide, QER\ITShop\PersonInsertedNoDecideCompliance, QER\ITShop\PersonOrderedNoDecideCompliance

Reads: PersonWantsOrg, QERWorkingStep, PWOHelperPWO, HelperPWOCompliance, ComplianceRule, PWODecisionHistory, BaseTree, PersonInBaseTree

dbo.RMS_TUBaseTreeHasESet 5 tasks

SQL_TRIGGER · score 107.535 · 1 insert routines · 2 families

QBM_PDBQueueInsert_Bulk

RMS · 4 tasks QER · 1 tasks

Tasks: QER-K-OrgAutoChild, RMS-K-BaseTreeHasObject, RMS-K-OrgHasESet, RMS-K-PersonHasESet, RMS-K-WorkdeskHasESet

Config refs: n/a

Reads: inserted, deleted, BaseTreeHasESet, BaseTreecollection, BaseTree, PersoninBaseTree, HelperPersonOrg, WorkDeskinBaseTree

dbo.RMS_ZESetCollection 5 tasks

SQL_STORED_PROCEDURE · score 157.123 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

RMS · 5 tasks

Tasks: RMS-K-ESetCollection, RMS-K-ESetHasEntitlement, RMS-K-OrgHasESet, RMS-K-PersonHasESet, RMS-K-WorkdeskHasESet

Config refs: n/a

Reads: QBMDBQueueCurrent, ESetCollection, ESet, ESetHasEntitlement, BaseTreeHasESet, BaseTreecollection, PersonHasESet, WorkDeskHasESet

dbo.QBM_PWorkSchedule 5 tasks

SQL_STORED_PROCEDURE · score 122.734 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Single

QBM · 5 tasks

Tasks: QBM-K-Commonrecalculate, QBM-K-DeferredOperationExecute, QBM-K-GUIDReplaceReady, QBM-K-TableReload, QBM-K-TableReplace

Config refs: n/a

Reads: sys, DialogDatabase, QBMDBQueueCurrent, QBMGuidReplace, DialogDBQueue, dialogdeferredoperation

dbo.QBM_TUDialogColumn 5 tasks

SQL_TRIGGER · score 114.725 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QBM · 5 tasks

Tasks: QBM-K-CommonPrepropColumn, QBM-K-CommonPrepropTable, QBM-K-IndexCreateGenerated, QBM-K-MissingDisplayRightFill, QBM-K-SplittedLookupFill

Config refs: n/a

Reads: inserted, deleted, dialogColumn, dialogtable, dialogcolumn, DialogTable, information_schema, DialogColumn

dbo.QER_TIBaseTree 5 tasks

SQL_TRIGGER · score 108.632 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 5 tasks

Tasks: QER-K-AllForOneOrg, QER-K-BaseTreeCollectionF, QER-K-HelperHeadOrg, QER-K-OrgInherite, QER-K-OrgTreeLEVEL

Config refs: n/a

Reads: inserted, DialogGroup, BaseTreeCollectionF, BaseTree, OrgRoot, BaseTreeCollection, BaseTreecollection, Inserted

dbo.TSB_TUUNSAccountB 5 tasks

SQL_TRIGGER · score 85.865 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 5 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3

Config refs: n/a

Reads: inserted, deleted, UNSAccountB, UNSRootB

dbo.QER_TIBaseTreeHasQERResource 5 tasks

SQL_TRIGGER · score 85.8 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 5 tasks

Tasks: QER-K-AllChildrenOfOrg, QER-K-BaseTreeHasObject, QER-K-OrgAutoChild, QER-K-OrgHasQERResource, QER-K-PersonHasQERResource

Config refs: n/a

Reads: inserted, BaseTree, QERResource, personinBaseTree, helperPersonOrg

dbo.QER_TIBaseTreeHasQERReuseUS 5 tasks

SQL_TRIGGER · score 85.792 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 5 tasks

Tasks: QER-K-AllChildrenOfOrg, QER-K-BaseTreeHasObject, QER-K-OrgAutoChild, QER-K-OrgHasQERReuseUS, QER-K-PersonHasQERReuseUS

Config refs: n/a

Reads: inserted, BaseTree, QERReuseUS, personinBaseTree, helperPersonOrg

dbo.QER_TIBaseTreeHasQERAssign 5 tasks

SQL_TRIGGER · score 85.784 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 5 tasks

Tasks: QER-K-AllChildrenOfOrg, QER-K-BaseTreeHasObject, QER-K-OrgAutoChild, QER-K-OrgHasQERAssign, QER-K-PersonHasQERAssign

Config refs: n/a

Reads: inserted, BaseTree, QERAssign, personinBaseTree, helperPersonOrg

dbo.QER_TIBaseTreeHasQERReuse 5 tasks

SQL_TRIGGER · score 85.776 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 5 tasks

Tasks: QER-K-AllChildrenOfOrg, QER-K-BaseTreeHasObject, QER-K-OrgAutoChild, QER-K-OrgHasQERReuse, QER-K-PersonHasQERReuse

Config refs: n/a

Reads: inserted, BaseTree, QERReuse, personinBaseTree, helperPersonOrg

dbo.QER_TUBaseTreeHasQERReuseUS 5 tasks

SQL_TRIGGER · score 79.651 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 5 tasks

Tasks: QER-K-AllChildrenOfOrg, QER-K-BaseTreeHasObject, QER-K-OrgAutoChild, QER-K-OrgHasQERReuseUS, QER-K-PersonHasQERReuseUS

Config refs: n/a

Reads: inserted, deleted, BaseTreeHasQERReuseUS, BaseTree, PersoninBaseTree, HelperPersonOrg

dbo.QER_TUBaseTreeHasQERResource 5 tasks

SQL_TRIGGER · score 77.222 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 5 tasks

Tasks: QER-K-AllChildrenOfOrg, QER-K-BaseTreeHasObject, QER-K-OrgAutoChild, QER-K-OrgHasQERResource, QER-K-PersonHasQERResource

Config refs: n/a

Reads: inserted, deleted, BaseTreeHasQERResource, BaseTree, PersoninBaseTree, HelperPersonOrg

dbo.QER_TUBaseTreeHasQERAssign 5 tasks

SQL_TRIGGER · score 77.211 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 5 tasks

Tasks: QER-K-AllChildrenOfOrg, QER-K-BaseTreeHasObject, QER-K-OrgAutoChild, QER-K-OrgHasQERAssign, QER-K-PersonHasQERAssign

Config refs: n/a

Reads: deleted, inserted, BaseTreeHasQERAssign, BaseTree, PersoninBaseTree, HelperPersonOrg

dbo.QER_TUBaseTreeHasQERReuse 5 tasks

SQL_TRIGGER · score 77.203 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 5 tasks

Tasks: QER-K-AllChildrenOfOrg, QER-K-BaseTreeHasObject, QER-K-OrgAutoChild, QER-K-OrgHasQERReuse, QER-K-PersonHasQERReuse

Config refs: n/a

Reads: inserted, deleted, BaseTreeHasQERReuse, BaseTree, PersoninBaseTree, HelperPersonOrg

dbo.TSB_TIUNSAccountB 5 tasks

SQL_TRIGGER · score 67.238 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 5 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3

Config refs: n/a

Reads: inserted, UNSRootB

dbo.QER_TUPersonWantsOrg 4 tasks

SQL_TRIGGER · score 252.836 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 4 tasks

Tasks: QER-K-ITShopRepairClosed, QER-K-ShoppingRackCheckDecision, QER-K-ShoppingRackCheckWaiting, QER-K-ShoppingRackPWOHelperPWO

Config refs: Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\DecisionOnInsert

Reads: inserted, deleted, PersonWantsOrg, QER_VPWOOrderState, personwantsorg, pwohelperpwo, PWOHelperPWO, QER_VPWOPersonPropertyReset

dbo.RMS_TUESet 4 tasks

SQL_TRIGGER · score 155.504 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

RMS · 4 tasks

Tasks: RMS-K-ESetCollection, RMS-K-OrgHasESet, RMS-K-PersonHasESet, RMS-K-WorkdeskHasESet

Config refs: n/a

Reads: QER_VPWOProductNodesSlim, inserted, deleted, ESetHasEntitlement, ESet, DialogValidDynamicRef, DialogTable, DialogColumn

dbo.ATT_TUAttestationCase 4 tasks

SQL_TRIGGER · score 107.815 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

ATT · 4 tasks

Tasks: ATT-K-AttestationCheckValid, ATT-K-AttestationHelper, ATT-K-AttestationHelperNewLevel, ATT-K-AttestationReminder

Config refs: n/a

Reads: inserted, deleted, AttestationCase, AttestationHelper, Attestationcase

dbo.QBM_ZPreProptableFK 4 tasks

SQL_STORED_PROCEDURE · score 107.421 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QBM · 4 tasks

Tasks: QBM-K-CommonPrepropColumn, QBM-K-CommonPrepropColumnFK, QBM-K-CommonPrepropObject, QBM-K-CommonPrepropTableFK

Config refs: n/a

Reads: QBMDBQueueCurrent, dialogTable, dialogcolumn, DialogTable, dialogtable, DialogColumn, QBMRelation, DialogObject

dbo.QER_TDBaseTree 4 tasks

SQL_TRIGGER · score 102.803 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 4 tasks

Tasks: QER-K-HelperHeadOrg, QER-K-ITSHOPOrder-ABORT, QER-K-OrgInherite, QER-K-OrgTreeLEVEL

Config refs: n/a

Reads: deleted, QERAssign, PersonWantsOrg, BaseTree, PersonInBaseTree, QERUniversalSubstitute

dbo.QBM_ZConstraintEnable 4 tasks

SQL_STORED_PROCEDURE · score 101.861 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Single

QBM · 4 tasks

Tasks: QBM-K-QBMConstraintDisable, QBM-K-QBMConstraintDisable2, QBM-K-QBMConstraintEnable, QBM-K-QBMConstraintEnable2

Config refs: n/a

Reads: QBMDBQueueCurrent, DialogDBQueue, sys

dbo.CPL_TUComplianceRule 4 tasks

SQL_TRIGGER · score 101.7 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

CPL · 4 tasks

Tasks: CPL-K-ComplianceCheckForRule, CPL-K-ComplianceCheckMakeProc, CPL-K-ComplianceSubRuleFillObject, CPL-K-ComplianceSubRuleFillPerson

Config refs: n/a

Reads: inserted, deleted, ComplianceSubrule, ComplianceRule, PersonInBaseTree

dbo.TSB_TUTSBSpecificGroupBehavior 4 tasks

SQL_TRIGGER · score 100.188 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 4 tasks

Tasks: TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3

Config refs: n/a

Reads: inserted, deleted, TSBSpecificGroupBehavior, UNSGroupB, UNSAccountBInUNSGroupB, UNSAccountBHasUNSGroupB, UNSGroupB1, UNSAccountBInUNSGroupB1

dbo.TSB_TITSBSpecificGroupBehavior 4 tasks

SQL_TRIGGER · score 93.274 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 4 tasks

Tasks: TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3

Config refs: n/a

Reads: inserted, UNSGroupB, UNSAccountBInUNSGroupB, UNSAccountBHasUNSGroupB, UNSGroupB1, UNSAccountBInUNSGroupB1, UNSAccountBHasUNSGroupB1, UNSGroupB2

dbo.TSB_TDTSBSpecificGroupBehavior 4 tasks

SQL_TRIGGER · score 93.272 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 4 tasks

Tasks: TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3

Config refs: n/a

Reads: deleted, UNSGroupB, UNSAccountBInUNSGroupB, UNSAccountBHasUNSGroupB, UNSGroupB1, UNSAccountBInUNSGroupB1, UNSAccountBHasUNSGroupB1, UNSGroupB2

dbo.QER_TIPerson 4 tasks

SQL_TRIGGER · score 91.832 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 4 tasks

Tasks: QER-K-AllForOnePerson, QER-K-HelperHeadPerson, QER-K-HelperPersonOrg, QER-K-PersonHasObject

Config refs: n/a

Reads: inserted, QERUniversalSubstitute, Person, HelperHeadPerson

dbo.ADS_TIADSGroupExclusion 4 tasks

SQL_TRIGGER · score 91.411 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

ADS · 4 tasks

Tasks: ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSMachineInADSGroup, ADS-K-OrgHasADSGroup

Config refs: QER\Structures\Inherite\GroupExclusion

Reads: inserted, ADSGroup, ADSGroupCollection, ADSAccountInADSGroup, ADSContactInADSGroup, ADSMachineInADSGroup, BaseTreeHasADSGroup

dbo.RMS_TIESetExcludesESet 4 tasks

SQL_TRIGGER · score 88.831 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

RMS · 4 tasks

Tasks: RMS-K-ESetHasEntitlement, RMS-K-OrgHasESet, RMS-K-PersonHasESet, RMS-K-WorkdeskHasESet

Config refs: QER\Structures\Inherite\ESetExclusion

Reads: inserted, PersonHasEset, BaseTreeHasEset, WorkDeskHasESet, ESetHasEntitlement, Eset

dbo.QBM_TIDialogColumn 4 tasks

SQL_TRIGGER · score 83.884 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QBM · 4 tasks

Tasks: QBM-K-CommonPrepropColumn, QBM-K-IndexCreateGenerated, QBM-K-MissingDisplayRightFill, QBM-K-SplittedLookupFill

Config refs: n/a

Reads: inserted, dialogcolumn, DialogTable, information_schema, QBM_VQBMRelationALL

dbo.QBM_ZGroupNumber 4 tasks

SQL_STORED_PROCEDURE · score 72.23 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Single

QBM · 4 tasks

Tasks: QBM-K-CommonGroupCollection, QBM-K-CommonGroupPattern, QBM-K-CommonPrepropGroup, QBM-K-CommonReCalculate

Config refs: n/a

Reads: DialogGroup, dialoggroup, dialogGroup

dbo.TSB_TUTSBBehavior 4 tasks

SQL_TRIGGER · score 68.927 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 4 tasks

Tasks: TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3

Config refs: n/a

Reads: inserted, deleted, TSBBehavior, UNSAccountB, UNSRootB

dbo.ADS_TDADSGroupExclusion 4 tasks

SQL_TRIGGER · score 68.473 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

ADS · 4 tasks

Tasks: ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSMachineInADSGroup, ADS-K-OrgHasADSGroup

Config refs: n/a

Reads: deleted, ADSGroupCollection, ADSAccountInADSGroup, ADSContactInADSGroup, ADSMachineInADSGroup, BaseTreeHasADSGroup

dbo.RMS_TDESetExcludesESet 4 tasks

SQL_TRIGGER · score 68.316 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

RMS · 4 tasks

Tasks: RMS-K-ESetHasEntitlement, RMS-K-OrgHasESet, RMS-K-PersonHasESet, RMS-K-WorkdeskHasESet

Config refs: n/a

Reads: deleted, PersonHasEset, BaseTreeHasEset, WorkDeskHasESet, ESetHasEntitlement, Eset

dbo.QBM_ZViewBuildAll 4 tasks

SQL_STORED_PROCEDURE · score 57.122 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QBM · 4 tasks

Tasks: QBM-K-CommonRebuildViewP, QBM-K-CommonRebuildViewR, QBM-K-CommonRebuildViewU, QBM-K-CommonRebuildViewV

Config refs: n/a

Reads: QBMDBQueueCurrent, DialogTable

dbo.QER_TUOrgRootAssign 3 tasks

SQL_TRIGGER · score 122.345 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 3 tasks

Tasks: QER-K-AllForOneHardware, QER-K-AllForOnePerson, QER-K-AllForOneWorkdesk

Config refs: n/a

Reads: inserted, deleted, OrgRootAssign, BaseTreeAssign, DialogTable, BaseTree, DynamicGroup, personinBaseTree

dbo.TSB_TUTSBAccountDef 3 tasks

SQL_TRIGGER · score 121.322 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-OrgHasTSBAccountDef, TSB-K-PersonHasTSBAccountDef, TSB-K-TSBAccountDefFlags

Config refs: n/a

Reads: QER_VPWOProductNodesSlim, inserted, deleted, TSBAccountDef, PersonHasTSBAccountDef, BaseTreeHasTSBAccountDef, dialogColumn, QERAccProductUsage

dbo.ATT_TUAttestationPolicy 3 tasks

SQL_TRIGGER · score 96.831 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

ATT · 3 tasks

Tasks: ATT-K-Attestation-ABORT, ATT-K-Attestation-RESET, ATT-K-HelperAttestationPolicy

Config refs: QER\Attestation, QER\Attestation\OnWorkflowAssign

Reads: inserted, deleted, AttestationObject, DialogTable, AttestationPolicy, PWODecisionMethod, QERWorkingMethod, AttestationCase

dbo.QBM_TUDialogTable 3 tasks

SQL_TRIGGER · score 93.069 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QBM · 3 tasks

Tasks: QBM-K-CommonMakeWatchtrigger, QBM-K-CommonPrepropTable, QBM-K-MissingDisplayRightFill

Config refs: n/a

Reads: inserted, deleted, DialogTable, QBM_VStartupTables, QBM_VQBMRelationALL, QBM_VQBMRelation

dbo.TSB_TUUNSAccountBInUNSGroupB1 3 tasks

SQL_TRIGGER · score 84.997 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB1

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, deleted, UNSAccountBInUNSGroupB1, UNSGroupB1, UNSAccountB, TSBPersonUsesAccount, UNSItemB

dbo.TSB_TUUNSAccountBInUNSGroupB2 3 tasks

SQL_TRIGGER · score 84.997 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB2

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, deleted, UNSAccountBInUNSGroupB2, UNSGroupB2, UNSAccountB, TSBPersonUsesAccount, UNSItemB

dbo.TSB_TUUNSAccountBInUNSGroupB3 3 tasks

SQL_TRIGGER · score 84.997 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB3

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, deleted, UNSAccountBInUNSGroupB3, UNSGroupB3, UNSAccountB, TSBPersonUsesAccount, UNSItemB

dbo.TSB_TUUNSAccountBInUNSGroupB 3 tasks

SQL_TRIGGER · score 84.984 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, deleted, UNSAccountBInUNSGroupB, UNSGroupB, UNSAccountB, TSBPersonUsesAccount, UNSItemB

dbo.TSB_TIUNSAccountBInUNSGroupB1 3 tasks

SQL_TRIGGER · score 84.276 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB1

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, UNSAccountB, UNSRootB, UNSGroupB1, DPRNameSpace, UNSItemB, TSBPersonUsesAccount

dbo.TSB_TIUNSAccountBInUNSGroupB2 3 tasks

SQL_TRIGGER · score 84.276 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB2

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, UNSAccountB, UNSRootB, UNSGroupB2, DPRNameSpace, UNSItemB, TSBPersonUsesAccount

dbo.TSB_TIUNSAccountBInUNSGroupB3 3 tasks

SQL_TRIGGER · score 84.276 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB3

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, UNSAccountB, UNSRootB, UNSGroupB3, DPRNameSpace, UNSItemB, TSBPersonUsesAccount

dbo.TSB_TIUNSAccountBInUNSGroupB 3 tasks

SQL_TRIGGER · score 84.262 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, UNSAccountB, UNSRootB, UNSGroupB, DPRNameSpace, UNSItemB, TSBPersonUsesAccount

dbo.QBM_TUDialogDatabase 3 tasks

SQL_TRIGGER · score 83.458 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Single

QBM · 3 tasks

Tasks: QBM-K-BaseMigrationReady, QBM-K-CommonWaitForCompiler, QBM-K-GetServerProperties

Config refs: QBM\DBQueue\CountSlotsMax, QBM\DBQueue\KeepAlive

Reads: inserted, deleted, DialogDatabase

dbo.TSB_TIUNSAccountBHasUNSGroupB1 3 tasks

SQL_TRIGGER · score 81.924 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB1

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, UNSAccountB, UNSRootB, UNSGroupB1, DPRNameSpace, UNSItemB, TSBPersonUsesAccount

dbo.TSB_TIUNSAccountBHasUNSGroupB2 3 tasks

SQL_TRIGGER · score 81.924 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB2

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, UNSAccountB, UNSRootB, UNSGroupB2, DPRNameSpace, UNSItemB, TSBPersonUsesAccount

dbo.TSB_TIUNSAccountBHasUNSGroupB3 3 tasks

SQL_TRIGGER · score 81.924 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB3

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, UNSAccountB, UNSRootB, UNSGroupB3, DPRNameSpace, UNSItemB, TSBPersonUsesAccount

dbo.TSB_TIUNSAccountBHasUNSGroupB 3 tasks

SQL_TRIGGER · score 81.914 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, UNSAccountB, UNSRootB, UNSGroupB, DPRNameSpace, UNSItemB, TSBPersonUsesAccount

dbo.LDP_TILDAPGroupExclusion 3 tasks

SQL_TRIGGER · score 81.869 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

LDP · 3 tasks

Tasks: LDP-K-LDAPAccountInLDAPGroup, LDP-K-LDPMachineInLDAPGroup, LDP-K-OrgHasLDAPGroup

Config refs: QER\Structures\Inherite\GroupExclusion

Reads: inserted, LDAPGroup, LDAPGroupCollection, LDAPAccountInLDAPGroup, LDPMachineInLDAPGroup, BaseTreeHasLDAPGroup

dbo.TSB_TUUNSAccountBHasUNSGroupB1 3 tasks

SQL_TRIGGER · score 76.29 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB1

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, deleted, UNSAccountBHasUNSGroupB1, UNSAccountB, TSBPersonUsesAccount, UNSItemB

dbo.TSB_TUUNSAccountBHasUNSGroupB2 3 tasks

SQL_TRIGGER · score 76.29 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB2

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, deleted, UNSAccountBHasUNSGroupB2, UNSAccountB, TSBPersonUsesAccount, UNSItemB

dbo.TSB_TUUNSAccountBHasUNSGroupB3 3 tasks

SQL_TRIGGER · score 76.29 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB3

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, deleted, UNSAccountBHasUNSGroupB3, UNSAccountB, TSBPersonUsesAccount, UNSItemB

dbo.TSB_TUUNSAccountBHasUNSGroupB 3 tasks

SQL_TRIGGER · score 76.282 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

TSB · 3 tasks

Tasks: TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB, TSB-K-UNSAccountBInUNSGroupB

Config refs: QER\ComplianceCheck\IncludeTSBPersonUsesAccount

Reads: inserted, deleted, UNSAccountBHasUNSGroupB, UNSAccountB, TSBPersonUsesAccount, UNSItemB

dbo.QBM_TUDialogState 3 tasks

SQL_TRIGGER · score 74.35 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QBM · 3 tasks

Tasks: QBM-K-CommonCountryUTCOffset, QBM-K-CommonStateUTCOffset, QBM-K-CommonStateUTCOffset2

Config refs: n/a

Reads: inserted, deleted, DialogState, QBM_VQBMRelation, DialogTable

dbo.QER_TUPWODecisionMethod 3 tasks

SQL_TRIGGER · score 66.31 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

QER · 3 tasks

Tasks: QER-K-ITSHOPOrder-ABORT, QER-K-ITSHOPOrder-RESET, QER-K-ShoppingRack-All

Config refs: QER\ITShop\OnWorkflowAssign

Reads: inserted, deleted, PWODecisionMethod, QERWorkingMethod, PersonWantsOrg, BaseTreeHasPWODecisionMethod

dbo.LDP_TDLDAPGroupExclusion 3 tasks

SQL_TRIGGER · score 58.955 · 1 insert routines · 1 families

QBM_PDBQueueInsert_Bulk

LDP · 3 tasks

Tasks: LDP-K-LDAPAccountInLDAPGroup, LDP-K-LDPMachineInLDAPGroup, LDP-K-OrgHasLDAPGroup

Config refs: n/a

Reads: deleted, LDAPGroupCollection, LDAPAccountInLDAPGroup, LDPMachineInLDAPGroup, BaseTreeHasLDAPGroup