Exporting the hardware console as a spreadsheet

The Hardware console in Lifecycle Manager not only facilitates viewing and managing these assets but also offers export functionalities to assist with reporting and sharing asset information. This article walks you through exporting data from the Hardware console, ensuring you can share and utilize this data effectively in various contexts.

Accessing export functions in the Hardware console

The Hardware console is a central hub for all your hardware management needs. Here’s how you can use its export features to enhance your workflow:

  • Open the hardware console:
    • Click on Assets and then click All Hardware located on the Top menu of Lifecycle Manager.

Customizing and Exporting Hardware Data

Exporting configured data for specific needs

  • Creating configurations:
    • You may need to tailor the hardware data for specific projects, such as preparing for Windows 11 updates, planning hardware modernization, or managing warranty renewals. Set up your console with filters and columns that match these specific needs.
  • Exporting data:
    • Once your filters and columns are set:
      • Click the Spreadsheet button on the right-hand side of the screen.
      • Choose to export the results with visible columns or all columns, depending on the depth of data required.
      • Select the appropriate file format:
        • CSV File: Opt for this format if the export includes more than 5000 assets.
        • Excel Spreadsheet: Use this for exports with up to 5000 assets, providing a more structured format for data manipulation.

Downloading a comprehensive hardware report

  • Full data download:
    • If you need a comprehensive view of all available data, adjust your filters as needed and use the full-column export option. This is ideal for offline analysis or when preparing detailed reports for management or client discussions.

Generally, as long as you have added an RMM integration to Lifecycle Manager, the Processor Manufacturer, Processor Model; Memory (GB); and Total Storage (GB) asset information is available in the downloaded spreadsheet.

Legacy data and compliance

Accessing Legacy hardware report

If you had previously set up per-client hardware replacement standards, you can download a legacy hardware console export to continue to see whether those clients’ devices are compliant with hardware replacement standards or not.

The legacy export doesn't use customized filters or columns.

  1. Click the Spreadsheet button

  2. Under Download the previous Hardware export, select Excel spreadsheet to download the data without the customized filters or columns used in regular exports.

Sharing exported data

  • Collaboration and reporting:
    • Exported data can be shared internally within your team or externally with clients to facilitate discussions, planning, and decision-making.