search

turbot / steampipe-mod-digitalocean-thrifty

Are you a Thrifty DigitalOcean dev? This mod checks your DigitalOcean account(s) for unused and under-utilized resources using Powerpipe and Steampipe.
https://hub.powerpipe.io/mods/turbot/digitalocean_thrifty
Apache License 2.0
5 stars 0 forks source link

Utilization review is possible in steampipe or not #27

Closed Niba-nazar closed 1 year ago

Niba-nazar commented 1 year ago

Hi,

Is it possible to know utilization reviews on steampipe, to get a summary or report on which servers/resources are truly being used and which are sitting idle?

misraved commented 1 year ago

Welcome to Steampipe @Niba-nazar, great to see you using the DigitalOcean mod 👍 .

At present we do have a few controls that check if the resources are available or idle. You could lean onto the block_storage_volume_inactive_and_unused control which enlists the volumes which are unattached.

We do have good dashboards in https://github.com/turbot/steampipe-mod-digitalocean-insights/tree/main/dashboards which provide an in-depth overview of digitalocean resources.

@Niba-nazar are you looking out for some specific resources? Currently the plugin supports 22 tables, we will be more than happy to add controls/queries for the resources you are looking out for 👍 .

rinshadka commented 1 year ago

Hi @misraved, is there any possibility to check or bring a feature for identifying idle resources like - a running droplet which is not being used and can be flagged as idle depending upon the measurements of its CPU/RAM consumption etc..

misraved commented 1 year ago

Welcome to Steampipe @rinshadka 👍 . I think we need to add new tables to the digital ocean plugin to query CPU/RAM consumption.

From an initial scan, I came across this API which can provide valuable insights on droplet metrics.

Could you please open an issue in https://github.com/turbot/steampipe-plugin-digitalocean/issues to add new tables for retrieving droplet metrics?

Niba-nazar commented 1 year ago

hi,

Thank you @misraved for the reply.

Is it possible to get network utilization reports through SQL? Also would like to know if steampipe is providing any SQLite backend support or SQLite as Destination

misraved commented 1 year ago

Hello @Niba-nazar, thanks for the reply 👍 .

Starting with the second part of the question, I think if you use Steampipe in the service mode, you will be able to connect it to any database management tool - https://steampipe.io/docs/managing/service#service-mode

I think Steampipe Cloud would be a great fit for your use case, more examples can be found here - https://steampipe.io/docs/cloud/integrations/overview

For the network utilization section - Currently, we don't have support for network utilization components in https://hub.steampipe.io/plugins/turbot/digitalocean/tables/digitalocean_vpc table. I will dig deep into what APIs we could add which would provide the correct information.

Niba-nazar commented 1 year ago

Hi @misraved ,

Thanks for the reply.

I can use PostgreSQL to connect to the "steampipe" database. I would like to learn more via sqlite3, though. Would you kindly help me understand how to use a sqlite3 database with steampipe?

misraved commented 1 year ago

Relevant slack thread - https://steampipe.slack.com/archives/C01UECB59A7/p1669292206131539

github-actions[bot] commented 1 year ago

'This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.'

github-actions[bot] commented 1 year ago

'This issue was closed because it has been stalled for 90 days with no activity.'