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

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?

can u pls help me to mofiy the same below query to fetch the last 7 days transaction please ..

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 u pls help me to mofiy the same below query to fetch the last 7 days transaction please ..

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%')

This was already answered above.