How to report on Virtual Agent topic usage by device

arobertson
Tera Guru

Hi everyone.

 

I seem to be getting strange results when trying to report on topic usage by device type.

 

My report is on the sys_cs_conversation_task table where I then dot walk to sys_cs_conversation to get the device type.

 

I'm reporting on where topic = "My topic name". But for some mobile entries I cannot see it listed even though I know they have clicked on it. 

6 REPLIES 6

Lynda1
Kilo Sage

When I need to see the topics by Device Type,  I start with this table va_view_conversation_interaction_task.

Thanks for replying.

 

I can't seem to actually find that table in our instance?

The only way I can get to that is by using create a report. If I try to get to the actual table, the system yells at me.

Since I have some time, I will see if I can get what you are looking for using the two tables you mentioned. I just learned those two are rather limited so I cheated?

Still cannot find that table even in the reporting module. It must be part of a plugin?

 

I did noticed that when using Virtual Agent an interaction is created each time, which is useful to see the state and reason but not useful in the fact you cannot seem to track it back to the topic.

 

Virtual Agent interaction records (servicenow.com)