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
An application in Event Portal is an object that represents software that produces and consumes events
Key columns
- Provide a numeric
id
if you want to query for a specific application. 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 Applications
select a.name as application, av.version as version, av.display_name as versionNamefrom solace_application a join solace_application_version av on av.application_id = a.idwhere a.id = 'n5o41x2fh62';-- or a simplified versionselect id, namefrom solace_application;
Details of an application
select id, name, application_type, broker_type, custom_attributesfrom solace_applicationwhere id = 'n5o4xx2fh62';
List applications that have been created in the last 30 days
select id, name, application_type, broker_type, custom_attributes, created_time, created_byfrom solace_applicationwhere created_time >= now() - interval '30' day;
List applications that have not been updated in the last 10 days
select id, name, application_type, broker_type, custom_attributes, updated_time, changed_byfrom solace_applicationwhere updated_time <= now() - interval '10' day;