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


Please log in to comment

Community Chosen Answer

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.


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
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.

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