Hi,
I'm trying to add a query node criteria for the 'LastDiscoveredTime' attribute of a 'Computer' element which is 'greater than 5 days' ago from now (i.e. greater than 5 days in the past).
Is it possible to do this without selecting a fixed date? If not, I would have to edit the query to change the date every time I want to run the report (which is not very helpful).
As an example; If I was writing it in SQL, the query would look like this:
SELECT * FROM [table] WHERE [column] < DATEADD(day, -5, GETDATE());
Any suggestions would be appreciated.
Support
Documentation
Learning Services
Partner Programs
