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 as a CSV file or a Microsoft Excel spreadsheet, 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:
In the Google Cloud console, go to the Create reports page.
In the Assets section, click Asset details export.
Click the All assets tab. The page shows the total number of in scope assets to export. Choose if you want to export servers, databases, or both.
To export to CSV or Google Sheets, click Export to CSV/Google Sheets. 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.
To export to Microsoft Excel format, click Export to Microsoft Excel. After the export is complete, a dialog appears where you can download the file.
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.
In the Google Cloud console, go to the Create reports page.
In the Assets section, click Asset details export.
Depending on the asset type you want to export, click either the Export servers tab or Export databases tab.
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.
To export to CSV or Google Sheets, click Export to CSV/Google Sheets. 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.
To export to Microsoft Excel format, click Export to Microsoft Excel. After the export is complete, a dialog appears where you can download the file.
Export groups of assets
To export groups of assets, follow these steps:
In the Google Cloud console, go to the Create reports page.
In the Assets section, click Asset details export.
Click the Export groups tab. The page shows all the groups in your Migration Center project.
Select the groups that you want to export, either manually, or with the Filter tab.
To export to CSV or Google Sheets, click Export to CSV/Google Sheets. 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.
To export to Microsoft Excel format, click Export to Microsoft Excel. After the export is complete, a dialog appears where you can download the file.
Export out of scope assets
To export your out of scope assets, follow these steps:
In the Google Cloud console, go to the Create reports page.
In the Assets section, click Asset details export.
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.
To export to CSV or Google Sheets, click Export to CSV/Google Sheets. 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.
To export to Microsoft Excel format, click Export to Microsoft Excel. After the export is complete, a dialog appears where you can download the file.
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.
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.
You can download the report as a CSV file or a Microsoft Excel spreadsheet, or export it to a Google Sheets file in your Google Drive.
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:
In the Google Cloud console, go to the Create reports page.
In the Assets section, click Performance data export.
Click the All assets tab. The page shows the total number of in scope assets to export. Choose if you want to export servers, databases, or both.
To export to CSV format or Google Sheets, click Export to CSV/Google Sheets. To export to Microsoft Excel format, click Export to Microsoft Excel.
In the dialog that appears, select the number of days of performance data that you want to export for each asset, then click Export.
After the export is complete, a dialog appears with one or two files to download, depending on the format you chose.
- To download the files, 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.
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.
In the Google Cloud console, go to the Create reports page.
In the Assets section, click Performance data export.
Depending on the asset type you want to export, click either the Export servers or Export databases tab.
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.
To export to CSV format or Google Sheets, click Export to CSV/Google Sheets. To export to Microsoft Excel format, click Export to Microsoft Excel.
In the dialog that appears, select the number of days of performance data that you want to export for each asset, then click Export.
After the export is complete, a dialog appears with one file to download, depending on the format you chose.
- To download the file, 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:
In the Google Cloud console, go to the Create reports page.
In the Assets section, click Performance data export.
Click the Export groups tab. The page shows all the groups in your Migration Center project.
Select the groups that you want to export, either manually, or with the Filter tab.
To export to CSV format or Google Sheets, click Export to CSV/Google Sheets. To export to Microsoft Excel format, click Export to Microsoft Excel.
In the dialog that appears, select the number of days of performance data that you want to export for each asset, then click Export.
After the export is complete, a dialog appears with one or two files to download, depending on the format you chose.
- To download the files, 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.
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.
To view your recent reports, go to the Recent exports page.