This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Node Details "Hardware" In an Alert

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:

hardware.png

  • 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

    pastedImage_0.png

    pastedImage_1.png

    Let me know how that works