/build/static/layout/Breadcrumb_cap_w.png

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

0 Comments   [ + ] Show comments

Answers (3)

Posted by: steelc 12 years ago
Senior Yellow Belt
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.
Posted by: tcunningham 12 years ago
Senior Yellow Belt
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
Posted by: GillySpy 12 years ago
7th Degree Black Belt
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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