Report on Hosts

This tool allows you to generate a report on the breakdown of a value present on the Hosts returned by your query. For example, to generate a report on ports seen on Hosts with HTTP services, you could query for services.service_name: HTTP and then generate a report on the breakdown of the field services.port

Report for Hosts

---

location.city	hosts
New York City	17,661	7.17%
Houston	7,718	3.13%
Chicago	6,202	2.52%
Philadelphia	4,869	1.98%
Los Angeles	3,347	1.36%
Atlanta	3,287	1.33%
Miami	2,476	1.0%
Phoenix	2,330	0.95%
Dallas	2,252	0.91%
Las Vegas	1,915	0.78%
Burbank	1,902	0.77%
San Diego	1,477	0.6%
Baton Rouge	1,212	0.49%
Orlando	1,107	0.45%
San Francisco	1,101	0.45%
Jacksonville	1,096	0.44%
Borough Park	1,012	0.41%
San Jose	883	0.36%
Washington	880	0.36%
San Antonio	862	0.35%
Santa Monica	818	0.33%
Providence	797	0.32%
Charlotte	767	0.31%
Austin	740	0.3%
Cape Coral	721	0.29%
Oklahoma City	715	0.29%
Baltimore	711	0.29%
Kansas City	679	0.28%
Columbus	658	0.27%
Fort Worth	647	0.26%
Boston	641	0.26%
Astoria	636	0.26%
Denver	631	0.26%
Salt Lake City	580	0.24%
New Orleans	579	0.23%
Lakewood	574	0.23%
Calabasas	554	0.22%
Brandon	544	0.22%
Fort Lauderdale	521	0.21%
Newark	504	0.2%
Louisville	500	0.2%
Norfolk	499	0.2%
Detroit	487	0.2%
Rancho Santa Margarita	479	0.19%
Long Beach	474	0.19%
Omaha	467	0.19%
Sacramento	460	0.19%
East Harlem	440	0.18%
Jersey City	409	0.17%
Springfield	379	0.15%
Remaining Results	165,218	67.05%
Total	246,418	100.0%

JSON Report

---

{
  "query": "services.software.vendor:\"Hikvision\" and location.country='United States'",
  "field": "location.city",
  "total": 246418,
  "duration": 142,
  "total_omitted": 165218,
  "potential_deviation": 433,
  "buckets": [
    {
      "key": "New York City",
      "count": 17661
    },
    {
      "key": "Houston",
      "count": 7718
    },
    {
      "key": "Chicago",
      "count": 6202
    },
    {
      "key": "Philadelphia",
      "count": 4869
    },
    {
      "key": "Los Angeles",
      "count": 3347
    },
    {
      "key": "Atlanta",
      "count": 3287
    },
    {
      "key": "Miami",
      "count": 2476
    },
    {
      "key": "Phoenix",
      "count": 2330
    },
    {
      "key": "Dallas",
      "count": 2252
    },
    {
      "key": "Las Vegas",
      "count": 1915
    },
    {
      "key": "Burbank",
      "count": 1902
    },
    {
      "key": "San Diego",
      "count": 1477
    },
    {
      "key": "Baton Rouge",
      "count": 1212
    },
    {
      "key": "Orlando",
      "count": 1107
    },
    {
      "key": "San Francisco",
      "count": 1101
    },
    {
      "key": "Jacksonville",
      "count": 1096
    },
    {
      "key": "Borough Park",
      "count": 1012
    },
    {
      "key": "San Jose",
      "count": 883
    },
    {
      "key": "Washington",
      "count": 880
    },
    {
      "key": "San Antonio",
      "count": 862
    },
    {
      "key": "Santa Monica",
      "count": 818
    },
    {
      "key": "Providence",
      "count": 797
    },
    {
      "key": "Charlotte",
      "count": 767
    },
    {
      "key": "Austin",
      "count": 740
    },
    {
      "key": "Cape Coral",
      "count": 721
    },
    {
      "key": "Oklahoma City",
      "count": 715
    },
    {
      "key": "Baltimore",
      "count": 711
    },
    {
      "key": "Kansas City",
      "count": 679
    },
    {
      "key": "Columbus",
      "count": 658
    },
    {
      "key": "Fort Worth",
      "count": 647
    },
    {
      "key": "Boston",
      "count": 641
    },
    {
      "key": "Astoria",
      "count": 636
    },
    {
      "key": "Denver",
      "count": 631
    },
    {
      "key": "Salt Lake City",
      "count": 580
    },
    {
      "key": "New Orleans",
      "count": 579
    },
    {
      "key": "Lakewood",
      "count": 574
    },
    {
      "key": "Calabasas",
      "count": 554
    },
    {
      "key": "Brandon",
      "count": 544
    },
    {
      "key": "Fort Lauderdale",
      "count": 521
    },
    {
      "key": "Newark",
      "count": 504
    },
    {
      "key": "Louisville",
      "count": 500
    },
    {
      "key": "Norfolk",
      "count": 499
    },
    {
      "key": "Detroit",
      "count": 487
    },
    {
      "key": "Rancho Santa Margarita",
      "count": 479
    },
    {
      "key": "Long Beach",
      "count": 474
    },
    {
      "key": "Omaha",
      "count": 467
    },
    {
      "key": "Sacramento",
      "count": 460
    },
    {
      "key": "East Harlem",
      "count": 440
    },
    {
      "key": "Jersey City",
      "count": 409
    },
    {
      "key": "Springfield",
      "count": 379
    }
  ]
}