Advanced Search
Search Results
335 total results found
Email & Communication - Table Index
All 50 tables in the Email & Communication category. Table Type Columns Key BulkEmail BASE TABLE 19 BulkEmailUser BASE TABLE 8 CANNEDTEXT BASE TABLE 14 CANNEDTEXTPERMISSION BASE TABLE 4 CannedTextFavourites BASE TABLE 3 CannedTextTag BASE...
Reports & Analytics - Key Tables
Full column listings for the 2 key tables in this category. ANALYZERPROFILE (99 columns) # Column Type Length Nullable Default 1 APid int NO 2 APTitle nvarchar 4000 YES 3 APSQL ntext 1073741823 YES 4 APEmailsubject ntext 1073741823 YES 5 AP...
Reports & Analytics - Table Index
All 63 tables in the Reports & Analytics category. Table Type Columns Key ANALYZERFILTER BASE TABLE 10 ANALYZERPROFILE BASE TABLE 99 KEY ANALYZERPROFILECOLUMN BASE TABLE 16 ANALYZERSUMMARYCOL BASE TABLE 7 ANALYZERSUMMARYGROUP BASE TABLE 4 ...
Agents & Technicians - Key Tables
Full column listings for the 4 key tables in this category. SECTIONDETAIL (50 columns) # Column Type Length Nullable Default 1 SDid int NO 2 SDSectionName nvarchar 200 YES 3 SDWorkingHoursBeforeAlert float YES ((0)) 4 SDEmailAddress nvarchar 4...
Actions (Ticket Notes) - Key Tables
Full column listings for the 3 key tables in this category. ACTARC (68 columns) # Column Type Length Nullable Default 1 Faultid int NO 2 actionnumber int NO 3 Actoutcome nvarchar 4000 YES 4 who nvarchar 4000 YES 5 Whe_ datetime YES 6 n...
Actions (Ticket Notes) - Table Index
All 7 tables in the Actions (Ticket Notes) category. Table Type Columns Key ACT BASE TABLE 5 ACTARC BASE TABLE 68 KEY ACTIONS BASE TABLE 199 KEY ACTYPE BASE TABLE 11 KEY ActionReaction BASE TABLE 5 ActionRead BASE TABLE 4 Action_View VIEW...
Tickets (Faults) - Key Tables
Full column listings for the 13 key tables in this category. FAULTAPPROVAL (30 columns) # Column Type Length Nullable Default 1 FAid int NO 2 FAseq int NO 3 FAActionNumber int YES ((0)) 4 FAEmailstatus int YES ((0)) 5 FAResult int YES ((0...
Invoicing & Billing - Key Tables
Full column listings for the 5 key tables in this category. CHARGERATE (27 columns) # Column Type Length Nullable Default 1 CRid int NO 2 CRarea int NO 3 CRchargeid int NO 4 CRstartdate datetime NO 5 CRrate float YES ((0)) 6 CRorg int...
Invoicing & Billing - Table Index
All 40 tables in the Invoicing & Billing category. Table Type Columns Key ACCOUNTSINTERFACE BASE TABLE 19 BILLINGREPORT BASE TABLE 21 BillingAudit BASE TABLE 5 BillingPlanCriteria BASE TABLE 10 CHARGECD BASE TABLE 3 CHARGERATE BASE TABLE ...
Clients & Sites - Key Tables
Full column listings for the 5 key tables in this category. AREA (332 columns) # Column Type Length Nullable Default 1 Aarea int NO 2 aareadesc nvarchar 4000 YES 3 Amemo ntext 1073741823 YES 4 Aannounce ntext 1073741823 YES 5 Aannouncedate ...
Ticket Configuration - Key Tables
Full column listings for the 7 key tables in this category. CATEGORYDETAIL (14 columns) # Column Type Length Nullable Default 1 CDid int NO 2 CDCategoryName nvarchar 4000 YES ('') 3 CDType int YES ((0)) 4 CDSLAid int YES ((-1)) 5 CDseriousne...
Custom Fields & Configuration - Key Tables
Full column listings for the 3 key tables in this category. CONTROL (808 columns) # Column Type Length Nullable Default 1 Rseq int NO 2 RDBVersion int YES ((0)) 3 RDBname nvarchar 8 YES 4 RShbitmaps bit NO ((0)) 5 RShMap bit NO ((0)) 6 R...
Synology NAS — Google Workspace Backup Configuration SOP
1. Purpose This SOP documents the process for configuring a Synology NAS device to perform automated backups of a client's Google Workspace (GWS) domain, including all user accounts, Shared Drives, Gmail, Contacts, and Calendar data. It covers Google Cloud pro...
Cloud Backup Architecture Standards
This page defines the standard architecture for how DTC provisions cloud object storage (Backblaze B2, S3-compatible) for backup workloads. It applies to all cloud-backed backup systems regardless of source platform — Veeam BDR, TrueNAS Cloud Sync, MSP360, or ...
TrueNAS Cloud Sync Provisioning SOP
This SOP documents how DTC provisions a TrueNAS appliance (CORE or SCALE) with Backblaze B2 cloud-backed offsite backup via Cloud Sync Tasks. It covers NinjaOne NMS onboarding, device GUID generation, bucket provisioning, scoped application key creation, Cloud...
Our Identity
DTC's standards for how identity, credentials, and authentication are managed across client environments. Covers credential generation, service account naming, break-glass accounts, and approved credential storage.
Client Credential Administration Standard
This standard defines how DTC technicians create, assign, rotate, and document credentials across DTC-managed client environments. It applies to all DTC-managed client infrastructure and supersedes any per-tech or per-client variation. See also: DTC Company In...
Monthly Forecast SOP
Monthly Forecast Spreadsheet Standard Operating Procedure Version 1.0 | Owner: Project Manager | Updated: April 2026 1. Purpose This SOP defines how to create, maintain, and close out the Monthly Forecast Spreadsheet used by the Project Management and Clie...