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
Miami	128	16.04%
San Jose	112	14.04%
Boardman	104	13.03%
Ashburn	83	10.4%
Raleigh	74	9.27%
Columbus	56	7.02%
Snow Hill	35	4.39%
Los Angeles	34	4.26%
Port Mansfield	34	4.26%
Jacksonville	28	3.51%
Oklahoma City	15	1.88%
Dallas	8	1.0%
Portland	8	1.0%
Saratoga	8	1.0%
Wichita	7	0.88%
New York City	6	0.75%
Cortland	5	0.63%
Chicago	4	0.5%
Hutchinson	4	0.5%
Amarillo	3	0.38%
Corona	2	0.25%
Hobbs	2	0.25%
Minneapolis	2	0.25%
Santa Barbara	2	0.25%
Santa Clara	2	0.25%
Thornton	2	0.25%
Auburn	1	0.13%
Brookline	1	0.13%
Cassoday	1	0.13%
Chilhowie	1	0.13%
Clifton	1	0.13%
Conroe	1	0.13%
Deputy	1	0.13%
Dodge City	1	0.13%
Downingtown	1	0.13%
El Paso	1	0.13%
Garner	1	0.13%
Greeneville	1	0.13%
Hialeah	1	0.13%
Houston	1	0.13%
Howard City	1	0.13%
Kalamazoo	1	0.13%
Kansas City	1	0.13%
La Grange	1	0.13%
Lakeview	1	0.13%
Meridian	1	0.13%
O'Fallon	1	0.13%
Odessa	1	0.13%
San Antonio	1	0.13%
San Diego	1	0.13%
Remaining Results	6	0.75%
Total	798	100.0%

JSON Report

---

{
  "query": "services.software.vendor:\"Huawei\" and location.country='United States'",
  "field": "location.city",
  "total": 798,
  "duration": 178,
  "total_omitted": 6,
  "potential_deviation": 0,
  "buckets": [
    {
      "key": "Miami",
      "count": 128
    },
    {
      "key": "San Jose",
      "count": 112
    },
    {
      "key": "Boardman",
      "count": 104
    },
    {
      "key": "Ashburn",
      "count": 83
    },
    {
      "key": "Raleigh",
      "count": 74
    },
    {
      "key": "Columbus",
      "count": 56
    },
    {
      "key": "Snow Hill",
      "count": 35
    },
    {
      "key": "Los Angeles",
      "count": 34
    },
    {
      "key": "Port Mansfield",
      "count": 34
    },
    {
      "key": "Jacksonville",
      "count": 28
    },
    {
      "key": "Oklahoma City",
      "count": 15
    },
    {
      "key": "Dallas",
      "count": 8
    },
    {
      "key": "Portland",
      "count": 8
    },
    {
      "key": "Saratoga",
      "count": 8
    },
    {
      "key": "Wichita",
      "count": 7
    },
    {
      "key": "New York City",
      "count": 6
    },
    {
      "key": "Cortland",
      "count": 5
    },
    {
      "key": "Chicago",
      "count": 4
    },
    {
      "key": "Hutchinson",
      "count": 4
    },
    {
      "key": "Amarillo",
      "count": 3
    },
    {
      "key": "Corona",
      "count": 2
    },
    {
      "key": "Hobbs",
      "count": 2
    },
    {
      "key": "Minneapolis",
      "count": 2
    },
    {
      "key": "Santa Barbara",
      "count": 2
    },
    {
      "key": "Santa Clara",
      "count": 2
    },
    {
      "key": "Thornton",
      "count": 2
    },
    {
      "key": "Auburn",
      "count": 1
    },
    {
      "key": "Brookline",
      "count": 1
    },
    {
      "key": "Cassoday",
      "count": 1
    },
    {
      "key": "Chilhowie",
      "count": 1
    },
    {
      "key": "Clifton",
      "count": 1
    },
    {
      "key": "Conroe",
      "count": 1
    },
    {
      "key": "Deputy",
      "count": 1
    },
    {
      "key": "Dodge City",
      "count": 1
    },
    {
      "key": "Downingtown",
      "count": 1
    },
    {
      "key": "El Paso",
      "count": 1
    },
    {
      "key": "Garner",
      "count": 1
    },
    {
      "key": "Greeneville",
      "count": 1
    },
    {
      "key": "Hialeah",
      "count": 1
    },
    {
      "key": "Houston",
      "count": 1
    },
    {
      "key": "Howard City",
      "count": 1
    },
    {
      "key": "Kalamazoo",
      "count": 1
    },
    {
      "key": "Kansas City",
      "count": 1
    },
    {
      "key": "La Grange",
      "count": 1
    },
    {
      "key": "Lakeview",
      "count": 1
    },
    {
      "key": "Meridian",
      "count": 1
    },
    {
      "key": "O'Fallon",
      "count": 1
    },
    {
      "key": "Odessa",
      "count": 1
    },
    {
      "key": "San Antonio",
      "count": 1
    },
    {
      "key": "San Diego",
      "count": 1
    }
  ]
}