vTicketSummary
|
vTicketSummary |
Trouble ticket summary. One row per ticket. Column names are used as the names displayed in the view summary table. |
|
|
Column Name |
Type |
Purpose |
|
TicketID |
int(10), null |
unique trouble ticket ID number |
|
Machine_GroupID |
varchar(201), null |
A concatenated representation of the machine id and the group id it is associated with. |
|
agentGuid |
numeric(26,0), null |
A globally unique identifier for a machine ID.group ID account and its corresponding agent. |
|
machName |
varchar(100), null |
Machine Name used for each agent |
|
groupName |
varchar(100), null |
Organization, then machine group the machine is assigned to. |
|
TicketSummary |
varchar(256), not null |
summary string briefly describing the ticket |
|
Assignee |
varchar(100), null |
Admin name this ticket is assigned to |
|
CreatedBy |
varchar(100), null |
admin name (or machine ID if entered by user) of the person that created this ticket |
|
CreationDate |
datetime(3), null |
timestamp when the ticket was created |
|
DueDate |
datetime(3), null |
ticket due date |
|
LastModifiedDate |
datetime(3), null |
Date of the most recent note entered for this ticket |
|
ResolutionDate |
datetime(3), null |
timestamp when the ticket was closed |
|
UserName |
varchar(100), null |
The name of the submitter |
|
UserEmail |
varchar(200), null |
The email address of the submitter |
|
UserPhone |
varchar(100), null |
The phone number of the submitter |
|
TicketInternalId |
int(10), not null |
An internal unique trouble ticket ID throughout all partitions. |
|
partitionId |
numeric(26,0), not null |
The unique tenant partition identifier for a shared Kaseya Server and database. |
