Query for Active Nodes in the last 'X' number of days

[insanity1]

I am just wondering if there is a means of querying for all nodes that have been active in the last 'X' number of days?

(v5.3.3 for Linux)

 

[ProbablyDown]

This will give you an idea:

select node_name,cast(lastacc_time as date) acc_date from nodes order by acc_date

from there you can say something like:

select node_name,cast(lastacc_time as date) last_acc from nodes where (cast(lastacc_time as date)>= cast(current_timestamp as date) - 5 days)

that will show you all nodes that connected from 5 days ago until today....