Export inventory and performance data

This document describes how to export your inventory of assets, and how to export the performance data collected for the assets.

Export your inventory

Migration Center lets you generate a report of your inventory of assets. You can download the report in CSV format, or export it to a Google Sheets file in your Google Drive, which you can then share with your colleagues or customers.

Export all assets

To export all of the assets in your inventory, including servers and databases, follow these steps:

  1. In the Google Cloud console, go to the Create reports page.

    Go to Create reports

  2. In the Assets section, click Asset details export.

  3. Click the All assets tab. The page shows the total number of in scope assets to export.

  4. Click Export.

  5. After the export is complete, a dialog appears, and you see two files: one for servers, one for databases.

    • To download the files in CSV format, click Download next to each file.
    • To export your report to Google Sheets, click Export to Google Sheets. Then, when the export finishes, to view your report, click Open in Google Sheets.

This export doesn't include assets that you marked as out of scope.

Filter and export assets

If you only want to export assets that satisfy certain conditions, first filter the assets, and then export them. You must filter servers and databases separately.

  1. In the Google Cloud console, go to the Create reports page.

    Go to Create reports

  2. In the Assets section, click Asset details export.

  3. Depending on the asset type you want to export, click either the Export servers tab or Export databases tab.

  4. Use the Filter tab to select assets based on properties and values. For example, filter assets based on the OS or fit-level. You can apply multiple filters at the same time.

  5. Click Export.

  6. After the export is complete, a dialog appears, and you see one file, which corresponds to the asset type you exported.

    • To download the file in CSV format, click Download.
    • To export your report to Google Sheets, click Export to Google Sheets. Then, when the export finishes, to view your report, click Open in Google Sheets.

Export groups of assets

To export groups of assets, follow these steps:

  1. In the Google Cloud console, go to the Create reports page.

    Go to Create reports

  2. In the Assets section, click Asset details export.

  3. Click the Export groups tab. The page shows all the groups in your Migration Center project.

  4. Select the groups that you want to export, either manually, or with the Filter tab.

  5. Click Export.

  6. After the export is complete, a dialog appears, and you see two files: one for servers, one for databases in the group.

    • To download the files in CSV format, click Download next to each file.
    • To export your report to Google Sheets, click Export to Google Sheets. Then, when the export finishes, to view your report, click Open in Google Sheets.

Export out of scope assets

To export your out of scope assets, follow these steps:

  1. In the Google Cloud console, go to the Create reports page.

    Go to Create reports

  2. In the Assets section, click Asset details export.

  3. Click the All assets tab, then click the Out of scope tab. The page shows the total number of out of scope assets to export.

  4. Click Export.

  5. After the export is complete, a dialog appears, and you see two files: one for servers, one for databases.

    • To download the files in CSV format, click Download next to each file.
    • To export your report to Google Sheets, click Export to Google Sheets. Then, when the export finishes, to view your report, click Open in Google Sheets.

Export performance data

Migration Center lets you generate a report with the performance data collected from your assets with the discovery client or the mcdc CLI. You can download the report in CSV format, or export it to a Google Sheets file in your Google Drive. A performance data export contains daily aggregated metrics from your assets.

You can export metrics for the past available days, from a minimum of 10 up to a maximum of 420 days.

Export performance data for all assets

To export the performance data for all the assets in your inventory, including servers and databases, follow these steps:

  1. In the Google Cloud console, go to the Create reports page.

    Go to Create reports

  2. In the Assets section, click Performance data export.

  3. Click the All assets tab. The page shows the total number of in scope assets to export.

  4. Click Export.

  5. In the dialog that appears, select the number of days of performance data that you want to export for each asset, then click Export.

  6. After the export is complete, a dialog appears, and you see two files: one for servers, one for databases.

    • To download the files in CSV format, click Download next to each file.
    • To export your report to Google Sheets, click Export to Google Sheets. Then, when the export finishes, to view your report, click Open in Google Sheets.

This export doesn't include assets that you marked as out of scope.

Filter assets and export performance data

To limit the performance data export to selected assets, filter them first by specifying the conditions that you want to apply to your export.

  1. In the Google Cloud console, go to the Create reports page.

    Go to Create reports

  2. In the Assets section, click Performance data export.

  3. Depending on the asset type you want to export, click either the Export servers or Export databases tab.

  4. Use the Filter tab to select assets based on properties and values. For example, filter assets based on the OS or fit level. You can apply multiple filters at the same time.

  5. Click Export.

  6. In the dialog that appears, select the maximum number of days that you want to export for each asset, then click Export.

  7. After the export is complete, a dialog appears, and you see one file, which corresponds to the asset type you exported.

    • To download the file in CSV format, click Download.
    • To export your report to Google Sheets, click Export to Google Sheets. Then, when the export finishes, to view your report, click Open in Google Sheets.

Export performance data for groups of assets

To export the performance data for groups of assets, follow these steps:

  1. In the Google Cloud console, go to the Create reports page.

    Go to Create reports

  2. In the Assets section, click Performance data export.

  3. Click the Export groups tab. The page shows all the groups in your Migration Center project.

  4. Select the groups that you want to export, either manually, or with the Filter tab.

  5. Click Export.

  6. In the dialog that appears, select the maximum number of days that you want to export for each asset, then click Export.

  7. After the export is complete, a dialog appears, and you see two files: one for servers, one for databases in the group.

    • To download the files in CSV format, click Download next to each file.
    • To export your report to Google Sheets, click Export to Google Sheets. Then, when the export finishes, to view your report, click Open in Google Sheets.

View recent exported reports

Migration Center lets you view the last 100 reports that you've generated. You can't see reports generated by other users, nor reports generated in other Google Cloud projects.

What's next