solace_applicationsolace_application_domainsolace_application_versionsolace_configurationsolace_configuration_typesolace_consumersolace_custom_attribute_definitionsolace_datacentersolace_enumsolace_enum_versionsolace_environmentsolace_eventsolace_event_broker_servicesolace_event_broker_service_detailsolace_event_broker_service_versionsolace_event_management_agentsolace_event_meshsolace_event_versionsolace_eventapisolace_eventapi_productsolace_eventapi_product_versionsolace_eventapi_versionsolace_lifecycle_statesolace_messaging_servicesolace_schemasolace_schema_versionsolace_service_classsolace_topic_domain
Table: solace_application_version
In Event Portal, when you update an Application, you can update an existing version or create a new version of the Application. 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 Application version. This can be either set directly in awhere
clause, or specified as part ofjoin
with another table.
Caveat
- Be careful when requesting all columns (
*
) without using anid
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 application versions
select av.version as version, av.display_name as versionName, a.name as applicationfrom solace_application_version av join solace_application a on av.application_id = a.idwhere av.id = 'n5o41x2fh62';-- or a simplified versionselect id, version, display_namefrom solace_application_version;
Details of an application version
select id, version, display_name, declared_produced_event_version_ids, declared_consumed_event_version_ids, type, created_by, created_timefrom solace_application_versionwhere id = 'n5o4xx2fh62';
List application versions that have been created in the last 30 days
select id, version, display_name, declared_produced_event_version_ids, declared_consumed_event_version_ids, type, created_by, created_timefrom solace_application_versionwhere created_time >= now() - interval '30' day;
List application versions that have not been updated in the last 10 days
select id, version, display_name, declared_produced_event_version_ids, declared_consumed_event_version_ids, type, changed_by, updated_timefrom solace_application_versionwhere updated_time <= now() - interval '10' day;