dbo.QBMServer
Job servers
TableType TUsage CONFIGURATIONRows 1SizeMB 0.08
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_QBMServer | varchar(38) | no | Job server | PKUID |
Ident_Server | nvarchar(128) | no | Server | |
UID_ParentQBMServer | varchar(38) | yes | Parent Job server | FKUID |
IsQBMServiceInstalled | bit(1) | yes | %Globals.QIM_ProductNameShort% Service installed | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
SRVAccount | varchar(990) | yes | Service account | |
SRVAccountPwd | varchar(990) | yes | Password | |
SRVAccountDomain | varchar(990) | yes | Service account domain | |
IsCluster | bit(1) | yes | Server is cluster | |
UID_ClusterServer | varchar(38) | yes | Server belongs to cluster | FKUID |
QueueName | nvarchar(256) | yes | Queue | |
RunningOS | nvarchar(32) | yes | Server operating system | |
JobserverConfiguration | nvarchar(-1) | yes | Configuration data | |
XTouched | nchar(2) | yes | Processing status | |
IsInSoftwareUpdate | bit(1) | yes | Software update running | |
IsNoAutoupdate | bit(1) | yes | No automatic software update | |
XObjectKey | varchar(138) | no | Object key | |
PhysicalServerName | nvarchar(128) | yes | Executing server | |
Encoding | nvarchar(128) | yes | Coding | limited |
IsJobServiceDisabled | bit(1) | yes | Stop %Globals.QIM_ProductNameShort% Service | |
LastTimeoutCheck | datetime(8) | yes | Last timeout check | |
SessionID | varchar(38) | yes | Session ID | UID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
ObjectKeyTargetSystem | varchar(138) | yes | Target system | |
UID_DialogCulture | varchar(38) | yes | Language culture | FKUID |
IPV4 | varchar(15) | yes | IP address (IPv4) | |
IPV6 | varchar(39) | yes | IP address (IPv6) | |
FQDN | nvarchar(512) | yes | Full server name | |
DestCopyMethods | nvarchar(-1) | yes | Copy process (target server) | |
SourceCopyMethods | nvarchar(-1) | yes | Copy process (source server) | |
UID_QBMConnectionInfo | varchar(38) | yes | Connection information | FKUID |
IsNoDatabaseConnect | bit(1) | yes | No direct database connection | |
PortNumber | int(4) | yes | Port | |
LastJobFetchTime | datetime(8) | yes | Last fetch time | |
FQDNExternal | nvarchar(512) | yes | Full server name external | |
PortNumberExternal | int(4) | yes | Port external | |
NotUsedForJobCreation | bit(1) | yes | No process assignment | |
IsJobServiceSuspended | bit(1) | yes | Paused due to unavailability of a target system | |
SuspendReason | nvarchar(-1) | yes | Suspension reason | |
CountUsedHomes | int(4) | yes | Homes created | |
IsAutoShareHome | bit(1) | yes | Home server with automatic sharing | |
MaxSpaceHomes | int(4) | yes | Max. home storage space [MB] | |
MaxNumberHomes | int(4) | yes | Max. number of homes | |
UID_QBMServerNearestDC | varchar(38) | yes | Local AD DC | FKUID |
Relations
| FK | From | To |
|---|---|---|
| ADS_RFRL1209 | BaseTree.UID_DefaultPrintServer | QBMServer.UID_QBMServer |
| ADS_RFRL795 | ADSAccount.UID_TerminalProfileServer | QBMServer.UID_QBMServer |
| DPR_RFRL2483 | DPRServiceGate.UID_QBMServer | QBMServer.UID_QBMServer |
| DPR_RFRL2485 | DPRRootObjConnectionInfo.UID_QBMServer | QBMServer.UID_QBMServer |
| QBM_RFRL357 | QBMServerHasServerTag.UID_QBMServer | QBMServer.UID_QBMServer |
| QBM_RFRL358 | QBMServer.UID_DialogCulture | QBMCulture.UID_DialogCulture |
| QBM_RFRL383 | QBMServerHasDeployTarget.UID_QBMServer | QBMServer.UID_QBMServer |
| QBM_RFRL440 | QBMServer.UID_QBMConnectionInfo | QBMConnectionInfo.UID_QBMConnectionInfo |
| QER_RFRL3319 | ServerHasShares.UID_Server | QBMServer.UID_QBMServer |
| TSB_RFRL4293 | UNSRootB.UID_SyncServer | QBMServer.UID_QBMServer |
Triggers
GEN_T1AF9738269E36D4BD687D6339 SQL_TRIGGER
GEN_T25023756BABB2911A175F2728 SQL_TRIGGER
GEN_T3BD0F51A11F67F5670DA64D3E SQL_TRIGGER
GEN_T4993E9AA5726EA58B23C0FF37 SQL_TRIGGER
GEN_T5E69941596630EEF61E2DCE16 SQL_TRIGGER
GEN_T6DDEA8B5ED5681B78E99E42A5 SQL_TRIGGER
QBM_TDQBMServer SQL_TRIGGER
QBM_TIQBMServer SQL_TRIGGER
QBM_TUQBMServer SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.QBM_FGIQBMServerInfo | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PDatabasePrepare | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobCreate | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueInit_i | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueLoad | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobqueueoverViewFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PJobUpdateState_Bulk | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_PQBMServerHasJobService | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_ZJobPerformanceFill | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T15C67D01E31022B8D23F298A8 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1603BDFF9396E4E301A6A5255 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1AF9738269E36D4BD687D6339 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1E6D3A01CEB12EADF4972D884 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T20C3366B9D322CD1C80FCEDAF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T236F0F75AB9F7309F1342269A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T25023756BABB2911A175F2728 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2BA9223C3DCBE683F1DF50DC0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T367B7685389BE0005337B435A | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3BD0F51A11F67F5670DA64D3E | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T3C95DEB35C372E97D68C244BA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5E69941596630EEF61E2DCE16 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TDQBMServerHasDeployTarget | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TIQBMServerHasDeployTarget | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBMVSystemOverview | SQL expression dependency | OBJECT_OR_COLUMN |
| BaseTree | foreign key references table | ADS_RFRL1209: BaseTree.UID_DefaultPrintServer -> QBMServer.UID_QBMServer |
| ADSAccount | foreign key references table | ADS_RFRL795: ADSAccount.UID_TerminalProfileServer -> QBMServer.UID_QBMServer |
| DPRServiceGate | foreign key references table | DPR_RFRL2483: DPRServiceGate.UID_QBMServer -> QBMServer.UID_QBMServer |
| DPRRootObjConnectionInfo | foreign key references table | DPR_RFRL2485: DPRRootObjConnectionInfo.UID_QBMServer -> QBMServer.UID_QBMServer |
| QBMServerHasServerTag | foreign key references table | QBM_RFRL357: QBMServerHasServerTag.UID_QBMServer -> QBMServer.UID_QBMServer |
| QBMCulture | referenced by foreign key from table | QBM_RFRL358: QBMServer.UID_DialogCulture -> QBMCulture.UID_DialogCulture |
| QBMServerHasDeployTarget | foreign key references table | QBM_RFRL383: QBMServerHasDeployTarget.UID_QBMServer -> QBMServer.UID_QBMServer |
| QBMConnectionInfo | referenced by foreign key from table | QBM_RFRL440: QBMServer.UID_QBMConnectionInfo -> QBMConnectionInfo.UID_QBMConnectionInfo |
| ServerHasShares | foreign key references table | QER_RFRL3319: ServerHasShares.UID_Server -> QBMServer.UID_QBMServer |
| UNSRootB | foreign key references table | TSB_RFRL4293: UNSRootB.UID_SyncServer -> QBMServer.UID_QBMServer |
| dbo.QBM_FGIQBMServerInfo | source text reference | SQL_SCALAR_FUNCTION |
| dbo.QBM_PDatabasePrepare | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PJobCreate | source text reference | creates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobQueueInit_i | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobQueueLoad | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobqueueoverViewFill | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_PJobUpdateState_Bulk | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, has TRY/CATCH error handling |
| dbo.QBM_PQBMServerHasJobService | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_ZJobPerformanceFill | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TDQBMServerHasDeployTarget | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| dbo.QBM_TIQBMServerHasDeployTarget | source text reference | creates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling |
| cs-ads-forms-ads-forms-formadsaccountmasterdata.cs | decompiled C# reference | classes FormADSAccountMasterData; methods OnInit, _ActivateForm, _AdaptTasks, FormTask_MoveToDomain, FormTask_MoveContainer, FormTask_Unlock; references ADSAccount, ADSAccountInADSGroup, ADSContainer, ADSDomain, ADSGroup, Delegation; markers reads entity values, writes entity values, references DB/Dialog objects |
| cs-common-customizer-vi-common-customizer-qbmserver.cs | decompiled C# reference | classes QBMServer; methods MoveNext, SetStateMachine, ServerHasTagAsync, _AssignDefaultDeployTargetsOnSaved, GetServiceUrl, GetAddress; references QBMDeployTarget, QBMDeployTargetHasServerTag, QBMServer, QBMServerHasDeployTarget, QBMServerHasServerTag, QBMServerTag; markers reads entity values, references DB/Dialog objects |
| cs-designer-editors-designer-jobservereditor-jobservereditor.cs | decompiled C# reference | classes JobServerEditor, JobServerStats; methods GetKeyForItem, _serverTagsEditor_DataChanged, OnDisposeOrPrepareForCaching, OnSelectedDocumentChanged, OnSelectedDocumentChanging, EditorObject_ValueChanged; references QBMDeployTarget, QBMDeployTargetHasServerTag, QBMServer, QBMServerHasDeployTarget, QBMServerHasServerTag, QBMServerTag; markers reads entity values, references DB/Dialog objects |
| cs-vi-db-compile-vi-db-compile-dialogjobgenassemblybuilder.cs | decompiled C# reference | classes DialogJobGenAssemblyBuilder, _ValueReplacer, _003C_003Ec__DisplayClass21_0, _003C_003Ec__DisplayClass23_0; methods Replace, _ReplaceMatch, _003C_GenerateEventsAsync_003Eb__0, _003C_GenerateJobAsync_003Eb__0, MoveNext, SetStateMachine; references DialogTable, JobChain, JobComponent, JobEventGen, JobParameter, JobRunParameter; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-vi-db-compile-vi-db-compile-sourcegenerators-jobssourcegenerator.cs | decompiled C# reference | classes JobsSourceGenerator, JobsAssemblyGenerator, _PreloadTable, _ValueReplacer; methods _003C_ReplaceMatchAsync_003Eb__0, MoveNext, SetStateMachine, _CreateRegPattern, _CreateRegVersion, ReplaceAsync; references DialogTable, JobChain, JobComponent, JobEventGen, JobParameter, JobRunParameter; markers reads entity values, references DB/Dialog objects, Job/process related markers |
| cs-vi-projector-editor-vi-projector-editor-jobservicedialog.cs | decompiled C# reference | classes JobServiceDialog; methods MoveNext, SetStateMachine, _Translate, _SetupLogic, _CheckFQDN, _BuildName; references QBMServer, QBMServerHasServerTag, QBMServerTag; markers reads entity values, writes entity values, references DB/Dialog objects |