SQL database query for getting historical temperature data of all switches

Our Products: Orion Platform 2017.1.1 SP1, DPAIM 11.0.0, NPM 12.1, VIM 7.1.0, NetPath 1.1.0, QoE 2.3, CloudMonitoring 1.0.0

We are looking to generate a report of all switches and their sensors temperature data. I have found the view - APM_HardwareSensorAlertData in SQLServer, but that view gives only the current temperature.

Can you help with SQL query or point me to the tables/views which can provide the temperature of a sensor for say last 30 days?

Find more posts tagged with

Accepted answers

All comments

Jfrazier

Hmmm....sounds like a job for a data warehouse.

zackm

SELECT TOP 100 *
FROM APM_HardwareItem i
JOIN APM_HardwareCategoryStatus c ON c.ID = i.HardwareCategoryStatusID
JOIN APM_HardwareItemValueStatistics v ON v.HardwareItemID = i.ID AND v.HardwareCategoryStatusID = c.ID
WHERE c.HardwareCategoryID = 4 --This is the Temperature Category (found in dbo.APM_HardwareCategory)

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of