k1000 inventory exporting to xls/spreadsheet
08/27/2018 451 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.
Community Chosen Answer
Please log in to 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