Asset Management
I am trying to figure out if there is a way I can populate more info on the computer asset tab. So far I have been able to only get computer name and Service tag to populate. I would like get Computer name, System Model, and ship date.
Thank You,
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
11 years ago
Those things show up in the Inventory section and not the asset area. Do your assets match computers in the inventory?
Comments:
-
I know those are in the inventory but was wondering if there is way to populate some information from inventory to asset. Yes my assets match the computers in inventory. - bozadmin 11 years ago
-
If you want to automate it you could conceivably create a rule in the service desk. It's not intuitive but you can have rules in the service desk that act on things other than tickets. The trick to it is that the select query that runs as part of the rule returns the ID column as a TICKET_IDS variable that you can use in the update query. So, if you had a select query with something like:
SELECT ID FROM ASSET WHERE ASSET_TYPE_ID = 5
you would get a TICKET_IDS variable populated with all of the assets with the computer type (type id of 5 is for computers on my KBOX). You could then run an update query that acts on these IDs. I wouldn't recommend doing that exactly, since you should create a select query that's more specific to what needs updated. It gets complicated since the asset data fields are stored in the ASSET_DATA_5 table so there are some joins necessary.
The less technical solution is to create a report from the inventory that includes the fields you want added to the inventory and running an import with the results of that report. When you import you can specify a primary key (probably serial number aka the asset name) so that records will be updated instead of creating new assets. - chucksteel 11 years ago -
I guess there is no easy way of doing this - thanks for all the info. - bozadmin 11 years ago
