Trying to get a Global Down Interfaces resource set on the front page that will only show the interfaces down within the last hour.
EOC SQL filter in place is :
Interface.Status=2 AND DATEDIFF(hour, Interface.LastChange, getdate()) < '1'
The resource is blank ( no data to display ), yet the same resources with the same filter on our NPMs shows down interfaces in the last hour.
NPM SQL filter :
OperStatus=2 AND DATEDIFF(hour, InterfaceLastChange, getdate()) < '1'
Any ideas ?
