Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| locationid | INT | 10 | 0 |
|
|
|||
| name | VARCHAR | 50 | √ | null |
|
|
||
| 1 - Patch Day VM Host Role | LONGTEXT | 2147483647 | null |
|
|
|||
| 2 - Patch Day SBS Role | LONGTEXT | 2147483647 | null |
|
|
|||
| 3 - Patch Day Domain Controller Role | LONGTEXT | 2147483647 | null |
|
|
|||
| 4 - Patch Day Exchange/MSSQL Roles | LONGTEXT | 2147483647 | null |
|
|
|||
| 5 - Patch Day Other Window Server Roles | LONGTEXT | 2147483647 | null |
|
|
|||
| Alert Threshold Percentage | LONGTEXT | 2147483647 | null |
|
|
|||
| Always Alert Manager | LONGTEXT | 2147483647 | null |
|
|
|||
| Assign New Tickets | LONGTEXT | 2147483647 | null |
|
|
|||
| Audit Plan | LONGTEXT | 2147483647 | null |
|
|
|||
| Backup Server | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom1 - Patch Day of the Month | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom1 - Patch Day of the Week | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom1 - Patch Last Day of the Month | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom1 - Patch Week of the Month | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom2 - Patch Day of the Month | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom2 - Patch Day of the Week | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom2 - Patch Last Day of the Month | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom2 - Patch Week of the Month | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom3 - Patch Day of the Month | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom3 - Patch Day of the Week | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom3 - Patch Last Day of the Month | LONGTEXT | 2147483647 | null |
|
|
|||
| Custom3 - Patch Week of the Month | LONGTEXT | 2147483647 | null |
|
|
|||
| Daytime Patch Missed Windows | LONGTEXT | 2147483647 | null |
|
|
|||
| DayTime Patching | LONGTEXT | 2147483647 | null |
|
|
|||
| Default Alert Template | LONGTEXT | 2147483647 | null |
|
|
|||
| Default HTTP Alert Template | LONGTEXT | 2147483647 | null |
|
|
|||
| Default Perf Alert Template | LONGTEXT | 2147483647 | null |
|
|
|||
| Default Ping Alert Template | LONGTEXT | 2147483647 | null |
|
|
|||
| Enable Onboarding | LONGTEXT | 2147483647 | null |
|
|
|||
| Enable Patching Servers | LONGTEXT | 2147483647 | null |
|
|
|||
| Enable Patching Workstations | LONGTEXT | 2147483647 | null |
|
|
|||
| Enable Ticket Policy | LONGTEXT | 2147483647 | null |
|
|
|||
| Exclude Offline Check | LONGTEXT | 2147483647 | null |
|
|
|||
| Initial Response Hours | LONGTEXT | 2147483647 | null |
|
|
|||
| Manager Email | LONGTEXT | 2147483647 | null |
|
|
|||
| Patch Based on Server Role | LONGTEXT | 2147483647 | null |
|
|
|||
| Patch Day Servers | LONGTEXT | 2147483647 | null |
|
|
|||
| Patch Day Workstations | LONGTEXT | 2147483647 | null |
|
|
|||
| Server Service Plan | LONGTEXT | 2147483647 | null |
|
|
|||
| Servers Under Contract | LONGTEXT | 2147483647 | null |
|
|
|||
| Ticket Completed Hours | LONGTEXT | 2147483647 | null |
|
|
|||
| vpropass | LONGTEXT | 2147483647 | null |
|
|
|||
| vprouser | LONGTEXT | 2147483647 | null |
|
|
|||
| Workstation Service Plan | LONGTEXT | 2147483647 | null |
|
|
|||
| Workstations Under Contract | LONGTEXT | 2147483647 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | locationid |
Diagram producer might be missing
No diagrams were produced please see application output for any errors