Data stores

The app uses the following data stores:

1. Azure Storage Account
   • [Table] Storage for bot related configurations (welcome message, KbId, TeamId, and static tab text)
   • [Table] For tracking all of the requests and the necessary actions that impact a request - i.e. request is assigned to a SME
2. Azure Search service list item index, created and maintained by the QnAMaker cognitive service.

All these resources are created in your Azure subscription. None are hosted directly by Microsoft.

Storage account

ConfigurationInfo Table

The ConfigurationInfo table stores data about the necessary configurations that are required for the bot. The table has the following rows.

Attribute	Comment
KnowledgeBaseId	This is the knowledge base Id for which the bot can return answers from the QnA Maker.
MSTeamId	The team Id which the bot can be able to post messages whenever the end user asks for an expert's assistance with a query.
StaticTabText	The static tab text, would be the standard text that is displayed in the help tab which will be installed along with the bot in a personal scope. The static tab text will be configured by the configurator application, and is publically accessible with no authentication.
WelcomeMessage	The welcome message is a configurable text that the bot would send to the user the very first time that a user installs the bot in a personal scope.

TicketInfo Table

The TicketInfo table stores data about tickets (or requests) that are posted to the SME Team by the bot on behalf of a user. Each row in the table has the following columns:

Attribute	Comment
TicketId	The ticket ID.
Status	An integer value.
Title	The end user title provided.
DateCreated	The date when a new ticket is created.
Description	The description text that is written by the end user.
RequesterName	The name of the end user when a new ticket is created.
RequesterUserPrincipalName	The email address of the end user.
RequesterGivenName	The first name of the end user
RequesterConversationId	The conversationId of the 1:1 chat between the end user and the FAQ++ bot.
SmeCardActivityId	The activityId when the new ticket adaptive card is posted in the General channel of the SME team.
SmeThreadConversationId	The conversationId in the SME team General channel at the time a new ticket is created.
DateAssigned	The date when a SME user self-assigns a ticket.
AssignedToName	The name of the SME user who self-assigns a ticket.
AssignedToObjectId	The AAD Object ID of the SME user who self-assigns a ticket.
DateClosed	The date when a ticket is updated to the closed status.
LastModifiedByName	The name of the SME user who recently updated the ticket.
LastModifiedByObjectId	The AAD Object ID of the SME user who recently updated the ticket.
UserQuestion	The original question that has been asked by the end user.
KbEntryAnswer	The answer that is stored in the knowledge base.