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.

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.