will.good

Hi, Is there a way to be able to limit service desk users reopening requests so that they can only reopen resolved requests and not closed requests? Ideally, we want our service desk team to only be able to reopen requests when resolved, same as the customer can in the employee portal. Maybe an application right that allows Reopening Resolved Requests and Reopening Closed Requests (in our case reserved for admin users) could achieve this?

+1

Hi @James Ainsworth It is a Service Request, we don't use Wait for Assessment nodes in any of our BPs. I have been testing this just through an autotask (attached) and not through the actual BPM (don't think that would make a difference though?) Also attached the BPM if that helps testing.draft.bpm.txt generic-process---low-priority.version-112.bpm.txt

Hi, Could we add an option to the suspend node to wait for a connection to be added? We have a need to do this as the connection will need to be emailed later on in the process, there is currently no way to check that the connection has been added before moving on in the process.

Hi @James Ainsworth Using the Lock Escalate doesn't appear to work for us - even setting all the options on the node as yes, still leave the assessment action unlocked

Hi, The ability to lock the assessment action is missing from the Lock/Unlock Actions node - please can this be added

We are seeing the same issues across our organisation. Our issue appears to be with using outdated browsers... our users are using Microsoft Edge build 92.0.902.73. However, getting them to update, is not as easy, as Global IT have to manually deploy updates across our estate which have to go through an approval process (which is notoriously slow unfortunately)

Seems strange we are unable to delete contacts when we can delete basic/full users...can someone tag this as an enhancement to be able to do this? Using the Clean Utility admittedly scares me a little

Hi, How can we delete a contact? I have the Contacts Admin role which has a delete contact right, but I cannot find a way to actually delete a contact from their profile page?

Hi, Is it possible to specify an exact match when searching for a user id in the customer search form on ICs? An example of how this could be achieved is by enclosing the search term in "" Earlier today I had to log a ticket just with someone's ID number and searching for their ID number of 310 brought up a lot of results, which meant I couldn't scroll down to select their user account.

+1 we would really like this

