solace_event_management_agent.md

Table: solace_event_management_agent

Information about Event Management Agent on the Solace PubSub+ Cloud.

Key columns

• Provide a numeric id if you want to query for a specific Event Management Agent. 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 Management Agents

select
  id, 
  name, 
  region,
  client_username,
  client_password,
  referenced_by_messaging_service_ids,
  status,
  created_time,
  created_by,
  changed_by,
  updated_time 
from
  solace_event_management_agent;

Details of an Event Management Agent

select
  id, 
  name, 
  region,
  client_username,
  client_password,
  referenced_by_messaging_service_ids,
  status,
  created_time,
  created_by,
  changed_by,
  updated_time 
from
  solace_event_management_agent
where
  id = 'n5o4xx2fh62';

List Event Management Agents that have been created in the last 30 days

select
  id, 
  name, 
  region,
  client_username,
  client_password,
  referenced_by_messaging_service_ids,
  status,
  created_time,
  created_by,
  changed_by,
  updated_time 
from
  solace_event_management_agent
where
  created_time >= now() - interval '30' day;

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

select
  id, 
  name, 
  region,
  client_username,
  client_password,
  referenced_by_messaging_service_ids,
  status,
  created_time,
  created_by,
  changed_by,
  updated_time 
from
  solace_event_management_agent
where
  updated_time <= now() - interval '10' day;