Tools

How to export all asset data to an Excel spreadsheet in Web Help Desk

This article describes how to export all asset data to a Microsoft® Excel® spreadsheet, in Web Help Desk.

First published date

10/19/2018 5:07 PM

Last published date

4/7/2020 6:12 PM

Overview

This article provides you the information on how to export your asset data to a Microsoft Excel spreadsheet. 

Product section

Web Help Desk

Resolution

  1. Start Web Help Desk.
  2. In the toolbar, click Assets.
  3. In the Assets screen, hold the Shift key and click the checkbox in the asset header. 

    The checkbox turns Green and selects all items in the asset list. 

  4. Click Excel.
  5. Save the Asset_export.xls file to your hard drive or other location.

Connections may timeout if exporting large quantities of assets (for example, 30,000 assets). If so, try exporting assets in batches. In WHD 12.6, a flag was added to the Casper 9 plugin to resolve the timeout, as configured in the VM options section of wrapper.template.conf. The default value is 10,000 milliseconds.

Here are the JVM arguments for the flag:

  • Windows: wrapper.java.additional.XX=-DWHDCasperReadTimeout=<value>
  • Linux, Mac: JAVA_OPTS="-DWHDCasperReadTimeout=<value>"