Which advanced alert variable ${attName} and/or query ${SQL: query} distinguishes Physical versus Virtualized servers?
try this:
${SQL:select case when ${nodeid} in (select nodeid from vim_virtualmachines) then 'VIRTUAL' else 'PHYSICAL' end from nodes}
-ZackM
Loop1 Systems: SolarWinds Training and Professional Services