steampipe plugin install azure

Table: azure_security_center_subscription_pricing - Query Azure Security Center Subscription Pricing using SQL

Azure Security Center is a unified infrastructure security management system that strengthens the security posture of your data centers and provides advanced threat protection across your hybrid workloads in the cloud. It provides you with a comprehensive view of your security state and actionable recommendations to mitigate risks. The subscription pricing model allows you to choose the level of protection that best meets your needs.

Table Usage Guide

The azure_security_center_subscription_pricing table provides insights into the pricing tier and resource details associated with each Azure Security Center subscription. As a security analyst, use this table to understand the cost implications of your security strategies, and to ensure you are utilizing the most appropriate level of protection for your needs. This table can also assist in budget planning and cost management for your Azure resources.

Examples

Basic info

Explore which Azure Security Center subscriptions are at different pricing tiers to manage costs effectively and ensure optimal resource utilization.

select
id,
name,
pricing_tier
from
azure_security_center_subscription_pricing;
select
id,
name,
pricing_tier
from
azure_security_center_subscription_pricing;

List pricing information for virtual machines

Explore the cost implications of your virtual machines by examining their pricing tiers. This allows for efficient budget management and cost optimization.

select
id,
name,
pricing_tier
from
azure_security_center_subscription_pricing
where
name = 'VirtualMachines';
select
id,
name,
pricing_tier
from
azure_security_center_subscription_pricing
where
name = 'VirtualMachines';

Control examples

Schema for azure_security_center_subscription_pricing

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
free_trial_remaining_timetextThe duration left for the subscriptions free trial period.
idtextThe pricing id.
nametext=Name of the pricing.
pricing_tiertextThe pricing tier value. Azure Security Center is provided in two pricing tiers: free and standard, with the standard tier available with a trial period. The standard tier offers advanced security capabilities, while the free tier offers basic security features.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
titletextTitle of the resource.
typetextType of the pricing.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_security_center_subscription_pricing