[Download from Board list]

Hi,

Is it possible to download request list from a board ? we have CAB board, and I need to get the list waiting for 'Change plan' stage, is this possible?

 

Thanks

Regards,

 

Joyce

[Report Select Distinct values]

Hi Steve, 

Thank you for this.  I saw the field as soon as i did this post.

Regards,

Joyce

[Report Select Distinct values]

Hi,

I  need to create a report for active, 'onhold' tickets, with the  current 'onhold sub-status'. I have join Request table with h_buz_activities and h_sys_accounts ( As I also require customer account division which is recorded on customer profile).

With the Buz activities table, as a ticket can be onhold multiple time, I am getting  multiple details for one ticket. How can I filter to show distinct request ID details, with the last 'Onhold sub-status'?

 

Thanks.

 

Regards,

Joyce

[Problem with reports for projects]

Apologies, found the reason for this.

[Problem with reports for projects]

@AlexTumber please help 

[Problem with reports for projects]

Hi,

On a previous created and run report, the table seems to have disappear, hence available columns are not showing. Please see screen shorts below. How can we fix this?  I can't re-add the table, as it is there , but just not displaying:

 

 Thanks.

Regards,

Joyce

[Request Last update duration, filter by analyst]

Any Assistance please?

[Request Last update duration, filter by analyst]

Hi,

I need a report where we can review how long it take for an analyst to respond to a ticket after a customer has put an update. 

So  have time since last ' analyst ' update as a filter.

I have join Request and h_buzz_activities tables, but I can't find a column to filter ' last update by who'

Thanks.

 

Regards,

Joyce

[Problem with reports]

Yes @Deen the issue was caused because the report was hitting record limit. I have reduce the  reporting period, and it worked.

 

Thanks.

 

Joyce

[Problem with reports]

This is not a new report, it was working fine before

[Problem with reports]

report-onhold.report.txt

[Problem with reports]

Hi,

My reports doesn't have any data in them. When I check preview, there some  data, but when I run a report with CSV outcome, no data appears.

Two of my reports are affected ( haven't check others).

Please investigate.

Thanks.

Regards,

Joyce

[Asset Management Reporting]

Thanks @James Ainsworth

Entity Viewer has been very useful.

 

Regards,

Joyce

[Asset Management Reporting]

Hi,

I need to create a report  with the following fields from the front end of asset management:

Name

State

Substate

Type

Used By

Owned By

Date Created

Model

Serial Number

from which table can I get state and Substate?, and how can I link them with CMDB computer Asset table?

 

Thanks.

 

Regards,

Joyce

[Approval Task set to expire automatically]

Help anyone?? @Steven Boardman

[Approval Task set to expire automatically]

Hi,

On BPM i have not set any duration for a task to expire, but when a task is created, it seems to automatically set to expire in 3 days.

 

How do I stop the task from expiring, as I have not set option to what happen when it expire ( I don't want the task to expire, only need due date as a reminder to assignee)

 

[Report auditing - How to check who/when changed or edited a report]

Great @Steven Boardman, this is a good start.

 

Regards,

 

Joyce

[Updating Linked Requests]

6 minutes ago, Paul Alexander said:

+1 for this too please......

 

[Report auditing - How to check who/when changed or edited a report]

Thanks Steve

[Report auditing - How to check who/when changed or edited a report]

Good Morning,

How can we check who change/ edit  a report and when ( not who run it)?

Thanks.

Joyce

[OnHold Sub status]

@Steven Boardman any assistance?

 

Thanks

[OnHold Sub status]

@Paul Alexander

[OnHold Sub status]

[OnHold Sub status]

Hi @Steven Boardman

We have set the BPM accordingly , but the sub status doesn't seems to be recorded

 

[OnHold Sub status]

Hi,

I would like to measure, main reason for ticket being on-hold. For that I need to report on onhold Status.

Using  Sub.status.text field from h_itsm_request I am getting some, not all.  I have two questions:

1. If a ticket has been put onHold more than once, will all Onhold sub-status be recorded  in the database, if yes, where?

2. When a ticket is put onHold by BPM no sub-status is recorded, how can we fix this?

Thanks.

Regards,

Joyce