Calculate the Amount of Assets

This article describes how to calculate the amount of classifiable data assets you have in the following cloud platforms:

• AWS
• Azure
• GCP

AWS

There are two options for calculating the amount of managed assets in your AWS environment:

• Calculate the amount of assets via the AWS console
• Calculate the amount of assets via the AWS CloudShell

Calculate the amount of assets via the AWS console

NOTE: This process needs to be performed separately on each of your AWS accounts.

1. Login to your AWS Account.
2. In the search bar, type Tag Editor and select Resource Groups & Tag Editor.
3. In the side menu, select Tag Editor.
4. In the Regions section, select All Regions.
5. In the Resources Types, add the following services:

AWS::S3::Bucket
AWS::DynamoDB::Table
AWS::RDS::DBCluster
AWS::RDS::DBInstance
AWS::EFS::FileSystem
AWS::OpenSearchService::Serverless
AWS::Redshift::Cluster

1. Go to Search Resources. The number next to Resource search results indicates the number of managed assets in your AWS environment.
2. Optional: Export the resource list as a .CSV file.

Calculate the amount of assets via the AWS CloudShell

NOTE: This process needs to be performed separately on each of your AWS accounts.

1. Login to your AWS Account.
2. Open the CloudShell terminal.
3. Run the following command:

   curl -s https://onboarding.dig.security/aws/dig-aws-asset-
   counter/single-profile-cloudshell/AACDig-single-profile-
   cloudshell.sh | bash

4. View the results to determine the number of assets there are in the current account.

Azure

Calculate the amount of managed assets in your Azure environment:

1. From the relevant tenant in the Azure portal, go to the Resource Graph Explorer.
2. In the Scope drop down, located at the top left of the screen, select the relevant scope for the query (Directory \ Management group \ Subscription).
3. Select New Query.
4. Copy the following query and click Run Query.

Resources | where type in~ ("microsoft.storage/storageaccounts", "microsoft.documentdb/databaseaccounts",
"microsoft.sql/servers",
“microsoft.sql/managedinstances”, 
"microsoft.dbformysql/servers", "microsoft.dbformysql/flexibleservers", "microsoft.dbforpostgresql/servergroupsv2"
"microsoft.dbforpostgresql/flexibleservers", "microsoft.dbforpostgresql/servers", "microsoft.dbformariadb/servers") | summarize count()

When the query finishes running, the number of data assets is displayed under count_

GCP

Calculate the amount of managed assets in your GCP environment.

1. In your GCP account, go to the Cloud Asset Inventory.
2. Select the required organization (recommended) or specific project, depending on your requirements.
3. Go to the Resource tab.
4. In the Filter results section, located next to Resource type, click View more (see above image).
5. In the Select resource type area, click By Count.
6. Select the following resources from the list, and click Apply.

   • storage.Bucket
   • sqladmin.Instance
   • file.Instance
   • bigquery.Dataset
   • bigtableadmin.Table

NOTE: If any of the above resources does not appear in the list, it indicates the count is Alternatively, use this link which already includes the above filters (you will need to re-select the required organization/project). Several results are displayed.

To export the results, click Download CSV.