Community > Answers

How can we help you today?

Ask Question
Manage notifications
Subscribe to this question
53 views

Agent & Customer Satisfaction Data.

Hi There, 

I would like to have  access to the Agents, created by, and Customer satisfaction data, but I can't find it in any of the Live tables. Can you please guide me where to find it?

Regards, 

Paulo 

Paulo Paulo
asked 01/28/2020 20:34
Add Comment
Last Activity 02/19/2020 23:58

1 Answer(s)

  • answered 01/29/2020 07:27
    Ashish Pachori

    You can find this information from LiveHelpdesk_Issue and LiveHelpdesk_Issue_Log table of Live Helpdesk.

    Thanks

    Add Comment
    Paulo
    replied 01/29/2020 13:34

    Hi There, 

    Thanks a lot for your quick answer! I looked into the  LiveHelpdesk_Issue table and didn't find AgentName. I found AgentID, but to respond my question I would like to see the AgentName associated with each AgentID.

    For the  LiveHelpdesk_Issue_Log , are you getting customer satisfaction from the LogType column data? 

    Thanks, 

    Paulo 

    Ashish Pachori
    replied 01/29/2020 13:53

    Thanks a lot for your quick answer! I looked into the  LiveHelpdesk_Issue table and didn't find AgentName. I found AgentID, but to respond my question I would like to see the AgentName associated with each AgentID.

    We store AgentID in LiveHelpdesk_Issue table, You can see the AgentName associated with each AgentID from Users table of DNN.

    For the  LiveHelpdesk_Issue_Log , are you getting customer satisfaction from the LogType column data? 

    Yes

    Paulo
    replied 01/31/2020 15:28

    Thanks. But how do I get the AgentName associated with each AgentID? it's not in the LiveHelpdesk_Issue table. 

    Mandeep Singh
    replied 02/04/2020 17:22

    AgentID is the foreign key for UserID in Users Table; you'll need to join with the Users table which is a core DNN Table. 

    eric barsamian
    replied 02/19/2020 21:44

    Thanks for your help, but I am still having problems finding The User table. Can you please tell me the exact name for the User's table? I am looking into the PRD - INTRA-DB01 Server, but can't find any table  with user information. Is the  ReporterID associated to the user's table? 

     

    Thank you, 

    Paulo 

    Mandeep Singh
    replied 02/19/2020 23:58

    This is a core DNN Table and it's named "Users". It may appear as "dbo.Users" or may have another schema prefixed. Please consult your DBA for further assistance. 

    ReporterID is a foreign key to UserID in Users table. 

    Reply
Add an Answer