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';

Schema for azure_security_center_subscription_pricing

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
free_trial_remaining_time	text		The duration left for the subscriptions free trial period.
id	text		The pricing id.
name	text	=	Name of the pricing.
pricing_tier	text		The 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_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
title	text		Title of the resource.
type	text		Type 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