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	32,559	6.55%
Houston	19,009	3.83%
Miami	13,054	2.63%
Chicago	12,727	2.56%
Philadelphia	10,275	2.07%
Los Angeles	8,576	1.73%
Atlanta	7,586	1.53%
Phoenix	4,430	0.89%
Dallas	4,353	0.88%
Las Vegas	4,026	0.81%
Burbank	3,753	0.76%
Orlando	3,153	0.63%
Fort Lauderdale	2,934	0.59%
San Diego	2,890	0.58%
Baton Rouge	2,879	0.58%
Washington	2,862	0.58%
Newark	2,655	0.53%
Borough Park	2,593	0.52%
San Francisco	2,546	0.51%
Jacksonville	2,540	0.51%
San Jose	2,422	0.49%
Cape Coral	2,314	0.47%
San Antonio	2,206	0.44%
Denver	2,080	0.42%
Tampa	2,055	0.41%
Providence	2,040	0.41%
Santa Monica	1,943	0.39%
Boston	1,868	0.38%
Fort Worth	1,835	0.37%
Kansas City	1,723	0.35%
Detroit	1,722	0.35%
Austin	1,671	0.34%
Baltimore	1,668	0.34%
Seattle	1,608	0.32%
Oklahoma City	1,540	0.31%
Brandon	1,495	0.3%
Salt Lake City	1,494	0.3%
Sacramento	1,470	0.3%
New Orleans	1,454	0.29%
Pittsburgh	1,420	0.29%
Louisville	1,388	0.28%
El Paso	1,359	0.27%
Cincinnati	1,336	0.27%
West Palm Beach	1,324	0.27%
Columbus	1,320	0.27%
Astoria	1,310	0.26%
Portland	1,242	0.25%
Calabasas	1,231	0.25%
Minneapolis	1,149	0.23%
Middletown	1,140	0.23%
Remaining Results	302,686	60.91%
Total	496,913	100.0%

JSON Report

---

{
  "total": 496913,
  "total_omitted": 302686,
  "duration": 7240,
  "potential_deviation": 895,
  "buckets": [
    {
      "key": "New York City",
      "count": 32559
    },
    {
      "key": "Houston",
      "count": 19009
    },
    {
      "key": "Miami",
      "count": 13054
    },
    {
      "key": "Chicago",
      "count": 12727
    },
    {
      "key": "Philadelphia",
      "count": 10275
    },
    {
      "key": "Los Angeles",
      "count": 8576
    },
    {
      "key": "Atlanta",
      "count": 7586
    },
    {
      "key": "Phoenix",
      "count": 4430
    },
    {
      "key": "Dallas",
      "count": 4353
    },
    {
      "key": "Las Vegas",
      "count": 4026
    },
    {
      "key": "Burbank",
      "count": 3753
    },
    {
      "key": "Orlando",
      "count": 3153
    },
    {
      "key": "Fort Lauderdale",
      "count": 2934
    },
    {
      "key": "San Diego",
      "count": 2890
    },
    {
      "key": "Baton Rouge",
      "count": 2879
    },
    {
      "key": "Washington",
      "count": 2862
    },
    {
      "key": "Newark",
      "count": 2655
    },
    {
      "key": "Borough Park",
      "count": 2593
    },
    {
      "key": "San Francisco",
      "count": 2546
    },
    {
      "key": "Jacksonville",
      "count": 2540
    },
    {
      "key": "San Jose",
      "count": 2422
    },
    {
      "key": "Cape Coral",
      "count": 2314
    },
    {
      "key": "San Antonio",
      "count": 2206
    },
    {
      "key": "Denver",
      "count": 2080
    },
    {
      "key": "Tampa",
      "count": 2055
    },
    {
      "key": "Providence",
      "count": 2040
    },
    {
      "key": "Santa Monica",
      "count": 1943
    },
    {
      "key": "Boston",
      "count": 1868
    },
    {
      "key": "Fort Worth",
      "count": 1835
    },
    {
      "key": "Kansas City",
      "count": 1723
    },
    {
      "key": "Detroit",
      "count": 1722
    },
    {
      "key": "Austin",
      "count": 1671
    },
    {
      "key": "Baltimore",
      "count": 1668
    },
    {
      "key": "Seattle",
      "count": 1608
    },
    {
      "key": "Oklahoma City",
      "count": 1540
    },
    {
      "key": "Brandon",
      "count": 1495
    },
    {
      "key": "Salt Lake City",
      "count": 1494
    },
    {
      "key": "Sacramento",
      "count": 1470
    },
    {
      "key": "New Orleans",
      "count": 1454
    },
    {
      "key": "Pittsburgh",
      "count": 1420
    },
    {
      "key": "Louisville",
      "count": 1388
    },
    {
      "key": "El Paso",
      "count": 1359
    },
    {
      "key": "Cincinnati",
      "count": 1336
    },
    {
      "key": "West Palm Beach",
      "count": 1324
    },
    {
      "key": "Columbus",
      "count": 1320
    },
    {
      "key": "Astoria",
      "count": 1310
    },
    {
      "key": "Portland",
      "count": 1242
    },
    {
      "key": "Calabasas",
      "count": 1231
    },
    {
      "key": "Minneapolis",
      "count": 1149
    },
    {
      "key": "Middletown",
      "count": 1140
    }
  ],
  "query": "services.software.vendor:\"Hikvision\" and location.country='United States'",
  "field": "location.city"
}