{
    "generated": "2026-08-06T20:57:19+00:00",
    "connection_ok": true,
    "connection_error": "",
    "server": {
        "mysql_version": "10.11.18-MariaDB-cll-lve",
        "db_name": "threats",
        "innodb_large_prefix": "n/a",
        "innodb_default_row_format": "dynamic",
        "php_version": "8.3.31"
    },
    "tables": {
        "indicators": 953227,
        "indicator_sources": 1671992,
        "sources": 247,
        "enrichments": 29,
        "statistics": 0,
        "settings": 16,
        "tags": 53,
        "indicator_tags": 302907,
        "cases": false,
        "case_indicators": false,
        "case_notes": false,
        "campaigns": 23,
        "campaign_indicators": false,
        "watchlists": 0,
        "watchlist_items": 0,
        "saved_searches": 0,
        "alerts": 0,
        "alert_rules": false,
        "feed_registry": 435,
        "ip_ranges": false,
        "ip_dataset_imports": false,
        "dns_records": 339,
        "whois_cache": false,
        "source_catalog": false,
        "mission_domains": false,
        "intel_disciplines": false,
        "malicious_types": false,
        "countries": false,
        "sanctions": 20,
        "wanted": false,
        "tip_reports": false,
        "human_security": false,
        "risk_history": false,
        "netflow": false,
        "takedown_requests": false,
        "taxii_collections": false,
        "api_keys": 1,
        "activity_log": 61
    },
    "missing_tables": [
        "cases",
        "case_indicators",
        "case_notes",
        "campaign_indicators",
        "alert_rules",
        "ip_ranges",
        "ip_dataset_imports",
        "whois_cache",
        "source_catalog",
        "mission_domains",
        "intel_disciplines",
        "malicious_types",
        "countries",
        "wanted",
        "tip_reports",
        "human_security",
        "risk_history",
        "netflow",
        "takedown_requests",
        "taxii_collections"
    ],
    "missing_columns": [
        "indicators.malware_family",
        "indicators.actor",
        "indicators.sanctioned",
        "indicators.ip_uint"
    ],
    "subsystems": {
        "Indicators": {
            "total": 953227,
            "by_type": [
                {
                    "ioc_type": "ip",
                    "c": 439987
                },
                {
                    "ioc_type": "domain",
                    "c": 347769
                },
                {
                    "ioc_type": "url",
                    "c": 93284
                },
                {
                    "ioc_type": "hash_sha256",
                    "c": 20072
                },
                {
                    "ioc_type": "cidr",
                    "c": 13795
                },
                {
                    "ioc_type": "bitcoin",
                    "c": 13139
                },
                {
                    "ioc_type": "hash_sha1",
                    "c": 11494
                },
                {
                    "ioc_type": "ethereum",
                    "c": 5728
                },
                {
                    "ioc_type": "cve",
                    "c": 3703
                },
                {
                    "ioc_type": "hash_md5",
                    "c": 3283
                },
                {
                    "ioc_type": "onion",
                    "c": 753
                },
                {
                    "ioc_type": "asn",
                    "c": 206
                },
                {
                    "ioc_type": "monero",
                    "c": 10
                },
                {
                    "ioc_type": "phone",
                    "c": 4
                }
            ],
            "status": "ok",
            "fix": ""
        },
        "Local Resolve": {
            "ip_ranges_netblock": 0,
            "ip_ranges_geo": 0,
            "ip_indicators": 439987,
            "ip_resolved": 0,
            "resolved_pct": 0,
            "status": "red",
            "fix": "ip-datasets.php",
            "note": "No IP ranges loaded \u2014 resolve cannot work until you import IP datasets."
        },
        "Tags": {
            "tags": 53,
            "tag_links": 302907,
            "tagged_indicators": 100969,
            "status": "ok",
            "fix": "resolve-tags.php",
            "note": "Tagging active."
        },
        "TIP (Human Trafficking)": {
            "rows": null,
            "countries": 0,
            "status": "red",
            "fix": "seed-tip.php",
            "note": "Not ingested \u2014 run seed-tip.php (needs countries seeded first)."
        },
        "Cases": {
            "cases": null,
            "case_indicators_exists": false,
            "legacy_list_query_ok": false,
            "legacy_list_query_error": "cases table missing",
            "sample": [],
            "status": "yellow",
            "fix": "upgrade-db-v5.php",
            "note": "No cases yet."
        },
        "Feeds": {
            "registry": 435,
            "enabled": 412,
            "enabled_never_collected": 6,
            "sources": 247,
            "status": "yellow",
            "fix": "collect.php",
            "note": "6 enabled feeds never collected \u2014 run Auto-Collect."
        },
        "Ingest / Datasets": {
            "ip_dataset_imports": null,
            "enrichment_queue": null,
            "source_catalog": null,
            "status": "yellow",
            "fix": "seed-catalog.php",
            "note": "Source catalog empty \u2014 run seed-catalog.php."
        },
        "Campaigns": {
            "campaigns": 23,
            "links": null,
            "status": "ok",
            "fix": "campaign.php",
            "note": "Campaigns present."
        },
        "Actors & Malware": {
            "distinct_actors": 0,
            "distinct_malware_families": 0,
            "status": "yellow",
            "fix": "resolve-hashes.php",
            "note": "No attribution yet \u2014 run resolvers/enrichment."
        },
        "Taxonomy": {
            "source_catalog": null,
            "mission_domains": null,
            "intel_disciplines": null,
            "status": "yellow",
            "fix": "seed-catalog.php"
        },
        "Geo / Countries": {
            "countries": null,
            "sanctions": 20,
            "wanted": null,
            "status": "yellow",
            "fix": "seed-countries.php"
        }
    }
}