Need help in Changing the Query to fetch last 7 days data

Dear

Thanks for the great community 

i have the below query which fetches the data like memory used device name and cpu load etc , 

---------------------------------------------------------------------------------------------------------------------------------

SELECT TOP 50 n.Caption,n.PercentMemoryUsed,n.LastBoot,n.Status,n.CPULoad,n.DetailsUrl
FROM Orion.Nodes n

WHERE (Caption LIKE '%FYHA-WLEF%' OR Caption LIKE '%FYHA-WAPC%' OR Caption LIKE '%FYHA-WSER%' OR Caption LIKE '%FYHA-WSPN%' OR Caption LIKE '%FYHA-NMSR%' OR Caption LIKE '%FYHA-NVRR%')

---------------------------------------------------------------------------------------------------------------------------------

Can we change the query to get last 7 days data , kindly help me to change the query to fetch the last 7 days data 

appreciate your help.

Parents
  • The Orion.Nodes entity only holds the Point in Time (most recent poll) information in the fields.  Do you want the PercentMemoryUsed and CPULoad over the last 7 days?  Do you want the Min/Avg/Max over those 7 days? What do you want the output to look like?

Reply
  • The Orion.Nodes entity only holds the Point in Time (most recent poll) information in the fields.  Do you want the PercentMemoryUsed and CPULoad over the last 7 days?  Do you want the Min/Avg/Max over those 7 days? What do you want the output to look like?

Children