[HOWTO] Select for nodes..

[cwilloug]

I looked around and didn't find this yet, I'd like to create a list of nodes that haven't accessed TSM in say 'X' days.. anyone??

Thanks!

Happy Friday everyone!

 

[fuzzballer]

Try this one.
DISPLAYS NODES THAT HAVE NOT BEEN ACCESSED WITHIN THE NUMBER OF DAYS SPECIFIED
select node_name,lastacc_time from nodes where cast((current_timestamp-lastacc_time)days as decimal) >= 30