Joyce

Great thanks @James Ainsworth

Hi James, I just want a basic use of the calendar, like the way we use on phone for example, be able to click on the date, and add an event ( planned maintenance), so when someone is scheduling another change, can see the change/ maintenance window already there. I don't want to use freeze date, as that prevent scheduling of any other change. So something similar to freeze dates, but users can still schedule things with it. Thanks. Regards, Joyce

Thanks for the update @James Ainsworth Looking forward to the change . Regards, Joyce

Hi, I am aware there is an ongoing change for improving Change Calendar. I would like to know what is the scope for this. We have pre-schedule maintenance date, which we agree with the business 6 month in advance. I would like a way to add these dates to the change calendar without login a ticket, so that when other people are planning changes, they can see these on the calendar hence either avoid the dates, or combine there changes with schedule maintenance. The dates are every other week, either on Thursday or over the weekend. Thanks. Regards, Joyce

Thanks for the update @James Ainsworth. This will be useful when reviewing the quality of our FAQs. Regards, Joyce

Hi @James Ainsworth , I would like to officially request for a change, to calculate 'Request.Total.Onhold.Time' for a ticket even if it was closed while still onhold. As we have more than 200 BPM which close tickets automatically, we should rather not spend time changing all these BPMs. Please advise if this is possible, and the time scale for this change to be implemented. Thanks. Kind Regards, Joyce

Thanks @Victor. Didn't think was that easy. I was trying to join tables Still it will be nice if we can export from Asset view, or be able to create various view, like on request. Has this been requested? Regards, Joyce

Hi, How can I export the Asset view, from Asset Manager, to a csv file? If this is not possible where/which table is this view pulling from: Thanks. Regards, Joyce

@Paul Alexander this is my thread. Feel free to comment

@Victor Thank you for this. Our Hornbill Support analyst will not like me, when I have to ask for the changes on the BPMs. Is there any other way of getting the total Onhold ( maybe a back end code on resolution node to take ticket offhold during resolution)? we have a lot of BPM which closed automatically. Regards, Joyce

This is just one of the process. We have a few process, which get resolved autocratically by tasks.

I have send you the BPM Definition file

Hi Victor, Yes I think so, they get resolved automatically by completing the last task. This could be done while onhold. So will this be the reason why the field is not populated? Regards, Joyce

Hi, Does Request.Total.Onhold.Time field on table h_itsm_requests contain the total seconds that a request has been placed on Hold? If so, why are some of our request which has been placed on hold, have no value on this field? If it isn't is there another field which record the total duration a ticket has been on hold so far? All the above ticket have been resolved, so i was expecting to see values on total onhold time. Thanks. Regards, Joyce

Thanks @Victor I have raise a ticket for it. Regards, Joyce

Hi Alex, I am uploading my report definition. Please review. For the specific filtered task, I have add comments on them on the inteface. One of the comments says; Testing for my report. where is this field?" as per the screenshot. Please advise how do I retrieve this comment on my report Project Task report.txt

Hi Alex, I have join table h_buz_activities , and use h_buz_activities>Content Preview , but the details are from the overall project update and Not specific Task in a project. Then I have join h_buz_comments, but all the field I could think of which might have the 'Comments' are empty ( ei, h_buz_comments->Comment) this field is empty. Which field has the actual 'comments' from individual tasks, from those two tables? h_sys_tasks->Outcome Answers, and h_sys_tasks->Task Answers are also empty Thanks. Regards, Joyce

Hi, Where ( in which table and field) are comments for project task recorded? Sys_Task outcome answer or Sys_task answer:P Thanks. Regards, Joyce

any update/ help please?

Hi Pamela, This is only returning the whole list of assets, I need the relationship/ link between the assets. Can this be done as a sql schema design, to have that link? Thanks. Regards Joyce

great will try this

Hi @Victor I am trying to create a simple data list report of assets, and their corresponding linked assets. So we have, for example, a site as an asset, which is then linked to riverbed ( which is also an assets), which in turn linked to a switch. So I am looking for some kind of a report which could give me a list of sites, and what is linked with them. Site asset type- 19 ( BAsic) Linked assets as Network device type assets Thanks. Regards, Joyce

Great . Thanks

Hi, Is there a way to upload a file, as a version of an existing file? A have a file in one of my document, I can create version of this file through report scheduling, but at the moment, the report is missing some date, hence I have to download the CSV correct it, then trying to upload it as a new version of the existing file. Is there a way to do this

Hi @Victor, Great it works. Thanks. Regards, Joyce