Any suggestions on creating a report to identify devices without Layer 3 UDT jobs? Trying to be proactive about ensuring we have IP and Host Name information correlated with the MAC address.
Thanks all
Try this as a custom SQL report:
select
n.caption as 'Device'
,case
when j.jobtype = 2 then 'Layer 2'
when j.jobtype = 3 then 'Layer 3'
when j.jobtype = 5 then 'Remote Event Log'
end as 'Job Type'
,dateadd(mi, datediff(mi, getutcdate(), getdate()), j.joblastrun) as 'Last Run'
from nodesdata n
join udt_job j on j.nodeid = n.nodeid
order by n.nodeid, j.joblastrun desc
Loop1 Systems: SolarWinds Training and Professional Services
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.