[Previous Report History]

Hi,

 We have notice on report history, previous reports from before 2020 are no longer available. 

 

Are previous years report copies removed from report history? if so if we require a copy of previous run report how can they be accessible?

 

Thanks.

Regards,

Joyce

 

 

[Overall Project Risk Weighting]

Hi Alex,

Ok thank you for your prompt reply.

Regards,

Joyce

[Overall Project Risk Weighting]

Hi,

How is the value Overall Project Risk Weighting  on project view page calculated? is this value stored in the database? if so which table and which column?

We need to add it on our PowerBi report.

Thanks.

Joyce

 

 

[BPM task automatic setting expire date]

I have manage to fix the current BPM by adding the brunch ( Second time try).

Why is the BPM setting expire date even though it is not specified on the task settings?

Thanks.

 

Regards,

Joyce

[BPM task automatic setting expire date]

Hi,

I have not set task expire date on BPM but for some reasons the system seems to set expire date when a human task is created. This is affecting the ticket, as if the task ( which is approval) is not completed in time, the BPM failed ( I have not set option to brunch out when task expires as didn't expect for it to expire);;

How can I stop the task from setting expiry date? as I don't want it to expire.

Now the BPM is broke, how can I fix it  ( tried to add brunch for expire but didn't work).

 

Thanks.

 

Regards.

Joyce

 

 

[Software Assets Users Report]

Thanks. This has been resolved, there were discrepancy on the data.

 

Regards,

Joyce

[Software Assets Users Report]

Thanks for this, but the result doesn't still bring all the email address from h_sys_Account

[Software Assets Users Report]

Hi @ArmandoDM,

Can you assist with the query for joining h_sys_accounts using h_user_id and CMDB Assets Trimming the URN from the h_used_by?

I am trying Trim function but, is not working. I do remember a previous report where similar query was used, but I can't find the details for it.

Thanks

Joyce

[Software Assets Users Report]

h_cmdb_assets_users doesn't seems to have any data

[Software Assets Users Report]

Hi @ArmandoDM

Join of h_cmdb_assets , h_cmdb_assets_users ( left Join using Asset ID) and h_sys_accounts. ( left join with h_cmdb_assets_users  using User ID), does not return any value from h_sys_accounts table. The results, only have a list of assets_Name.

 

How else can I join these tables to get users' email address as well as Asset name and Tag?

Thanks.

 

Regards,

Joyce

 

 

[Software Assets Users Report]

Hi,

I am trying to get a report of users of various software, but retrive their email address instead of user name/ user ID.

I have join table CMDB Assets and h_sys_accounts to obtain users' email address, but I only get half of the email address, although every user has their email when look from: https://admin.hornbill.com/Inst/accounts/users

Where does the info on https://admin.hornbill.com/inst/accounts/users come from?

Thanks.

Regards,

Joyce

 

 

[Previous years data on Measures]

Hi @Bob Dickinson

This does make sense, and I did suspect might be the reason for zero values.

I will try your suggestion, and see ho it goes.

Thanks.

Regards,

Joyce

 

[Previous years data on Measures]

Hi @Deen

Any suggestions?

Thanks. Joyce

[Previous years data on Measures]

Hi Dean,

 

The team name has not change since the beginning. My suspicion is on the cut off point for data which can be accessed from 'Measures'. When re-sampling measure data, it only goes as back as 01st Jan 2019 .

[Previous years data on Measures]

Hi,

I am trying to create a measure to count amount of tickets opened per month for various years (2017, 2018, 2019) to compare the growth in demand.

When I set a measure as follows, for 2017- no data can be found. Are previous data not available on the application for dashboard purposes?

 

If I change the dates for 2019, I can the values as expected:

 

[Issues Gateway 500]

@Darren Rose and @Paul Alexander Other people are experiencing the  same issues.

[Issues Gateway 500]

We have been experiencing the same issues, since yesterday intermittently. 

[Problem with Service Manager getting file error]

Hi, is anyone having issue with their instance? 

We are having the below error, we can't do anything

Thanks.

[Approval by Role]

Hi Steven, thank you for this. 

 

I will test it.

 

Regards,

Joyce

[Approval by Role]

Hi Steve,

 

Which node is that? as the approval node i have do not have the options above:

[Approval by Role]

Hi,

What are the possibility of  being able to set approvers on Approval node by roles?

For change request, I have created different roles which have up to 3 users, so that one of them should be able to approve ( and not all of them have to).

At the moment, I have to add individual users, and have to work out the percentages to get three right approval. It will be easier to set up by role ( eg, Infrastructure Engineer, IT Security, Service delivery), so anyone withing a team can approve the change.

Thanks.

 

Regards,

Joyce

[Report on Reason for Onhold]

HI,

I have manage to get the tables. I have join Request table, with h_buz_activity_streams and h_buz_activity.

Now the problem is I am getting multiple rows, for multiple onhold update.

The only different is the date and time the update are published. How can I filter for only the latest update to show?

Thanks.

Regards,

Joyce

[Request total onhold time]

@Gemma Morrison out of curiosity, does all your request which have been on hold during the ticket lifecycle, shows the total onhold time?

 

This is not the case with our report ( some have the time, and some don't)  just wanted to check if it is only happening in our Instance.

Apologies I don't have answer for your question above.

Thanks.

Joyce

[Report on Reason for Onhold]

Hi,

I am trying to pull the reason from 'Onhold status' is this recorded in any table?

I will need to filter for the last onhold reason ( only if the ticket is still onhold).

What is the best way to get this information?

Thanks.

Regards,

Joyce

 

[Download from Board list]

Hi James,

 

Yes, I am using the old service manager board, and was hopping to download the list in CSV format.

The problem I have for reporting, is to do with which task is currently waiting on the ticket ( I am moving the ticket on different list depending with the task on BPM), hence a reporting is a bit more tricky.

 

Thanks.

 

Regards,

Joyce