Jump to content
Everton1878

MeToo and Linked Calls

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

  • Like 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...