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????
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1
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.
Answered 03/01/2012 by: steelc
Senior Yellow Belt

Please log in to comment
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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
Answered 03/01/2012 by: tcunningham
Senior Yellow Belt

Please log in to comment
0
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.
Answered 03/04/2012 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity