[Request total on-hold time]

Great thanks @James Ainsworth

[Change Calendar editing]

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

 

[Request total on-hold time]

Thanks for the update @James Ainsworth

Looking forward to the  change .

Regards,

Joyce

 

[Change Calendar editing]

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

 

[FAQ Published by]

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

 

Regards,

Joyce

 

[Request total on-hold time]

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

 

 

[Exporting Asset View to CSV file]

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

[Exporting Asset View to CSV file]

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

[Request total on-hold time]

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

[Request total on-hold time]

@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

 

[Request total on-hold time]

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

[Request total on-hold time]

I have send you the BPM Definition file

 

[Request total on-hold time]

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

[Request total on-hold time]

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

[Report on Project Task update/comments]

Thanks @Victor

I have raise a ticket for it.

Regards,

Joyce

[Report on Project Task update/comments]

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

[Report on Project Task update/comments]

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

[Report on Project Task update/comments]

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

 

[Assets and corresponding linked assets report]

any update/ help please?

 

[Assets and corresponding linked assets report]

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

 

 

[Assets and corresponding linked assets report]

great will try this

[Assets and corresponding linked assets report]

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

[Document Management- Upload a file as a new version of existing file]

Great . Thanks

[Document Management- Upload a file as a new version of existing file]

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

[Link multiple tables (4 tables) in a report]

Hi @Victor, 

Great it works. Thanks.

 

Regards,

Joyce