search

turbot / steampipe-plugin-datadog

Use SQL to instantly query Datadog resources across accounts. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/datadog
Apache License 2.0
12 stars 5 forks source link

Use Search API in datadog_service_level_objective table to populate column values, closes #63 #64

Open ParthaI opened 1 month ago

ParthaI commented 1 month ago

Example query results

Results ``` > select * from datadog_service_level_objective +------------+----------------------------------+----------------------------------+---------------------------+------+---------------------------+----------------------+-------------+--------+-------------+-----------------------------------------------------------------------------------------------------------> | name | id | creator_email | created_at | type | modified_at | configured_alert_ids | description | groups | monitor_ids | query > +------------+----------------------------------+----------------------------------+---------------------------+------+---------------------------+----------------------+-------------+--------+-------------+-----------------------------------------------------------------------------------------------------------> | time-slice | 914a0ed151605a88a9520964f5bd009c | xxxxxxxxxxxxxxxxxxxxxx@gmail.com | 2024-09-26T12:58:07+05:30 | slo | 2024-09-26T12:58:07+05:30 | | | | | > | testalert | 656b743ae253584899c02064ac7ad4cd | xxxxxxxxxxxxxxxxxxxxxx@gmail.com | 2024-09-26T12:56:57+05:30 | slo | 2024-09-26T12:56:57+05:30 | [] | | | | {"denominator":"count:datadog.event.tracking.intake.monresult.bytes{*}.as_count()","metrics":null,"numerat> | tes43 | b18382d82b9f5a2ea46849a984e948a5 | xxxxxxxxxxxxxxxxxxxxxx@gmail.com | 2024-09-26T11:08:50+05:30 | slo | 2024-09-26T11:08:50+05:30 | [] | | | [1118060] | > | test53 | 5ec04d26847356268838092d0b8506cc | xxxxxxxxxxxxxxxxxxxxxx@gmail.com | 2024-09-26T10:54:20+05:30 | slo | 2024-09-26T10:54:20+05:30 | [] | | | | {"denominator":"count:datadog.event.tracking.indexation.audit.events{*}.as_count()","metrics":null,"numera> | test53 | ddfe3bd205b953ebbd44334bce972cf1 | xxxxxxxxxxxxxxxxxxxxxx@gmail.com | 2024-09-26T10:53:39+05:30 | slo | 2024-09-26T10:53:39+05:30 | [] | | | | {"denominator":"count:datadog.event.tracking.indexation.audit.events{*}.as_count()","metrics":null,"numera> +------------+----------------------------------+----------------------------------+---------------------------+------+---------------------------+----------------------+-------------+--------+-------------+-----------------------------------------------------------------------------------------------------------> ```