TSM 6.2.3 select staement

[dhipp]

I need a select statement that shows me a list of node_name from nodes that have NOT backed up in 30+ days. The script I had that was functional for TSM 5.5.52 does not work for TSM 6.2.3. I looked at the lasconstorage scripts, and they don't appear to have one. Anyone have one on file that they can respond with?

Thanks

 

[chad_small]

Easy!

select node_name, cast((lastacc_time)as date) AS LASTACC_DATE from nodes where lastacc_time<current_timestamp - 30 days

 

[dhipp]

Thanks Chad ! Worked like a charm. Do you know of a more detailed website than Lascon for pre-defined scripts for TSM 6.2.3 reporting? Or, better yet, has anyone used TCR?