Skip to content

Instantly share code, notes, and snippets.

@rroblak
rroblak / 10_solana_dashboard.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 10 Solana Dashboard (Object with 7 keys)
{
"overall_summary": {
"total_servers": 237,
"total_committed": 212,
"total_uncommitted": 25,
"total_annual_cost": 1193809.68,
"avg_cost_per_server": 5037.17,
"committed_percentage": 89.5
},
"by_function": [
@rroblak
rroblak / 09_servers_by_region_environment.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 09 Servers By Region Environment (Array with 13 items)
[
{
"region": "ap-south-mum",
"prod_server_count": 8,
"prod_committed_count": 8,
"prod_uncommitted_count": 0,
"prod_annual_cost": 16656.24,
"stg_server_count": 0,
"stg_committed_count": 0,
"stg_uncommitted_count": 0,
@rroblak
rroblak / 08_geo_commitments.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 08 Geo Commitments (Object with keys: _metadata, periods)
{
"_metadata": {
"description": "12-month rolling commitments by geography",
"periods": 4,
"baseline": "Jan 2025 = month index 1"
},
"periods": [
{
"month": "2025-12",
"total_12_month_commitment": 7660913.39,
@rroblak
rroblak / 07_fetch_hardware.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 07 Fetch Hardware (Object with keys: _metadata, servers)
This file has been truncated, but you can view the full file.
{
"_metadata": {
"description": "Servers with hardware specifications",
"total_services": 9640,
"main_servers": 1944,
"enriched_servers": 1717
},
"servers": [
{
"service_id": "37764196",
@rroblak
rroblak / 06_servers_by_expiration.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 06 Servers By Expiration (Object with keys: _metadata, costs_by_month, counts_by_month)
{
"_metadata": {
"description": "Expiration timeline for committed servers",
"total_committed_servers": 1579,
"service_groups": 22,
"timeline_months": 25
},
"costs_by_month": [
{
"expiration_month": "2025-11",
@rroblak
rroblak / 05_service_group_summary.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 05 Service Group Summary (Object with keys: _metadata, summary)
{
"_metadata": {
"description": "Service group summary with commitment status breakdown",
"total_service_groups": 25
},
"summary": [
{
"service_group": "rpc_node",
"committed_host_count": 525,
"committed_annual_cost": 2643819.24,
@rroblak
rroblak / 04_analyze_commitment.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 04 Analyze Commitment (Object with keys: _metadata, servers)
This file has been truncated, but you can view the full file.
{
"_metadata": {
"description": "Servers with environment and commitment status",
"total_servers": 1936,
"committed_servers": 1579,
"uncommitted_available": 357,
"uncommitted_scheduled": 0,
"uncommitted_returned": 0
},
"servers": [
@rroblak
rroblak / 03_combine_servers.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 03 Combine Servers (Object with keys: _metadata, servers)
This file has been truncated, but you can view the full file.
{
"_metadata": {
"description": "Combined server data with costs and discounts",
"total_servers": 1936,
"servers_with_invoiced_costs": 1866,
"servers_with_catalog_costs": 70,
"average_discount_percent": 3.42,
"input_stages": {
"services": "export_services",
"costs": "export_bill_costs"
@rroblak
rroblak / 02_export_bill_costs.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 02 Export Bill Costs (Object with keys: _metadata, services)
{
"_metadata": {
"description": "OVH service monthly costs from actual invoices",
"currency": "USD",
"cost_type": "monthly",
"calculation": "most recent full-month cost, or scaled prorated cost if full-month unavailable",
"billing_period": "last 12 months",
"from_date": "2024-11-03",
"generated_at": "2025-11-03T10:57:49.013342",
"total_services": 2239,
@rroblak
rroblak / 01_export_services.json
Created November 3, 2025 19:14
OVH Infrastructure Dashboard - 01 Export Services (Object with keys: services)
This file has been truncated, but you can view the full file.
{
"services": [
{
"service_id": "37862033",
"provider": "ovh",
"account": "OVHCloud - Bware CA",
"display_name": "ns5017870.ip-15-235-87.net",
"name": "ns5017870.ip-15-235-87.net",
"state": "active",
"product_name": "bandwidth-1000-unguaranteed",