Had Webhelpdesk for a couple of months now...
Wonder if anyone can help me?
We have 2 different types of asset "vehicle" and "unit" and one type is typically a child of the other (we have a unit which we build which is installed into a vehicle and we track which unit is installed on which vehicle)
We have a spreadsheet (I know, I know!!!) which I use to import the current details of the vehicles and the units which are installed on those vehicles (the units can be removed, reassigned or new installs etc) and I want to do that on a regular basis to keep the vehicle locations and the units assigned to each vehicle current and up to date. The spreadsheet is rubbish frankly but I'm unable to persuade anyone that it needs to change in the short term and I've tried to persuade them to use our new ticketing system to keep our asset records up to date?
Yeah, tried that and came up waaay short...
When assets are imported the old relationships aren't removed and replaced with the new ones, both relationships then exist (bug logged with Solarwinds)
Also, it doesn't put anything in the audit trail of the parent or child asset that is even vaguely useful when the asset record is updated (Solarwinds have added this as a feature request)
I thought I would put together an SQL script which
Takes the existing child asset number and writes it into the audit history of the parent asset
- Takes the existing parent asset id and writes it into the audit history of the child asset
- Removes the relationship completely for all assets
Reimport the complete records again with synching enabled and reestablish the relationships again
That would give us the asset history of which units have been on which vehicles and which vehicles have which units installed
We're eventually going to replace the spreadsheet with a custom db which we could script the updates from one to the other but for now I'm going to need something to keep our asset records up to date
Anyone got any advice on either
a) A better idea?
b) If there's any hurdles stopping me from doing this?