Joyce

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

Hi Steve, Thank you for this. I saw the field as soon as i did this post. Regards, Joyce

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

Apologies, found the reason for this.

@AlexTumber please help

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

Any Assistance please?

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

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

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

report-onhold.report.txt

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

Thanks @James Ainsworth Entity Viewer has been very useful. Regards, Joyce

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

Help anyone?? @Steven Boardman

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)

Great @Steven Boardman, this is a good start. Regards, Joyce

Thanks Steve

Good Morning, How can we check who change/ edit a report and when ( not who run it)? Thanks. Joyce

@Steven Boardman any assistance? Thanks

@Paul Alexander

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

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