Systems Management Question

k1000 inventory exporting to xls/spreadsheet

08/27/2018 1816 views
So my job requires a lot of the Asset section for k1000 devices to be filled out (purchase date, funding, etc), and I believe the easiest way to fill these in would be to export the current new devices to a spreadsheet, updating this info, then importing it back to k1000. 

I can see where to IMPORT files to K1000 for inventory purposes, but how do I EXPORT a list of new devices to update by spreadsheet, then import those back into their KACE destination? And am I correct in thinking the import would update the device/asset information as long as the computer names lined up?

Side question: The Asset Tag section is still not showing up, even though the BIOS has it entered. Any way to detect them through KACE? If not, I'll just use the asset column from my manual spreadsheet.
0 Comments   [ + ] Show comments


Community Chosen Answer

If I understand your question correctly, you need to update asset information for your devices. To do this, you would simply export the Device Assets from Assets->Assets page in to csv format, update the csv with new fields, then import the assets back from the Asset import wizard. 
Answered 08/27/2018 by: AbhayR
Red Belt

  • Now I see it, under the Choose Action button... the export only takes the 8 columns displayed in Asset search. If I title my excel columns exactly as within the Asset itself (i.e "Asset Tag (Asset)), will Kace automatically parse that info when I import?
    • I'm not sure, did you test it? The documentation says says to verify "equivalent Asset Fields in the Asset Type" so I think you're correct.

All Answers


If you change the "View by Filter" on the asset list page to Devices, you will see more fields to show on the list page. You can then enable more fields to show and export them

Answered 11/26/2018 by: AbhayR
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