MeToo and Linked Calls

[Everton1878]

Hi,

Where can I find out the number of users that have clicked the 'Me Too' button on the portal and the number of linked calls for a problem?

I'd like to be able to report on it for our monthly reports and also display in a list of open problems in a dashboard

Thanks,

Pete

[James Ainsworth]

Hi @Everton1878

There is a table called h_itsm_request_connections which stores the connections, or Me Too links.  

I created a 'List of Data' widget using the Custom SQL option on a  to provide something similar.  

SELECT h_request_id As Reference, h_itsm_requests.h_summary AS Summary, COUNT(h_request_id) AS Impacted from h_itsm_request_connections
inner Join h_itsm_requests on h_request_id=h_pk_reference and h_requesttype='Problem' and (h_status='status.open'  OR h_status='status.new')
Group by h_request_id
order by Impacted desc
Limit 10

Steps to create..

1. Open 'Advanced Analytics'
2. Click on the 'Widgets' tile
3. Click on + to create new widget
4. Select the General Settings button in the tool bar
5. Select List of Data from the 'Type of Widget' pick list
6. Select the Widget Settings button in the tool bar
7. Under 'List Type' select Custom SQL Query
8. Click on the 'Edit Custom SQL'
9. Copy and paste the above SQL in the provided box
10. Click 'Apply Changes'

Let me know if this helps or is close to what you are looking for.

Regards,

James

[Everton1878]

Thanks @James Ainsworth that's great

I've tweaked it slightly for what I want but that gave me a great start, much appreciated

I'll see if I can do something similar with h_itsm_rel_requests for the linked calls, the problem might be which way round the calls were linked as to which is the problem and which is the child call

[James Ainsworth]

We are looking to eventually provide relationship options on the linked requests so that you will be able to have things like 'Caused by' or 'Impacted by' on the links.  Still a way off but possibly this will help you in the future.

James