Skip to content

Instantly share code, notes, and snippets.

@rroblak
rroblak / 06_servers_by_expiration.json
Created December 2, 2025 00:36
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": 1547,
"service_groups": 18,
"timeline_months": 23
},
"costs_by_month": [
{
"expiration_month": "2025-12",
@rroblak
rroblak / 05_service_group_summary.json
Created December 2, 2025 00:36
OVH Infrastructure Dashboard - 05 Service Group Summary (Object with keys: _metadata, summary)
{
"_metadata": {
"description": "Service group summary with commitment status breakdown",
"total_service_groups": 23
},
"summary": [
{
"service_group": "rpc_node",
"committed_host_count": 519,
"committed_annual_cost": 2935770.84,
@rroblak
rroblak / 04_analyze_commitment.json
Created December 2, 2025 00:36
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": 1901,
"committed_servers": 1547,
"uncommitted_available": 354,
"uncommitted_scheduled": 0,
"uncommitted_returned": 0
},
"servers": [
@rroblak
rroblak / 03_combine_servers.json
Created December 2, 2025 00:36
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": 1901,
"servers_with_invoiced_costs": 1828,
"servers_with_catalog_costs": 73,
"average_discount_percent": 3.45,
"input_stages": {
"services": "export_services",
"costs": "export_bill_costs"
@rroblak
rroblak / 02_export_bill_costs.json
Created December 2, 2025 00:36
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-12-01",
"generated_at": "2025-12-01T16:25:37.740557",
"total_services": 2260,
@rroblak
rroblak / 01_export_services.json
Created December 2, 2025 00:36
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": "37862118",
"provider": "ovh",
"account": "OVHCloud - Bware CA",
"display_name": "retire",
"name": "ns5017867.ip-15-235-87.net",
"state": "active",
"product_name": "21adv02",
@rroblak
rroblak / 15_blockchain_network_rack_blast_radius.json
Created November 20, 2025 23:17
OVH Infrastructure Dashboard - 15 Blockchain Network Rack Blast Radius (Array with 234 items)
[
{
"blockchain_network": "ABSTRACT_MAINNET",
"region": "ap-southeast-sgp",
"environment": "prod",
"total_servers": 3,
"racks_used": 1,
"max_per_rack": 3,
"max_loss_percent": 100.0,
"rack_distribution": [
@rroblak
rroblak / 14_server_wide_table.json
Created November 20, 2025 23:17
OVH Infrastructure Dashboard - 14 Server Wide Table (Array with 1913 items)
This file has been truncated, but you can view the full file.
[
{
"service_group": "retire",
"name": "retire",
"account": "OVHCloud - Bware CA",
"ovh_domain": "ca.ovh.com",
"ns": "ns31479403.ip-141-95-47.eu",
"service_id": "37488053",
"provider": "ovh",
"state": "active",
@rroblak
rroblak / 13_server_utilization.json
Created November 20, 2025 23:17
OVH Infrastructure Dashboard - 13 Server Utilization (Object with keys: summary, details)
{
"summary": [
{
"service_group": "alchemy_core",
"server_count": 1,
"server_cpu_0_10%": 0,
"server_cpu_10_40%": 0,
"server_cpu_40_100%": 0,
"server_memory_0_10%": 0,
"server_memory_10_40%": 0,
@rroblak
rroblak / 12_rack_blast_radius.json
Created November 20, 2025 23:17
OVH Infrastructure Dashboard - 12 Rack Blast Radius (Array with 52 items)
[
{
"service_group": "alchemy_core",
"region": "eu-west-lim",
"environment": "prod",
"total_servers": 1,
"racks_used": 1,
"max_per_rack": 1,
"max_loss_percent": 100.0,
"rack_distribution": [