Listing out all remote hosts configured via Remote Unix Monitor (Extensions 2.0) using Notebook

[SrikanthSamraj]

Hi, there

Curious if there's a way to list out all remote hosts configured via Remote Unix Monitor (Extensions 2.0) using Notebook. I'm aware it is possible to get this information via API but interested to see if it can be achieved using Notebook as well.

Regards,

Srikanth

[p_devulapalli]

I don't have the extension so haven't tried, can you please try the below?

fetch `dt.entity.remote_unix:host`

[SrikanthSamraj]

Thanks much @p_devulapalli .

It did produce list of remote hosts configured via this extension. Any way to get their availability status as well?

[rastislav_danis]

try this:

timeseries avail=avg(remote_unix.availability), by: { hostname } |fields hostname,availavg=arrayAvg(avail)

[SrikanthSamraj]

Thanks much @rastislav_danis . It worked greatly for me. If I want to send this report as an email every day at a specific hour? Is that doable?

[rastislav_danis]

You can try email for workflows feature:

and use time trigger in workflow.