Does anyone know if there is a way to poll the node details "hardware" variable or perform a SQL query to poll the node details hardware information so i can include it into a email?
Example:
Hi kavana33 ,
Something like below might work as a variable, I don't believe there is an actual column that is "Hardware" (at least none that I could find in the appropriate table). I think they are transforming the NULL's from the Orion.AssetInventory.ServerInformation table 'Virtual Host' that's what the below query does for you. If it's not NULL it returns the raw value
${N=SWQL;M=SELECT isnull (Manufacturer, 'Virtual Host') as Manufacturer
FROM Orion.AssetInventory.ServerInformation}
Here's a screenshot
Let me know how that works
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.