Skip to content

Instantly share code, notes, and snippets.

@rroblak
rroblak / 05_service_group_summary.json
Created November 6, 2025 20:56
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": 512,
"committed_annual_cost": 2606027.16,
@rroblak
rroblak / 04_analyze_commitment.json
Created November 6, 2025 20:56
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": 1946,
"committed_servers": 1579,
"uncommitted_available": 367,
"uncommitted_scheduled": 0,
"uncommitted_returned": 0
},
"servers": [
@rroblak
rroblak / 03_combine_servers.json
Created November 6, 2025 20:56
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": 1946,
"servers_with_invoiced_costs": 1873,
"servers_with_catalog_costs": 73,
"average_discount_percent": 3.42,
"input_stages": {
"services": "export_services",
"costs": "export_bill_costs"
@rroblak
rroblak / 02_export_bill_costs.json
Created November 6, 2025 20:56
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-06",
"generated_at": "2025-11-06T12:04:54.668455",
"total_services": 2248,
@rroblak
rroblak / 01_export_services.json
Created November 6, 2025 20:55
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": "37552884",
"provider": "ovh",
"account": "OVHCloud - Bware CA",
"display_name": "ns3209619.ip-141-95-84.eu",
"name": "ns3209619.ip-141-95-84.eu",
"state": "active",
"product_name": "ram-32g-ecc-3200",
@rroblak
rroblak / 15_blockchain_network_rack_blast_radius.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 15 Blockchain Network Rack Blast Radius (Array with 249 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 3, 2025 19:15
OVH Infrastructure Dashboard - 14 Server Wide Table (Array with 1936 items)
This file has been truncated, but you can view the full file.
[
{
"service_group": "rpc_node",
"name": "rpc_node-eth-mainnet-reth_archive-prod-node_server-apse1-1",
"account": "OVHCloud - Bware CA",
"ovh_domain": "ca.ovh.com",
"ns": "ns5015612.ip-15-235-165.net",
"service_id": "37854230",
"provider": "ovh",
"state": "active",
@rroblak
rroblak / 13_server_utilization.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 13 Server Utilization (Object with keys: summary, details)
{
"summary": [
{
"service_group": "adi",
"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 3, 2025 19:15
OVH Infrastructure Dashboard - 12 Rack Blast Radius (Array with 57 items)
[
{
"service_group": "adi",
"region": "us-east-vin",
"environment": "prod",
"total_servers": 1,
"racks_used": 1,
"max_per_rack": 1,
"max_loss_percent": 100.0,
"rack_distribution": [
@rroblak
rroblak / 11_node_type_analysis.json
Created November 3, 2025 19:15
OVH Infrastructure Dashboard - 11 Node Type Analysis (Object with keys: alchemy_imply_network_summary)
{
"alchemy_imply_network_summary": [
{
"alchemy_imply_network": "SOLANA_MAINNET",
"total_annual_cost": 1158799.68,
"server_count": 230,
"total_cores": 5314
},
{
"alchemy_imply_network": "BASE_MAINNET",