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

unique trouble ticket ID number

Machine_GroupID

varchar

A concatenated representation of the machine id and the group id it is associated with.

agentGuid

numeric

A globally unique identifier for a machine ID.group ID account and its corresponding agent.

machName

varchar

Machine Name used for each agent

groupName

varchar

Group Name used for each agent

TicketSummary

varchar

summary string briefly describing the ticket

Assignee

varchar

Admin name this ticket is assigned to

CreatedBy

varchar

admin name (or machine ID if entered by user) of the person that created this ticket

CreationDate

datetime

timestamp when the ticket was created

DueDate

datetime

ticket due date

LastModifiedDate

datetime

Date of the most recent note entered for this ticket

ResolutionDate

datetime

timestamp when the ticket was closed

UserName

varchar

The name of the submitter

UserEmail

varchar

The email address of the submitter

UserPhone

varchar

The phone number of the submitter