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.