Hi, I created a database direct query to count the number of first time fix rates (just as I wanted this with columns as source type, which I can't do in SM Reporting). I'm a little confused as to why I am getting different numbers from this query compared to an existing report in SM. I've uploaded the report definition file and included the query below... anyone have any ideas on what I'm missing and why they are different? E.g. if I run it for March, I get the below: From Database Direct 'Analyst': Yes: 1997 No: 409 From Service Manager Reporting: Yes: 1584 No: 999 SELECT Replace( replace(h_firsttimefix, '1', 'Yes'), '0', 'No' ) as "First Time Fix", SUM( case when h_source_type = "Analyst" THEN 1 END ) AS "Analyst", SUM( case when h_source_type = "Email" THEN 1 END ) AS "Email", SUM( case when h_source_type = "Chat" THEN 1 END ) AS "Chat", SUM( case when h_source_type = "Self Service" THEN 1 END ) AS "Self Service", SUM( case when h_source_type = "Autoresponder" THEN 1 END ) AS "Autoresponder", SUM( case when h_source_type = "Request" THEN 1 END ) AS "Request", COUNT(h_source_type) AS "Total" FROM h_itsm_requests where h_firsttimefix is not null and ( h_datelogged >= '2023-03-01' and h_datelogged <= '2023-03-31 23:59:59' ) group by h_firsttimefix first-time-fix.report.txt

Hi, We need a way to be able to email a customer and cc a connection (sometimes multiple types of connections) using a BPM node. I cannot work out a way to do this currently. Using the Email Notification node would work for us, if there was a way to get connections information and insert the email address of each connection in to the CC field. Am I missing something obvious / looking in the wrong place? Tagged as enhancement if not possible currently

Hi, (hopefully) minor enhancement request. Could we potentially have a pop-up text box when exporting a database direct query, to enable us to name the exported file? I.e. when you click export, a pop up box appears "Please provide a name for the file", then the downloaded file would then take this name. This is an example of the pop up box currently used by our HR System's SQL export

@Keith Stevenson I am trying to join h_itsm_requests_attachments with h_itsm_requests to get the request status, but i get an error when trying to run this in database direct, works fine without adding the status column and joining the table...any idea where I am going wrong with the join? SELECT h_request_id as "Request ID", h_pk_id as "ID", h_filename as "Filename", h_description as "Description", h_size as "Size", concat(substring(h_timestamp,9,2),"/",substring(h_timestamp,6,2),"/",substring(h_timestamp,1,4)) as "Date Added", substring(h_timestamp,12,8) as "Time Added", h_visibility as "Visibility", h_status as "Status" FROM h_itsm_requests_attachments JOIN h_itsm_requests on h_request_id = h_pk_reference Where h_size is not null order by h_size DESC

Hi, What unit is the h_size column in the above table? e.g. one entry in the table is for a pdf, on the request it shows the size as (733.4 kB), but in the h_size column it shows as 751020

Hi James, Thanks - the exact key that did it was user.view.request.details.schedule.success

Thanks for getting back to me, James. Either would be a good solution, however I think being able to mark the visibility of each connection would make the most sense for us - similar to the settings available for attachments currently. Being able to mark attachments as customer or team visibility when adding them / later on from the attachments pane is extremely useful, so something similar to this is our desired way forward.

Hi, Is the timeline entry for changes translatable? I can't seem to see this anywhere in translations or in Service Manager config. The only setting I could find is ui.app.com.hornbill.servicemanager.schedule.scheduledBetween which has not changed the timeline entry text.

Hi, We need a way to be able to hide the connections drop down list from the self service view of a ticket. When we have sensitive cases, we will add a number of people from across the business as connections. Some of these people we have added, we would not want the customer to see as a connection. Can we add a visibility option to the connections tab, similar how there is one for all timeline updates, and attachments to be able to show / hide this based on visibility

I *think* I have been able to create a sql that does this... would appreciate if someone could confirm (SQL is not my most confident of areas) select left(h_datelogged,10) as "Date Logged", SUM(case when h_source_type = "Analyst" THEN 1 END) AS "Analyst", SUM(case when h_source_type = "Email" THEN 1 END) AS "Email", SUM(case when h_source_type = "Chat" THEN 1 END) AS "Chat", SUM(case when h_source_type = "Self Service" THEN 1 END) AS "Self Service", SUM(case when h_source_type = "Autoresponder" THEN 1 END) AS "Autoresponder" FROM h_itsm_requests WHERE (h_datelogged >= '2023-04-03 00:00:00' and h_datelogged <= '2023-04-09 23:59:59') group by left(h_datelogged,10)

Hi, I am looking to create a report that would show a count of requests by source by date between a filter date range. e.g. if the date range was 01/03/2023 - 31/03/2023 it would provide a count of each source type for 01/03, 02/03 and so on I would be able to do this fairly easily if the date logged didn't include the time (as i could just group by date logged) Any suggestions on the easiest way to do this?

+1

Hi, We are trying to set up a new IC for a discpline request, where we would collect all of the correct information relating to a new case. On our IC we have a field for the advisor to add the subject of the investigation which uses a data query (search all users). This is mapped to h_custom_a. I am now trying to use a node in the business process to add this person as a connection using the below set up: The variable is &[global["flowcoderefs"]["getReqInformation"]["customFieldA"]] This fails the BP with the error of Xmlmc method invocation failed for BPM invocation node 's1/flowcode-426812e6': 0200 apps addConnection FlowCode Exception (com.hornbill.servicemanager/entities/RequestConnections/fc_bpm/addConnection): nodeName: API Call: Add Connection; nodeId: 9ee2aef7-6f68-4035-8668-a94c2ff3adea; At 207/1: "Uncaught EspMethodCall::invoke: Operation[apps/com.hornbill.servicemanager/RequestConnections::addConnections] /apps/com.hornbill.servicemanager/entities/RequestConnections/fc_modules/request_connections_helper.js(217): error X1001: Uncaught TypeError: Cannot read property 'h_first_name' of undefined" throw(e); _fc_node_exec_9ee2aef7_6f68_4035_8668_a94c2ff3adea 9ee2aef7-6f68-4035-8668-a94c2ff3adea f173e935-9b04-45b5-a0e8-cc846c0a0090 What would be the reason for this?

Hi @James Ainsworth, Thanks for coming back to me. Can we please raise as an enhancement to be able to have a sort option added to the simple lists page, that would reflect where the list is being used (on the connections IC form, and on the connections action item (where you select the type of connection) or alternatively, it just reflects the order that these are entered on the simple list