Systems Management Question

Why can't I use the Asset Unique ID as a Primary Key for Asset Import?

10/20/2020 148 views

I would have thought that using the Asset ID would be an ideal Primary Key to use when bulk updating/manipulating existing Device Asset records via Asset Import.  I mean, isn't the Asset ID the actual primary Primary Key, after all?  Am I missing something important here?  I find myself faced with the task of having to bulk manipulate about 29,000 Device Asset records (cruft from previous decades) that are in quite a messy state.

1 Comment   [ + ] Show comment


  • I find that really odd as well. Would be nice to know why we have it if it can't be used.

All Answers


If you have the unique Asset ID in your CSV then you can certainly use it as the primary key, but you would need to create it as an editable field and setup a ticket rule to sync the data. Then at the 3rd stage of the import you get to tick the keys that you want to be primary and the “fake” ID key would be available.

However for most people managing assets using any decent system the Database assigned Asset ID is irrelevant and the key field that matters most is the asset number or serial number that can be scanned or seen, which is not possible with an ID number automatically assigned by a system whenever a new asset is created, if that makes any sense??

Answered 10/21/2020 by: Hobbsy
Red Belt

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