SSIS Components for Freshdesk

Build 24.0.9063

TicketProperties

Query the TicketProperties view.

Table Specific Information

Select

Following is an example to select all entries from the TicketProperties table: 

SELECT * FROM TicketProperties

Columns

Name Type Description
TicketId Bigint Ticket Id of the ticket property.
Subject String Subject of the ticket property.
Status String Status of the ticket property.
Priority String Priority of the ticket property.
Source String Source of the ticket property.
TicketType String Ticket type of the ticket property.
AssociationType String Association type of the ticket property.
AgentName String Agent name of the ticket property.
ResolutionDueBy Datetime Resolution Due By of the ticket property.
FirstAssignedDate Datetime First Assigned Date of the ticket property.
CreatedDate Datetime Created Date of the ticket property.
FirstResponseDueBy Datetime First Response Due By of the ticket property.
AgentReplyCount Bigint Agent Reply Count of the ticket property.
CustomerReplyCount Bigint Customer Reply Count of the ticket property.
LastUpdatedDate Datetime Last Updated Date of the ticket property.
ResolvedDate Datetime Resolved Date of the ticket property.
ClosedDate Datetime Closed Date of the ticket property.
FirstResponseDate Datetime First Response Date of the ticket property.
ReferenceNumber String Reference Number of the ticket property.
RequesterName String Requester name of the ticket property.
RequesterEmail String Requester email of the ticket property.
RequesterType String Requester type of the ticket property.
RequesterLanguage String Requester language of the ticket property.
CompanyName String Company name of the ticket property.
GroupName String Group name of the ticket property.
AssignType String Assign type of the ticket property.
Product String Product of the ticket property.
FirstAssignedGroup String First Assigned Group of the ticket property.
LastUpdatedAgent String Last Updated Agent of the ticket property.
FirstAssignedAgent String First Assigned Agent of the ticket property.
AgentEmail String Agent email of the ticket property.
TicketsAge Bigint Tickets Age of the ticket property.
FirstResponseGroup String First Response Group of the ticket property.
FirstAssignTimeInCalendarHours Bigint First Assign Time In Calendar Hours of the ticket property.
FirstResponseTimeInCalendarHours Bigint First Response Time In Calendar Hours of the ticket property.
FirstResponseTimeInBusinessHours Bigint First Response Time In Business Hours of the ticket property.
IsSpam Boolean Is Spam of the ticket property.
ResolutionTimeInCalendarHours Bigint Resolution Time In Calendar Hours of the ticket property.
ResolutionTimeInBusinessHours Bigint Resolution Time In Business Hours of the ticket property.
NoOfGroupReassignsTillDate Bigint No Of Group Reassigns Till Date of the ticket property.
NoOfTimesReopened Bigint No Of Times Reopened of the ticket property.
IsTrash Boolean Is Trash of the ticket property.
LastAssignedDate Datetime Last Assigned Date of the ticket property.
FirstAssignTimeInBusinessHours Bigint First Assign Time In Business Hours of the ticket property.
NoOfAgentReassignsTillDate Bigint No Of Agent Reassigns Till Date of the ticket property.
AgentLanguage String Agent language of the ticket property.
AgentTimezone String Agent timezone of the ticket property.
InternalGroupName String Internal group name of the ticket property.
InternalAgentName String Internal agent name of the ticket property.
StatusSLATimer Boolean Status SLA Timer of the ticket property.
TicketsResolvedWithinFCR String Tickets Resolved Within FCR of the ticket property.
TicketsResolvedWithinSLA String Tickets Resolved Within SLA of the ticket property.
TicketsFirstRespondedWithinSLA String Tickets First Responded Within SLA of the ticket property.
FirstResponseAgent String First Response Agent of the ticket property.
TicketsNextRespondedWithinSLA String Tickets Next Responded Within SLA of the ticket property.
SkillName String Skill Name of the ticket property.
SurveyResultsEmotion String Survey Results Emotion of the ticket property.
SurveyResultsSurveyStatus String Survey Results Survey Status of the ticket property.
SurveyResultsChoices String Survey Results Choices of the ticket property.
SurveyResultsRespondedDate Datetime Survey Results Responded Date of the ticket property.
SurveyResultsSurveyName String Survey Results Survey Name of the ticket property.
SurveyResultsSentVia String Survey Results Sent Via of the ticket property.
SurveyResultsSurveyCreatedDate Datetime Survey Results Survey Created Date of the ticket property.
SurveyResultsQuestion String Survey Results Question of the ticket property.
SurveyResultsAgentName String Survey Results Agent Name of the ticket property.
SurveyResultsGroupName String Survey Results Group Name of the ticket property.
SurveyResultsCustomer String Survey Results Customer of the ticket property.
SurveyResultsDefaultSurvey String Survey Results Default Survey of the ticket property.
SurveyResultsSurveySentDate Datetime Survey Results Survey Sent Date of the ticket property.
SurveyUpdatedDate Datetime Survey Updated Date of the ticket property.
SurveySentDate Datetime Survey Sent Date of the ticket property.
SurveySurveyStatus String Survey Survey Status of the ticket property.
SurveySurveyName String Survey Survey Name of the ticket property.
SurveyDefaultSurvey String Survey Default Survey of the ticket property.
TicketThemeKeywords String Ticket Theme Keywords of the ticket property.
TicketThemeName String Ticket Theme Name of the ticket property.
TagName String Tag Name of the ticket property.
ContactsType String Contacts Type of the ticket property.
ContactsEmail String Contacts Email of the ticket property.
ContactsName String Contacts Name of the ticket property.
ContactsLanguage String Contacts Language of the ticket property.
ContactsTimeZone String Contacts Time Zone of the ticket property.
ContactsMobile String Contacts Mobile of the ticket property.
ContactsMobileNumber String Contacts Mobile Number of the ticket property.
CompanyIndustry String Company Industry of the ticket property.
CompanyRenewalDate Datetime Company Renewal Date of the ticket property.
CompanyAccountTier String Company Account Tier of the ticket property.
CompanyHealthScore String Company Health Score of the ticket property.
CannedResponseUsedAt Datetime Canned Response Used At of the ticket property.
CannedResponseTicketID String Canned Response Ticket ID of the ticket property.
CannedResponseCannedResponseTitle String Canned Response Canned Response Title of the ticket property.
CannedResponseNoteType String Canned Response Note Type of the ticket property.
CannedResponseAgent String Canned Response Agent of the ticket property.
CannedResponseAgentType String Canned Response Agent Type of the ticket property.
CannedResponseCannedResponseVisibility String Canned Response Canned Response Visibility of the ticket property.
CannedResponseCannedResponseCreatedAt Datetime Canned Response Canned Response Created At of the ticket property.
CannedResponseAgentGroup String Canned Response Agent Group of the ticket property.
CannedResponseFolder String Canned Response Folder of the ticket property.
CannedResponseCannedResponseUpdatedAt Datetime Canned Response Canned Response Updated At of the ticket property.
CannedResponseCannedResponseAuthor String Canned Response Canned Response Author of the ticket property.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063