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_event_broker_service
Information about Broker Service on the Solace PubSub+ Cloud.
Key columns
- Provide a numeric
idif you want to query for a specific Broker Service. This can be either set directly in awhereclause, or specified as part ofjoinwith another table.
Caveat
- Be careful when requesting all columns (
*) without using anidin 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 Broker Services
select id, name, type, owned_by, infrastructure_id, datacenter_id, service_class_id, event_mesh_id, created_time, created_by, changed_by, updated_timefrom solace_event_broker_service;Details of a Broker Service
select id, name, type, owned_by, infrastructure_id, datacenter_id, service_class_id, event_mesh_id, created_time, created_by, changed_by, updated_timefrom solace_event_broker_servicewhere id = 'n5o4xx2fh62';List Broker Services that have been created in the last 30 days
select id, name, type, owned_by, infrastructure_id, datacenter_id, service_class_id, event_mesh_id, created_time, created_by, changed_by, updated_timefrom solace_event_broker_servicewhere created_time >= now() - interval '30' day;List Broker Services that have not been updated in the last 10 days
select id, name, type, owned_by, infrastructure_id, datacenter_id, service_class_id, event_mesh_id, created_time, created_by, changed_by, updated_timefrom solace_event_broker_servicewhere updated_time <= now() - interval '10' day;