“What do we have, and whose is it?” sounds like the simplest question in cloud operations, and it’s surprisingly hard to answer. Native tools stop at one cloud and one account at a time. Inventory often lives inside security platforms built for a different job, where, as one reviewer put it, building “a manageable inventory report” is harder than it should be. Cost tools draw complaints about missing features and limited customization. Engineers end up querying cloud APIs with open-source SQL tools and maintaining the setup themselves.
Cloud Sleuth’s inventory search gives you that SQL, already connected to an inventory that knows the owner, cost and dependencies of every resource.
How it works
- One schema for AWS and Azure. EC2 instances and Azure VMs, S3 buckets and storage accounts, RDS and Azure SQL: the common fields line up, so one query covers both clouds.
- SQL when you want it. Query resources, owners, costs, relationships and findings with standard SQL.
- Plain English when you don’t. Ask “unowned resources in prod costing more than $100 a month” and see the SQL it ran, so you can check it and reuse it.
- Ownership and cost built in. Every row already has its owner (tagged or inferred), its monthly cost and its open findings. No joining tag exports to billing data by hand.
- Saved views and export. Save a query as a view, share it with the team in Cloud Sleuth Cloud, schedule it, or export it to CSV, JSON, an API or your BI tool.
- Kept current. The inventory follows changes from CloudTrail and the Azure Activity Log, so results reflect what’s running now.
Illustrative example - schema not final. Find unowned resources costing more than $100 a month, across both clouds:
select cloud, account, type, name, monthly_cost
from resources
where owner is null
and monthly_cost > 100
order by monthly_cost desc;Why it matters
Every cleanup, audit, migration and cost review starts with an inventory question. When the answer takes a ticket to another team or an afternoon of scripting, the question doesn’t get asked. A queryable inventory that already carries ownership turns “whose are these 300 untagged volumes?” into a one-line query, and the same data feeds the map, cleanup, allocation and guardrails.
Cloud Sleuth CLI vs. Cloud Sleuth Cloud
The Cloud Sleuth CLI gives you SQL and plain-English search over your own AWS and Azure inventory, with export, and nothing leaves your environment. Cloud Sleuth Cloud is planned to add saved and shared views, scheduled exports, an API and BI connectors across every account.
Both are pre-launch. Get early access to hear first when they are ready.