Jump to content

mojahidm

Hornbill Users
  • Posts

    163
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by mojahidm

  1. Hi,

    Is there a way to archive the standard reports, in a similar manner to how contacts are archived?

    We have some reports that are no longer required, but we wanted to keep them on the system for a bit longer (around 6 months) before deleting them permanently. There are some reports that are a snapshot of tickets that were open at the beginning of a particular month, otherwise it would be possible to run the reports with a different date range if we required them again.

    Kind regards,

    Mojahid

  2. Additional Note - Example of going from In-progress status to sub-status with on hold function

    image.png.bd1c8547e5a02f53869346c9daffcecd.png

    No Reason is needed, no reminder needs to be set and default visibility can be customer for this sub-status. It adds an additional step that once or twice is fine, but when we're using this on a regular basis and going through a number of tickets can be cumbersome...

  3. Hi team,

    One of our users advised that the system had too many dialog boxes. When we're working and trying to get work done as efficiently as possible, having those extra clicks can slow us down :-(

    Following a discussion, we were wondering if it is possible to have a setting that allowed us to choose whether or not a dialog box would pop up.

    The key ones are:

    1. When putting a ticket on hold, having the option to directly put it on hold without the popup boxing asking for the reason. The reason can be put on the timeline before or after putting the ticket on hold. As for visibility, again if there was a setting that lets us decide if we want it to default to be visible for customer or not.

    2. When changing the ticket from on-hold to In-progress . I believe this is sub-statuses that we have set up, but the option to not have a dialog box pop up when changing sub-statuses

    3. When re-opening a ticket. More often then not, the full details are put onto the next update

    Many thanks,

    Mojahid

  4. Hi team,

    One of our users enquired if it was possible to attach a file at the point of resolving a ticket?

    Currently, when you resolve a ticket you see the below:

    image.png.17df250a6a86735b2acccb33d43ad675.png

    Once the 'Resolve' button is clicked, an automatic email is sent to the customer as per our BPM process. Far as we know, there isn't a way of having an 'Add an Attachment' option here, but we wanted to double check with yourselves and if not possible, is there a possibility of a RFE for it? Or if you knew of a workaround...

    Many thanks,

    Mojahid

    • Like 1
  5. Hi team,

    I'm not sure if this is possible, but can you limit the number of bars that show up on a graph?

    For instance, we have someone who is trying to create a graph (from a view) where it displays organisations and the number of tickets they have logged. However, due to the number of organisations, it looks a mess. Therefore, they asked if there is a way to limit it to the top 10 organisations with the most tickets. Is this something that is possible with views and their charts?

    Many Thanks,

    Mojahid

  6. Hi Team,

    I was wondering if it is possible to have a pre-timeout message on the Customer Portal.

    One of our customers was enquiring if it is possible and it didn't seem like a bad idea. I've seen it in other applications and wanted to know if it was feasible for Hornbill ITSM?

    Many Thanks,

    Mojahid

    • Like 1
  7. Hi Team,

    I'm working on a report where Managers want to know the following information:

    How many incidents/Service Requests/Change Requests were logged/resolved/are outstanding for each service?

    Something like the following:

    image.png.d236385b34d409d93558cde6caf27f40.png

    Or anything similar that can answer the question.

    As far as I'm aware, it wouldn't be possible to do using Standard Reports, but I wanted to confirm (It has to be Standard Reports so that we can publish to a library.)

    The only way I can think to do this is to have multiple reports

    A report that displays all services for a particular Request Type and a particular Ticket Status

    image.png.5b55780f04d8bb57ecb14eee28bf7cd8.png

    But of course this would require a good number of reports

    The other idea I had was to get the data that is required, publish it and then the end user would have to put it into a Pivot Table. This isn't ideal as the Managers want to be able to just view it without having to learn and understand how Pivot Tables work

    Hoping you might have some ideas...

    Mojahid

  8. Hi Team,

    I'm currently working on trying to get number of services by request types

    I've got the following code:

    SELECT h_fk_servicename,
    SUM (CASE WHEN h_requesttype = 'Incident' THEN 1 ELSE 0 END) AS incident
    FROM h_itsm_requests
    WHERE h_datelogged between '19-01-01' AND '19-01-31'
    GROUP BY h_fk_servicename

    and when I run it I get the following error:

    image.png.48566de77dcfdd0795a1ba34e1b8eaae.png

    I was wondering if you might be able to shed some light on this.

    I'm trying to see if I can get a count to work in a CASE statement.

    Many thanks,

    Mojahid

  9. Hi Team,

    A report that was running fine with no issues, suddenly stopped working on 20/02/2019

    I get the below error:

    image.png.36644afd0d7b87e161f5c8df9c3ee9b8.png

    What did the 'Error running PDF Generator Tool' refer to?

    Other reports are running fine

    I've manually tried to run this report and I get the same error

    Many Thanks

    Mojahid

  10. Hi Team,

    Is there a way to manage Catalog Item visibility for contacts other than adding them in one by one?

    The scenario is that I have around 300 out of 1000 contacts that need to have access to a particular Catalog item:

    image.png.5d2b4abcbeac360e141e9e2ceaac5003.png

    I can use contact to add them in one by one - but every time I add a new CI, I have to do the same thing again and it takes far too long

    I cannot use Organization as not everyone from a particular Organization is amongst the 300. (Only certain people in an organization have access to certain Service Request CIs as they are authorized within an organization to request for reports to be created, new users, etc)

    Many Thanks,

    Mojahid

×
×
  • Create New...