dbo.ADS_TIBaseTreeHasADSGroup
SQL_TRIGGER parent BaseTreeHasADSGroup
Created 2025-06-27T18:01:23.537 · modified 2026-04-14T23:23:07.970 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| No parameters. | ||
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| ADSaccount | OBJECT_OR_COLUMN | ||
| ADSContact | OBJECT_OR_COLUMN | ||
| ADSGroup | OBJECT_OR_COLUMN | ||
| ADSMachine | OBJECT_OR_COLUMN | ||
| BaseTree | OBJECT_OR_COLUMN | ||
| Hardware | OBJECT_OR_COLUMN | ||
| HardwareinBaseTree | OBJECT_OR_COLUMN | ||
| helperHardwareOrg | OBJECT_OR_COLUMN | ||
| helperPersonOrg | OBJECT_OR_COLUMN | ||
| helperWorkDeskOrg | OBJECT_OR_COLUMN | ||
| inserted | OBJECT_OR_COLUMN | ||
| personinBaseTree | OBJECT_OR_COLUMN | ||
| QBM_PDBQueueInsert_Bulk | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YDBQueueRaw | TYPE | ||
| QBM_YparameterList | TYPE | ||
| QER_PAssignmentCheckValid | OBJECT_OR_COLUMN | ||
| WorkDeskinBaseTree | OBJECT_OR_COLUMN | ||
| dbo | QBM_FGIBitPatternXOrigin | OBJECT_OR_COLUMN | |
| dbo | QBM_FGIConfigparmValue | OBJECT_OR_COLUMN | |
| dbo | QBM_FGISessionContext | OBJECT_OR_COLUMN | |
| dbo | QER_FGIITShopFlagCombineValid | OBJECT_OR_COLUMN |
Source-derived context
Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.
provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:23:07.970
inserts DBQueue tasks uses session context values has TRY/CATCH error handling
Summary: calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, ADSGroup, personinBaseTree, helperPersonOrg…; uses config TargetSystem\ADS\HardwareInGroupFromOrg
Declared parameters
No declared parameters in sys.parameters for this object, or metadata was not available.
DML targets
INSERT not INSERT intoRead/join references
SQL dependency metadata
- ADSaccount
- ADSContact
- ADSGroup
- ADSMachine
- BaseTree
- Hardware
- HardwareinBaseTree
- helperHardwareOrg
- helperPersonOrg
- helperWorkDeskOrg
- inserted
- personinBaseTree
- QBM_PDBQueueInsert_Bulk
- QBM_PSessionErrorAdd
- QBM_YDBQueueRaw
- QBM_YparameterList
- QER_PAssignmentCheckValid
- WorkDeskinBaseTree
- dbo.QBM_FGIBitPatternXOrigin
- dbo.QBM_FGIConfigparmValue
- dbo.QBM_FGISessionContext
- dbo.QER_FGIITShopFlagCombineValid
Config/session
Config: TargetSystem\ADS\HardwareInGroupFromOrg
Session: None extracted.
DBQueue/tasks
ADS-K-OrgHasADSGroup QER-K-AllChildrenOfOrg QER-K-OrgAutoChild ADS-K-ADSAccountInADSGroup ADS-K-ADSContactInADSGroup ADS-K-BaseTreeHasObject ADS-K-ADSMachineInADSGroupTemp tables / referenced variables
Temp: #LDS #Assignment #Cannot
Variables: @QBM_BitPatternXOrigin_Direct @QBM_BitPatternXOrigin_Inherit_inv @GenProcID @AssignCheckValues @DBQueueElements_01 @DBQueueElements_02 @DBQueueElements_03 @DBQueueElements_04 @DBQueueElements_05 @DBQueueElements_06