Get list of hosts and total number of hosts in 1 report

[utk123]

I have 2 reports which I want to combine so that I get 1 email with both information. 

1. Total number of hosts

index=abcd mysearch | stats count as Hostname

2. List of hosts

index=abcd mysearch | table Hostname

Results I expect:

Total Hostname: 145

Hostname

host1

host2

host3

Please advise.

[ITWhisperer]

| stats dc(hostname) as count by hostname
| addcoltotals

[utk123]

This also works, but accepted another answer as that is better in format. 

[isoutamo · Accepted solution]

Can you convert this to dashboard and schedule it? Probably this is the way to get exactly that expected result. Other option is get it little bit different format by next query:

index=abcde 
| stats dc(Hostname) as totalHostnames values(Hostname) as Hostnames

r. Ismo