chriscorcoran

Hi When a call comes of hold we see the date 1970 listed in the views, see attached, any ideas? Regards Chris

Thanks cchana, I added the columns but I'm getting weird results, not sure what I'm missing, see below. Chris

Hi Just following on from the above, I have added some customer contact details from the h_sys_contact table but I'm getting odd results seeing the call repeated loads of times with the wrong customer Attached are my tables

Hi Is there a data dictionary available, also does anyone know which table contacts customer contact firstname and lastname? Thanks Chris

cchana perfect, good spot, works a treat now. Thanks all for you help on this. Chris

Hi Yes, spotted when I posted, corrected but the same 1031377 2016-06-21 16:04:35 error database 2784 Report definition specified is not correct, It results in an invalid sql : SELECT h_itsm_requests.h_pk_reference,h_itsm_requests.h_summary,h_itsm_requests.h_fk_user_name,h_sys_tasks.h_time_spent FROM h_itsm_requests LEFT JOIN h_sys_tasks ON h_sys_tasks.h_obj_ref_urn = 'CONCAT("urn:sys:entity:com.hornbill.servicemanager:Requests:",h_itsm_requests.h_pk_reference)' OR WHERE h_itsm_requests.h_fk_serviceid = '22' LIMIT 500

Hi I tried the above but keep getting an error, report definition specified is not correct, it results in an invalid sql see report details below.

Hi We have a activity that allows users to put in the time they have spent on fixing a call, do you know if you can report on this and which table I would need to use. Thanks Chris

I have done some more testing and it only seems to happen through the Hornbill app. I can open he message attachment from the original email outside of Hornbill. Seems to be any .msg files

Hi I have noticed that a number of people use th drop down > more actions to view an email from the timeline and then in that window click reply as this gives them the functionality to format text, underline etc etc, which is perfect. The issue is the email that is sent is not in the timeline, so we have no proof the email has been sent to the user. I guess its because it uses the system mailbox to send? Thanks Chris

Thanks guys for the suggestions, worked a treat

Might be a good feature, unless there is a way already? When you respond to a call via email it would be good to have option to add original call summary or call details as often users find that they get emails from support staffd with a ref in the subject but cant remember what the call was about unless they login to the portal or search through emails. Thanks Chris

Hi we are having issues when people email in with msg (email) attachments, we get the error shown, is this a bug? Thanks Chris

Hi When a call is logged and has attachments the emails show in the attachments section, further updates by email with attachments stay with the email and its hard to identify if that update has an attachment, see example below, you have to view every update and check if it has attachments, would be useful to have a paperclip or something to show that the update has an attachment.

Thanks for the response, We use External ref already. We wanted another field for internal use.

Hi I need to add a new custom field for all services called Internal Ref, just like the one called External Ref under call details, see attached, what's the best way to do this? Thanks Chris

Thanks Steve, useful info, I will look at the business process and run some tests on what you have suggested.

Does anyone know if its possible to link priorities with a service, at the moment we have a long list of priorities for all our products and sometimes people select the wrong priority. Thanks Chris

Hi We find that some of our service desk analysts log calls against the wrong service, is it possible to change the service? It would be good if you could almost jump back stages in the business process. Chris

It was these two

Hi could anyone tell me the difference between the update team (with a team icon) and the update team (with a world icon)

Hi Is it possible to publish documents from libraries or collections to customers portals? Thanks Chris

Hi I have created a new progressive capture process for internal staff to use when ordering buffets for meetings through the service portal. I've use custom forms in the business process to ask for the following questions. Date & Time Required: No. of People: Location: Job Number: Authoriser: Special Requirements: When the call is logged it shows in the service desk under the Questions section, this is fine but in email the customer gets they don't see what they have logged as I cant find the variables for the questions I have asked in the progress capture custom form, see attached screenshots

Thanks Dave much appreciated. Chris

Thanks Steven for the response, It is a few customers where we have this scenario. I will test the connections functionality and report back. Chris