I have seen the below code from this community on getting the downtime report from netconnect probe.
require ("library/availability-lib")
-- Specify target Origin. Un-comment to run for all distinct Origins.
customer = "ORIGIN1"
-- email recipient(s)
recipient = "recipient@email.com"
-- Run for all customers if not specified
if customer == nil then
database.open("provider=nis;database=nis;driver=none")
-- get a list of all origins with net_connect data from the past 30 days
sql = "select distinct origin from v_qos_net_connect where sampletime >= dateadd(day, -30, GETDATE())"
query = database.query(sql)
database.close()
-- run availability report sequentially for all retrieved origins
for i, v in pairs(query) do
title = "Availability Report for "..v["origin"].." - Past 30 Days"
buf = ""
buf = buf .. html_start (title)
buf = buf .. getAvail(v["origin"])
buf = buf .. html_end ()
action.email(recipient,title,buf)
end
else
title = "Availability Report for "..customer.." - Past 30 Days"
buf = ""
buf = buf .. html_start (title)
buf = buf .. getAvail(customer)
buf = buf .. html_end ()
action.email(recipient,title,buf)
end
This report comes up with the output device name and availability in % . I would like to add IP address of all devices also in this report. I am not able to find the QoS for getting the IP address from netconnect . Can someone help me on this request ?