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	20,856	5.03%
Houston	13,890	3.35%
Chicago	9,170	2.21%
Philadelphia	8,630	2.08%
Los Angeles	6,390	1.54%
Atlanta	5,832	1.41%
Phoenix	3,667	0.88%
Dallas	3,666	0.88%
Miami	3,316	0.8%
Burbank	3,257	0.78%
Las Vegas	3,224	0.78%
San Diego	2,440	0.59%
Borough Park	2,436	0.59%
Baton Rouge	1,984	0.48%
Jacksonville	1,906	0.46%
Orlando	1,906	0.46%
San Francisco	1,889	0.46%
Santa Monica	1,866	0.45%
Cape Coral	1,528	0.37%
Kansas City	1,472	0.35%
San Antonio	1,401	0.34%
Providence	1,378	0.33%
Austin	1,213	0.29%
Astoria	1,167	0.28%
Washington	1,114	0.27%
Brandon	1,095	0.26%
Hialeah	1,081	0.26%
Calabasas	1,072	0.26%
Oklahoma City	1,062	0.26%
New Orleans	1,032	0.25%
Newark	1,020	0.25%
Fort Worth	989	0.24%
Columbus	978	0.24%
Tampa	974	0.23%
Salt Lake City	973	0.23%
Louisville	952	0.23%
Norfolk	926	0.22%
San Jose	922	0.22%
Charlotte	917	0.22%
Denver	903	0.22%
Boston	899	0.22%
East Harlem	884	0.21%
Lakewood	875	0.21%
Memphis	829	0.2%
Fort Lauderdale	812	0.2%
Detroit	757	0.18%
Long Beach	749	0.18%
Rancho Santa Margarita	732	0.18%
El Paso	726	0.17%
Hicksville	715	0.17%
Remaining Results	286,442	69.04%
Total	414,914	100.0%

JSON Report

---

{
  "query": "services.software.vendor:\"Hikvision\" and location.country='United States'",
  "field": "location.city",
  "total": 414914,
  "duration": 709,
  "total_omitted": 286442,
  "potential_deviation": 728,
  "buckets": [
    {
      "key": "New York City",
      "count": 20856
    },
    {
      "key": "Houston",
      "count": 13890
    },
    {
      "key": "Chicago",
      "count": 9170
    },
    {
      "key": "Philadelphia",
      "count": 8630
    },
    {
      "key": "Los Angeles",
      "count": 6390
    },
    {
      "key": "Atlanta",
      "count": 5832
    },
    {
      "key": "Phoenix",
      "count": 3667
    },
    {
      "key": "Dallas",
      "count": 3666
    },
    {
      "key": "Miami",
      "count": 3316
    },
    {
      "key": "Burbank",
      "count": 3257
    },
    {
      "key": "Las Vegas",
      "count": 3224
    },
    {
      "key": "San Diego",
      "count": 2440
    },
    {
      "key": "Borough Park",
      "count": 2436
    },
    {
      "key": "Baton Rouge",
      "count": 1984
    },
    {
      "key": "Jacksonville",
      "count": 1906
    },
    {
      "key": "Orlando",
      "count": 1906
    },
    {
      "key": "San Francisco",
      "count": 1889
    },
    {
      "key": "Santa Monica",
      "count": 1866
    },
    {
      "key": "Cape Coral",
      "count": 1528
    },
    {
      "key": "Kansas City",
      "count": 1472
    },
    {
      "key": "San Antonio",
      "count": 1401
    },
    {
      "key": "Providence",
      "count": 1378
    },
    {
      "key": "Austin",
      "count": 1213
    },
    {
      "key": "Astoria",
      "count": 1167
    },
    {
      "key": "Washington",
      "count": 1114
    },
    {
      "key": "Brandon",
      "count": 1095
    },
    {
      "key": "Hialeah",
      "count": 1081
    },
    {
      "key": "Calabasas",
      "count": 1072
    },
    {
      "key": "Oklahoma City",
      "count": 1062
    },
    {
      "key": "New Orleans",
      "count": 1032
    },
    {
      "key": "Newark",
      "count": 1020
    },
    {
      "key": "Fort Worth",
      "count": 989
    },
    {
      "key": "Columbus",
      "count": 978
    },
    {
      "key": "Tampa",
      "count": 974
    },
    {
      "key": "Salt Lake City",
      "count": 973
    },
    {
      "key": "Louisville",
      "count": 952
    },
    {
      "key": "Norfolk",
      "count": 926
    },
    {
      "key": "San Jose",
      "count": 922
    },
    {
      "key": "Charlotte",
      "count": 917
    },
    {
      "key": "Denver",
      "count": 903
    },
    {
      "key": "Boston",
      "count": 899
    },
    {
      "key": "East Harlem",
      "count": 884
    },
    {
      "key": "Lakewood",
      "count": 875
    },
    {
      "key": "Memphis",
      "count": 829
    },
    {
      "key": "Fort Lauderdale",
      "count": 812
    },
    {
      "key": "Detroit",
      "count": 757
    },
    {
      "key": "Long Beach",
      "count": 749
    },
    {
      "key": "Rancho Santa Margarita",
      "count": 732
    },
    {
      "key": "El Paso",
      "count": 726
    },
    {
      "key": "Hicksville",
      "count": 715
    }
  ]
}