resources_statistics_v2s

Creates, updates, deletes, gets or lists a resources_statistics_v2s resource.

Overview

Name	resources_statistics_v2s
Type	Resource
Id	aws.securityhub.resources_statistics_v2s

Fields

The following fields are returned by SELECT queries:

get_resources_statistics_v2

Name	Datatype	Description
group_by_results	array	The aggregated statistics about resources based on the specified grouping rule.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_resources_statistics_v2	select	region		Retrieves statistical information about Amazon Web Services resources and their associated security findings. You can use the Scopes parameter to define the data boundary for the query. Currently, Scopes supports AwsOrganizations, which lets you aggregate resources from your entire organization or from specific organizational units. Only the delegated administrator account can use Scopes. If you set GroupByField to ResourceSubCategory, ResourceInfo.AIDetails.HostResourceType, or ResourceInfo.AIDetails.CanonicalId, you must include a ResourceCategory string filter with comparison set to EQUALS and value AI/ML in the corresponding ResourceGroupByRule.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

get_resources_statistics_v2

Retrieves statistical information about Amazon Web Services resources and their associated security findings. You can use the Scopes parameter to define the data boundary for the query. Currently, Scopes supports AwsOrganizations, which lets you aggregate resources from your entire organization or from specific organizational units. Only the delegated administrator account can use Scopes. If you set GroupByField to ResourceSubCategory, ResourceInfo.AIDetails.HostResourceType, or ResourceInfo.AIDetails.CanonicalId, you must include a ResourceCategory string filter with comparison set to EQUALS and value AI/ML in the corresponding ResourceGroupByRule.

SELECT
group_by_results
FROM aws.securityhub.resources_statistics_v2s
WHERE region = '{{ region }}' -- required
;