In Event Portal, an event is an object that defines the properties that describe and categorize actual event instances.
- Provide a numeric
id
if you want to query for a specific event. This can be either set directly in awhere
clause, or specified as part ofjoin
with another table.
- 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).
select
e.name as event,
ev.version as version,
ev.display_name as versionName
from
solace_event e
join
solace_event_version ev
on ev.event_id = e.id
where
e.id = '08ctmc2lyp6'
-- or a simplified version
select
id,
name
from
solace_event;
select
id,
name,
shared,
application_domain_id,
number_of_versions,
created_time,
created_by,
changed_by,
updated_time
from
solace_event
where
id = 'n5o4xx2fh62';
select
id,
name,
shared,
application_domain_id,
number_of_versions,
created_time,
created_by,
changed_by,
updated_time
from
solace_event
where
created_time >= now() - interval '30' day;
select
id,
name,
shared,
application_domain_id,
number_of_versions,
created_time,
created_by,
changed_by,
updated_time
from
solace_event
where
updated_time <= now() - interval '10' day;