Trying to find a way to get the serial number/ product id of hard drives for alerts. Had a drive fail today and would like to get the product id of the drive in the alert to save me some time when ordering a new one. Im not gret with SQL but have this in my email alerts now and assume I can use the same concept, just not sure what the drives id would be labeled:
The ${CategoryName}, ${SensorDisplayName} on ${NodeName} has a current status of ${SensorOrionStatusDescription}.
Device Details:
Manufacturer: ${SQL:Select Manufacturer from APM_HardwareInfo where NodeID = ${NodeID}}
Model: ${SQL:Select Model from APM_HardwareInfo where NodeID = ${NodeID}}
Service Tag: ${SQL:Select ServiceTag from APM_HardwareInfo where NodeID = ${NodeID}}
Hard Drive ID: ${SQL:Select ? from APM_HardwareInfo where NodeID = ${NodeID}}
For more information click the following link.
${APM:HardwareSensorDetailsURL}