How to add last 30 days sql query in the below query ??

Need to get only last 30 days data in below query.

SELECT TOP 1000 SummaryDate, SourceSiteName, DisplayTarget, AVGofAvgJitter, SourceNodeID, TargetNodeID, AVGofAvgJitterSourcetoDestination, AVGofAvgJitterDestinationtoSource, OperationID

FROM Orion.IpSla.OperationsJitter

Find more posts tagged with

microsoft sql

Accepted answers

xaturbatu

Just add the where cause

WHERE SummaryDate>=addday(-30,GETDATE())

All comments

xaturbatu

Just add the where cause

WHERE SummaryDate>=addday(-30,GETDATE())

rajasekar

For last 10 mins ?

rajasekar

SELECT TOP 100 A.DisplayName,P.Name, C.IPAddress,L.LastUpdate, C.MAC, CONCAT(C.SignalStrength,' dbm') as Signal_Strength, C.SSID

FROM Orion.Wireless.AccessPoints A

INNER JOIN Orion.Wireless.Clients C on A.ID=C.AccessPointID

INNER JOIN Orion.Packages.Wireless.Clients P on P.InterfaceID=C.InterfaceID

INNER JOIN Orion.Wireless.ClientsSessionHistory L on L.MAC=C.MAC

WHERE ((C.InTotalBytes!=0 AND C.OutTotalBytes!=0)

In this i need to filter the last 10 mins data

xaturbatu

with the presumption that L.LastUpdate is the time column just add in the where clause, tolocal() is to be sure the time is in the right timezone.

tolocal(L.LastUpdate)>=addminute(-10,getdate())

rajasekar

Its not working