Skip to content

Instantly share code, notes, and snippets.

@rroblak
rroblak / 05_service_group_summary.json
Created November 20, 2025 23:16
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": 460,
"committed_annual_cost": 2338817.04,
@rroblak
rroblak / 04_analyze_commitment.json
Created November 20, 2025 23:16
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": 1913,
"committed_servers": 1559,
"uncommitted_available": 354,
"uncommitted_scheduled": 0,
"uncommitted_returned": 0
},
"servers": [
@rroblak
rroblak / 03_combine_servers.json
Created November 20, 2025 23:16
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": 1913,
"servers_with_invoiced_costs": 1840,
"servers_with_catalog_costs": 73,
"average_discount_percent": 3.47,
"input_stages": {
"services": "export_services",
"costs": "export_bill_costs"
@rroblak
rroblak / 02_export_bill_costs.json
Created November 20, 2025 23:16
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-19",
"generated_at": "2025-11-19T14:39:07.174916",
"total_services": 2254,
@rroblak
rroblak / 01_export_services.json
Created November 20, 2025 23:16
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": "37488053",
"provider": "ovh",
"account": "OVHCloud - Bware CA",
"display_name": "retire",
"name": "ns31479403.ip-141-95-47.eu",
"state": "active",
"product_name": "21adv01",
@rroblak
rroblak / 15_blockchain_network_rack_blast_radius.json
Created November 17, 2025 20:54
OVH Infrastructure Dashboard - 15 Blockchain Network Rack Blast Radius (Array with 236 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 17, 2025 20:54
OVH Infrastructure Dashboard - 14 Server Wide Table (Array with 1915 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 17, 2025 20:54
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 17, 2025 20:54
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": [
@rroblak
rroblak / 11_node_type_analysis.json
Created November 17, 2025 20:54
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": 1379824.32,
"server_count": 281,
"total_cores": 5946
},
{
"alchemy_imply_network": "MATIC_MAINNET",