steampipe plugin install solacelabs/solacesteampipe plugin install solacelabs/solace

Table: solace_event_version

In Event Portal, when you update an Event, you can update an existing version or create a new version of the Event. Versions allow you to work on updates and test new versions in development and staging environments while the stable version remains in the production environment. Each version also has a lifecycle state.

Key columns

Provide a numeric id if you want to query for a specific Event version. This can be either set directly in a where clause, or specified as part of join with another table.

Caveat

Be careful when requesting all columns (*) without using an id in the query. To load this data, Steampipe will have to issue multiple API request to retrieve all resources (essentially issuing a paginated queries).

Examples

List of all Event Versions

select
  ev.version as version,
  ev.display_name as versionName,
  e.name as name
from
  solace_event_version ev
  join solace_event e on ev.enum_id = e.id
where
  ev.id = 'n5o41x2fh62';
-- or a simplified version
select
  id,
  version,
  display_name
from
  solace_event_version;

Details of an Event Version

select
  id,
  version,
  display_name,
  declared_producing_application_version_ids,
  declared_consuming_application_version_ids,
  producing_event_api_version_ids,
  state_id,
  created_time,
  created_by,
  changed_by,
  updated_time
from
  solace_event_version
where
  id = 'n5o4xx2fh62';

List Event Versions that have been created in the last 30 days

select
  id,
  version,
  display_name,
  declared_producing_application_version_ids,
  declared_consuming_application_version_ids,
  producing_event_api_version_ids,
  state_id,
  created_time,
  created_by,
  changed_by,
  updated_time
from
  solace_event_version
where
  created_time >= now() - interval '30' day;

List Event Versions that have not been updated in the last 10 days

select
  id,
  version,
  display_name,
  declared_producing_application_version_ids,
  declared_consuming_application_version_ids,
  producing_event_api_version_ids,
  state_id,
  created_time,
  created_by,
  changed_by,
  updated_time
from
  solace_event_version
where
  updated_time <= now() - interval '10' day;