You can export store usage, and store task and protection plan histories into the Excel spreadsheet (.xls) format. After choosing an export action, you will be presented with a very powerful tool for organizing the history data prior to exporting.

 

The Export Plan History action is available from several places in the Archive Manager console tree:

 

  • store - exports all plan histories that run to the currently selected store

 

  • Local Plans folder - exports all local plan histories

 

  • remote computers group folder - exports all plan histories for all computers in the currently selected group

 

  • remote computer - exports all plan histories for the currently selected computer

 

In addition to exporting plan histories, when you select a store in the console tree, you can export task histories using the Export Task History action, and you can export the store usage history with the Export Usage History action.


 

Organizing the exported data

 

After clicking an export history action, the data is displayed using some default format settings. You can customize the format in several ways. A few are described below.

 

To hide a column, right-click anywhere in that column and choose Hide Column. To show a hidden column, right-click anywhere in any column and select Column Chooser, then double-click the column you want to show.

 

Columns can be re-sized by dragging the column separator left or right, or moved by dragging the column header to another location.

 

Results can be filtered by clicking the funnel icon of a column and selecting from the list of available filters.

 

Results can be grouped by dragging a column heading to the bar just above the column headings. For example, to group data by computer name you would drag the Computer column heading to the bar just above the column headings row. You can create subgroups by dragging another column heading up above the row of column headings. To restore the view, click the 'X' in the heading or just drag the heading back down.

 

To export the formatted data to an Excel spreadsheet, click the Export button in the upper-right corner of the history page, specify a location and filename, then click Save.