I am looking to set up a dashboard to show what type of tickets are being raised per day, but can't see in any of the database tables where the request profile codes are linked to the ticket number - can someone point me in the right direction please? thanks
I have recently deployed a number of employee portals on our instance and am trying to query how many tickets raised from each employee portal.
I can see the traffic from h_sys_pagevisit_log, but the h_source_type on the h_itsm_requests table just shows 'Self Service' - can this be changed to show which portal the ticket has been raised from or is there another way to query this? thanks
Thanks Victor - I wasn't using 'Measure Samples Group By', but have just created a new widget using your suggestion, but getting an error and no data being displayed.
Hi James - I only see 3 reports, but I get emailed my monthly reports that I need to amend, but can't see any of them - we have a lot more than 3 reports. This is all I can see and two of the reports were created yesterday.
On attempting to create a report from h_itsm_requests - this table is no longer selectable from the drop down - which table has this been replaced with? Thanks
I cannot see reports, widgets, measures and dashboards on the Admin pages to amend that I know are there to edit them.
My role access has not changed. Any assistance would be appreciated - thanks