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,

Answer Summary:
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



Those things show up in the Inventory section and not the asset area. Do your assets match computers in the inventory?

Answered 10/11/2012 by: chucksteel
Red Belt

  • 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.
  • 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:
    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.
  • I guess there is no easy way of doing this - thanks for all the info.
Please log in to comment