steampipe plugin install awssteampipe plugin install aws

Table: aws_servicecatalog_product

AWS ServiceCatalog Product contains information about the product, such as its name, description, version, associated resources, configurations, and metadata. It serves as a central repository for managing and provisioning standardized IT services and resources across an organization.

Examples

Basic info

select
  name,
  id,
  product_id,
  type,
  akas,
  support_url,
  support_email
from
  aws_servicecatalog_product;

List products that have a default path

select
  name,
  id,
  product_id,
  type,
  distributor,
  owner,
  has_default_path
from
  aws_servicecatalog_product
where
  has_default_path;

List products that are owned by AWS

select
  name,
  id,
  product_id,
  type,
  support_url,
  support_description
from
  aws_servicecatalog_product
where
  type = 'MARKETPLACE';

Get budget details of each product

select
  name,
  id,
  owner,
  product_id,
  short_description,
  b ->> 'BudgetName' as budget_name
from
  aws_servicecatalog_product,
  jsonb_array_elements(budgets) as b;

Get launch path details of each product

select
  name,
  id,
  owner,
  short_description,
  l ->> 'Id' as launch_path_id,
  l ->> 'Name' as launch_path_name
from
  aws_servicecatalog_product,
  jsonb_array_elements(launch_paths) as l;

Get provisioning artifact details for each product

select
  name,
  id,
  p ->> 'Id' as provisioning_artifact_id,
  p ->> 'Name' as provisioning_artifact_name,
  p ->> 'CreatedTime' as provisioning_artifact_created_time,
  p ->> 'Description' as provisioning_artifact_description,
  p ->> 'Guidance' as provisioning_artifact_guidance
from
  aws_servicecatalog_product,
  jsonb_array_elements(provisioning_artifacts) as p;

.inspect aws_servicecatalog_product

AWS Service Catalog Product

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
accept_language	text	The language code.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
budgets	jsonb	Information about the associated budgets.
distributor	text	The distributor of the product. Contact the product administrator for the significance of this value.
full_text_search	text	The full text for the product.
has_default_path	boolean	Indicates whether the product has a default path. If the product does not have a default path, call ListLaunchPaths to disambiguate between paths.
id	text	The product view identifier.
launch_paths	jsonb	Information about the associated launch paths.
name	text	The name of the product.
owner	text	The owner of the product. Contact the product administrator for the significance of this value.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
product_id	text	The product identifier.
provisioning_artifacts	jsonb	Information about the provisioning artifacts for the specified product.
region	text	The AWS Region in which the resource is located.
short_description	text	Short description of the product.
source_product_id	text	The source product identifier.
support_description	text	The description of the support for this product.
support_email	text	The email contact information to obtain support for this product.
support_url	text	The URL information to obtain support for this product.
title	text	Title of the resource.
type	text	The product type. Contact the product administrator for the significance of this value. If this value is MARKETPLACE, the product was created by Amazon Web Services Marketplace.

turbot/aws