Jim

Yes it has resolved 1 record, but skipped it due to being in dry run mode sounds like good progress

If you are exporting out of Hornbill and then importing back in, I would highly recommend using the asset ID instead h_asset_id

In terms of the asset matching 1. Does the CSV contain the exact same information as held in the asset tag field within hornbill? 2. Is the asset class 100% Mobile? The error you are getting is basically saying it can not find an asset that matches what is in the csv, and it can not create it as you have chosen to only update existing assets. Hope this helps you to diagnose

@LawesD The assets

I do this using the following node

I have no idea what has happened but it is so painful trying to share dashboards, its trying to fetch a list of roles I would assume? just will not work, same for users and group except they eventually resolve after 10 seconds

Could you provide the json file?

h_datelogged > curdate() - INTERVAL 6 Month

@samwoo I've not actually done this myself only a theory if I was to implement it, One thing I would probably do though is give it an extra 5 minutes so if the response time is 2 hours, tell it to notify 1hr and 55 minutes before the response time, just to allow it time to generate the event? I also have no idea how this would behave if a priority was changed on an already existing request? but on previous alerts for SLA apparently all it does it tell the process to generate the event, so it may only work on new requests and if you were to change it, it would only take affect on new requests as the event will already exist on existing request But, always a big difference between theory and practise?

@AlexOnTheHill No worries, and always learning better ways to do things!

Thank you that looks perfect, can add in the rest of my criteria now and start the measures.

@AlexOnTheHill I would use the SLA Escalation Events, lets say high priority is 2 hours response time, set the escalation event to email 2 hours before response time (making it almost notify when it's logged) This will take the automation a level higher than the workflows and hopefully achieve what you require

I have been asked to return a count of users who have not logged requests within a given date range. I've had to go back to basics on the query just to test and I'm not getting any results on this at all? select h_user_id from h_sys_accounts WHERE h_user_id NOT IN (select h_fk_user_id from h_itsm_requests) If I choose the opposite and return a distinct list of users who have logged requests, the query works but not if I choose NOT IN. Am I missing something obvious here as there are definitely accounts that have not logged requests

@Amanda Durgan Are they set as a supporting team for the service as shown here

Hi @Tina.Lapere, Could you advise what fields it is you intend to update and what the asset types are? Where will this data come from? a spreadsheet or directly from a database? For further information this may help also Asset Data Import Tool - Hornbill

from within a process

I am a little lost on the metrics for something that ought to be quite simple. I require a measure that will count the total Change requests each month and capture the change type and then I can present these in a dashboard and group by change type. The dilemma is I can't output this field if I choose itsm_requests, and if I choose itsm_changerequests I can't see the date logged field to add to the date ranging column? Why does this feel more difficult than it needs to be?

Actually, I think what you have works just removed the {{Date}} and right it as is in UTC format

I would try against a custom criteria instead kind of like this, except with your criteria instead

I have an asset form which allows users to link hardware, after this I want them to link software however the second form does not seem to load at all and I assume it is because the form is already loaded up for hardware prior, I would much rather this be separate forms that walk users through logging the request that I can set defaults on opposed to one form which most users will link hardware and then move on from

Once software has been populated in the database (h_cmdb_assets_installed_software) against an asset how do we clear it up when the software is no longer acitive? is there a way to delete records or hide them from current view? for example once we have disposed of assets the software would still show as installed on that machine. We also end up with multiple values for the same piece of software such as edge update

@SteveJM yes exactly that

maybe these will help? not sure how it works in terms of visibility mind

It's not recommended to do this by Hornbill as different classes advanced details live in specific tables to the class, but in my experience as long as its of they same class it works fine . I was able to change some computer to servers as they had uploaded incorrectly by using the csv import and overwriting the type id for each asset I need to change. but you couldn't change say type laptop to a mobile so on so forth and I have had no issues with these Hopefully this makes sense but as stated Hornbill do not recommend this.

Never mind, I figured out I could just do it in the source code