Jump to content

mojahidm

Hornbill Users
  • Posts

    163
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by mojahidm

  1. Hi team,

    I have a rather urgent issue  that we just noticed and I was hoping for some assistance. We are planning to go live with UK this week and because it works a little differently hadn't noticed a particular snag.

    Only certain individuals are allowed to raise Service Requests. We wanted to limit visibility for this and the catalog visibility option appeared to be exactly what we needed. 

    However, we noticed that if the organisation the individual is at is excluded from viewing the catalog item, then the individual cannot see it either:

    image.png

    The Mojahid Darlington account cannot see the 'Create Report' Catalog Item, unless the Darlington organisation is set to Included as well. This would mean that all others within the Darlington organisation would be able to view the Service Request CI.

    It makes sense, as the deny rule would take precedence over the allow rule, but it does throw a snag in how we were hoping to work.

    Is there any advice that you can give to us as a workaround? We have a lot of organisations with a good number of contacts in them. It isn't really feasible to have all contacts within an organisation added to the service and then excluding the ones that shouldn't be able to view the SR CIs, which is the only workaround I could think of...

    Many Thanks,

    Mojahid

  2. Hi Team,

    I was hoping someone might be able to advise me on how to get a list of subscribers to a particular service?

    There's the ServiceSubcriptions table

    image.png.ee8e61a1a566854965d53715f706fc5b.png

    but it has no relationship that I can see.

    The 'Subscriber ID' looks like the foreign key, but I've not been able to find which table it links to so that I can pull through the subscribers details (such as the organisations and contacts)

    Many Thanks,

    Mojahid

  3. Hi Team,

    Would you be able to advise me if it is possible to create a measure for incidents that were logged in a particular month and not completed by the end of the month (i.e. outstanding incidents)?

    I've been able to create one by having the 'Query where clause' check to see if h_dateresolved IS NULL

    image.thumb.png.27636b690e40541431ce1a024a3d36ab.png

    But i would imagine that it will pull through cancelled requests and that the next month the h_dateresolved would have an entry in it. Which would mean that if we ever had to resample the data for any reason, the stats would no longer be correct

    Currently displays as expected:

    image.png.ecd98cdcd8a31883ac1cc22a13d17fd6.png

    But if Sandbox 1c is ever resampled, we'd loose the data :-(

    kind regards,

    Mojahid

  4. Hi @James Ainsworth

    The intended audience that would need to see when the Service Requests are going to be fulfilled would be a group of analysts (i.e. Servicedesk UK). The reason behind this is that currently, external customers will raise Service Requests asking us to make amendments to their system. For example, a change in the pricing of sales items, entering a closed date, creating a new category. Quite often, these changes have to be scheduled and cannot be completed until a particular day, such as after a bank holiday or when a new promotional deal becomes active. Different analysts will action these Service Requests and the idea behind the calendar is that we can have a view of all Service Requests on a particular day, thereby being able to cover for anyone who is off sick (Someone else could pick up the scheduled SR Work).

    As you mentioned, the higher impact and more complex work would go through the change process, but changing 10p to 30p on a particular day would be raised as a SR by our external customers.

    This is a nice option to have, rather than a must and therefore something I'd like to bring to Hornbill's attention if any discussions for future improvements regarding the change calendar occurs :-)

    Kind Regards,
    Mojahid

    • Like 1
  5. Hi,

    Do you know if it is possible to have multiple counts and multiple group by in reports?

    The SQL I have is:

    select h_fk_servicename, count(h_fk_servicename) as 'No. of Service', h_catalog, count(h_catalog) as 'No. of Catalog', h_category, count(h_category) as 'No. of Request Category'
    from h_itsm_requests
    where h_datelogged between '18-07-01' and '18-10-03'
    and h_fk_team_name = 'Servicedesk UK'
    and h_container_id = 68
    group by h_fk_servicename, h_catalog, h_category
    order by count(h_category) desc

    image.thumb.png.b3b057a8c77fac3d25d1872be9a21cbf.png

    and I'm trying to get it to run as a report, but you only seem to be able to choose one column to count and Group By:

    image.thumb.png.703773783766c4bd070286748408c862.png

    Mojahid

    Side Note: Working on a report that will let me see the Top 10 Request Categories, showing me the ServiceName, CatalogName and RequestCategory

     

  6. Hi,

    I'm trying to create a report using the h_itsm_requests.h_fixtime as a way of calculating how long it takes to resolve a incident

    I created some test tickets and then resolved them same day, one day later, two days later, three days later and 4 days later.

    I expected the h_fixtime to reflect the time in seconds it took to get the ticket resolved, but it seems to be off by a lot

    For example,

    I expected the below h_fixtime to be 574,303  instead of 131498:

    image.thumb.png.2b6454b091edcd89a26515318a0ee965.png

    I did also notice that the h_dateresolved time is behind by an hour. I would have resolved the ticket at 8:56:21 rather than 7:56:21

    I've also checked the resolve timer start and stop and it appears to be okay in that it starts the timer and ends it when expected. I tested this by looking at the h_itsm_request_sla_targets table

    image.thumb.png.3d98d52b38054a56d4544b3d4c8daded.png

    The time here is correct.

    but the h_target_completed_duration is confusing me

    I can't understand how it is being calculated

    kind regards,

    Mojahid

  7. Hi,

    during one of our meetings it was raised that as a user when an incident is created from a service and the support analyst opens it, we have to go down to edit the ticket details to set Request Category. We would prefer to select Request Category from the Action bar, same as Priority.

    I'm not sure if this is already possible, but if not can this be considered as a Request for Enhancement?

    Many thanks,

    Mojahid

  8. Hi,

    A while back I set up the Service Levels and last Wednesday it was working with no issues

    However, when I logged an incident on Monday (03/09/18) the default service level was no longer being set.

    I have a vague recollection of creating the SLA in the Services SLA tab

    image.png.0276bd1bd3f73e57166b0a084eb34350.png

    and then there would be a corresponding one that got created in the main SLA tab

    image.png.20ee44a09d0228fb74e0ff3e83037019.png

    The above is a screenshot when I was trying to figure out how to set a default SLA

    ArteMIS is the Service.

    When I now go into the main SLA tab:

    image.png.4f49e1c5d642aadf1d4938130647e219.png

    The 'no service level select' is no longer there and I cannot recreate it

    Mojahid

  9. Hi,

    I've searched around, but I've been unable to find an answer to a question a colleague has asked regarding the ability to amend an update in an incident:

    image.png.5f9700d66287734da1f41ff8df727d34.png

    I get the following options:

    image.png.adaf2276fb5807309ee553ea6bde865c.png

    This would be required in the event that an Update is in error i.e we've later found out that the information in the Update isn't correct, so we go back and amend it

    Kind regards,

    Mojahid

  10. When a customer is within a ticket and they wish to upload an image, they will need to add text. Otherwise the 'Update' button is greyed out

    Reproducible steps

    Log into customer portal > Go into a ticket > In update tab - Upload Image > 'Update' is greyed out, unless you add some text.

    image.png.8cefea7485f544b790754ebd2f7eb0f0.pngimage.png.4e5a2967fc21184e63a7943f19f78306.png image.png.6f2a3814e0ca4cab4328421c2f047cb6.png

    I'm not sure if this is by design, but it could confuse customers when they try to upload an image and not realise that they than need to add text for the 'Update' button to be active

    kind regards,

    Mojahid

×
×
  • Create New...