Exporting Assets with all their Fields
My IT Director is wanting me to re-organise the non-computer Asset Types into their own Asset Types ie Monitors, Phones etc.
Some-one else created the Non-Computer Asset Type and this has been populating to about 400 records each containing about 15 fields.
The problem I have is when I export the Assets it only exports the 6 columns that you see in that Assets Types default view being the 1st 6 fields in that asset type.
How do I export the assets containing all the fields????
Some-one else created the Non-Computer Asset Type and this has been populating to about 400 records each containing about 15 fields.
The problem I have is when I export the Assets it only exports the 6 columns that you see in that Assets Types default view being the 1st 6 fields in that asset type.
How do I export the assets containing all the fields????
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
steelc
12 years ago
Create a report based on that asset type and be sure to include all of the fields, then run that report with the CSV option.
Posted by:
tcunningham
12 years ago
OMG you sir are a life saver - so now I can filter and amend in excel and import each Category into it's own Asset Type
Posted by:
GillySpy
12 years ago
post #2 is what you want, but...if you are using excel regularly you could setup an ODBC connector and have excel pull data in when loaded.
http://www.kace.com/support/kb/index.php?action=artikel&cat=9&id=9&artlang=en
You'll have to give the SQL to Excel and setup a DSN in the PCs' ODBC administrator.
http://www.kace.com/support/kb/index.php?action=artikel&cat=9&id=9&artlang=en
You'll have to give the SQL to Excel and setup a DSN in the PCs' ODBC administrator.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.