Table: aws_ssm_inventory_entry

AWS SSM (Systems Manager) Inventory Entries refer to the collected metadata information about the managed instances in your AWS environment. It includes details such as installed software, configuration settings, and other attributes of the instances. The inventory entries provide a comprehensive view of the software and configuration across your fleet of managed instances, allowing you to effectively manage and track the resources in your AWS infrastructure.

Examples

Basic info

select
  instance_id,
  type_name,
  capture_time,
  schema_version,
  entries
from
  aws_ssm_inventory_entry;

List inventory entries in the last 30 days

select
  instance_id,
  type_name,
  capture_time,
  schema_version,
  entries
from
  aws_ssm_inventory_entry
where
  capture_time >= time() - interval '30 day';

Get inventory details of entries

select
  e.instance_id,
  e.type_name,
  i.schema_version,
  i.schema
from
  aws_ssm_inventory_entry as e,
  aws_ssm_inventory as i
where
  i.id = e.instance_id;

Get managed instance details of inventory entries

select
  e.instance_id,
  e.type_name,
  i.resource_type,
  i.association_status,
  i.computer_name,
  i.ip_address,
  i.is_latest_version
from
  aws_ssm_inventory_entry as e,
  aws_ssm_managed_instance as i
where
  i.instance_id = e.instance_id;

List custom inventory entries of an instance

select
  instance_id,
  type_name,
  capture_time,
  schema_version,
  entries
from
  aws_ssm_inventory_entry
where
  instance_id = 'i-1234567890abcwd4f'
  and type_name like 'Custom%';

.inspect aws_ssm_inventory_entry

AWS SSM Inventory Entry

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
capture_time	timestamp with time zone	The time that inventory information was collected for the managed node(s).
entries	jsonb	The inventory items on the managed node(s).
instance_id	text	The managed node ID targeted by the request to query inventory information.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
schema_version	text	The inventory schema version used by the managed node(s).
title	text	Title of the resource.
type_name	text	The type of inventory item returned by the request.

turbot/aws