NeilWJ

Hi Nick, Columns seem to be present as far as i can tell. How are you creating the report?

Hi Stefania, There is no feature to do that. Cheers

@JanS2000, Yes it is. You can design/edit the asset table list view and form to hide the availability column if it is of no use to you. Also in regards to another question posed by your orig post : Is there a way to update multiple records at same time instead of going into each record and updating. Via the UI there is no way to do that. You could however export existing assets to CSV and then use the asset db import tool to re-import them and setup any common field values you want to apply to them during the import (the tool support updating of existing assets). Not sure if that is something you are familiar with https://wiki.hornbill.com/index.php?title=Asset_Data_Import_Tool but worth keeping in mind if in future there is a mass asset update you would like to do. Cheers

@JanS2000, I am going to assume in the uploaded CSV file the column "availabilityState" was left blank (which is ok). So think that issue is just a UI issue, where if no value is set then it is showing "Available" instead of nothing....we will sort that out and you shouldn't need to do anything with your data. Cheers

Hi @JanS2000, In the CSV file used for the upload what is/was the "availabilityState" values set to? was it left empty?

Note if you don't have permission to do updates via the Database Direct tool then let let us know and we can organise a script to be run via our cloud team. Thanks

Hi @JanS2000, The quickest way to update the availability is to run an update statement using the admin Database Direct UI. This statement will update any retired assets to have a empty availability. update h_cmdb_assets set h_availability_state = -1 where h_operational_state = 2 Once updated you should notice the availability in asset lists is blank. Note because form data runs off cache you might notice the state when viewing asset still shows old value but once cache refreshes it will appear blank. Thanks

@Sam P Yes, assuming you are talking about Reporting via the administration view, where you select Service Manager app from top left drop down and then Reports->Reporting? Made changes to filter on the status of reports as part of the db query change so that along with being able to show/filter reports with schedules it should provide everything needed to do a decent level of filtering to see what you want to see. Cheers

Hi All, As mentioned above have worked with server team to get some API changes done. This allows us to now relate a schedule record to report record via tables rather than in the report definition. So moving forward when you update/create a report with a schedule there will be relational db link that will allow the UI to display the additional information. The server build with api changes is now live. The next step is to update UI to show that additional info. This however requires a release of our core application (includes a db query to get additional info) and the UI (to show related info). I would expect to see this within the next month. I will let you know when UI is released. Cheers

Hi @will.good, Here is the table setup to select users that do not have any roles associated to them. If you want to further filter by a specific role just add another filter on the role table and role name column. Cheers

Sorting by itemValue (value) and itemName (Default Display) has been added and will be available in Core UI build 1867 and onwards (probably 2 to 3 weeks away). Cheers

Have added in some css to make that popup box bigger. You can expect to see that filter through into live not in the next release (currently beta) but the following one. So a couple of weeks maybe 3. Core UI Build 1867 and onwards. Cheers

Hi All, Will speak to server team to see if we can get the reporting apis modified to do some scheduling service joins when getting report list so can identify which ones have a schedule as well as the last run status. I will let you know what the outcome of that discussion is. Cheers

Hi Berto, See attached image. Using table join tab set the join criteria between the two tables as custom and then user REPLACE(h_buz_activities.h_actor,"urn:sys:user:","") Cheers

Just to clarify you are actually talking about "External Approvals" yes and not normal Approvals? To report on normal approvals (where a task is created and assigned to approver) you need to report on the h_sys_tasks table (select * from h_sys_tasks where h_reference = 'bpmApproval') Cheers

Hi Martin, That is the correct table that holds the email approval info for the bpm engine.I believe the From address will only be set if you specifically put a from address in the bpm node at design time. The To field should def have data in it, if it doesn't it means the person(s) you have tried to send the auth to don't have email address setup in their user data? I have attached a test report that will join bpm instance table, email approvals table and sm requests table, it returns info as shown in screenshot. Feel free to upload that but if you are already reporting on that table i would expect you to get data. Maybe change the select criteria to do where Sent To is not empty ? see if you get any data then? So as long as you have the Sent To address you could extend the report to join onto the users table to get the users name, tel info etc bpm-email-approvals.report.txt

Hi Berto, Have added it to "Stuff To Fix" list for BPM. Should be easy enough to sort out. Look out for a FIX: in upcoming release notes of CORE UI (this is not a Service Manager issue) Cheers

Yup that shouldn't be a problem. i was wondering why that wasn't being displayed...it obviously uses a different form. Will let you know. Cheers

Hi Sam, You will need to add the wildcards yourself because is like can be used for different variations "Abc%", "%Abc" , "%Abc%" or "A%b%c%" etc Cheers

@QEHNick, Ok so that might be an issue with the actual data, we would need to check that the h_ownername (extra measure save columns) is actually being recorded. Only reason I could see no data being returned, when values order is none, is if there is actually "no data". In my test chart it does display the data as expected, if there is data to display. Can i ask that you raise a support request so we can get access to your instance as we will need to check the data capture for the measure. If you link this post in your request so Support know where to start looking. Cheers

Hi Nick, It will be because you are using a predefined date i assume as the "sampling type". Think this is a UI defect in that the option to "Group Values Order" shouldn't be available if the sampling type is set to a date. I will check with the server team to see what the api is doing to confirm that. Cheers

Hi Nick, So when set to "None" it returns data but but when to set to either of the other options it shows nothing? Will have a look but nothing has changed around this is a fair while....can you also provide the setup details of the widget so i can try copy the same setup. Cheers

@Jeremy, Update on this. It is likely the query is timing out due to the number of records in the table. Query has a timeout of 10 seconds. Discussing internally how we can improve that. I will let you know what we can do. Cheers

Hi @Jeremy, As far as i can tell this is working ok. There hasn't been any changes around this functionality for a while. You are viewing the list for the correct application right? sorry have to check :-) . That is the only thing i can think of. So assuming you are in the SM application view I assume it is empty for any of the status options "Failed/Cancelled", "Failed", Cancelled"? We will need access to your instance to take a look because it does appear to be ok on our test instances. Cheers

Hi @Ann-MarieHolloway, This is a known issue that should be resolved in next release of the Hornbill UI, which if everything goes well will be this week or next. In the mean time you can alter those options by managing the Organisation/Teams under Platform Configuration. In a team there will be a tab item showing you "Assigned Users". You can set the same options per user in team by clicking on the edit button in the users row. Takes a bit longer to do as you need to do it for each team the user is in but will get you where you need to be until the release comes out. Thanks,