Hello, There's that exact query on Thobias: http://thobias.org/tsm/sql/#toc17
- Thanks, Marc... ________________________________________________________ Marc Lanteigne Accelerated Value Specialist for Spectrum Protect 416.478.0233 | marclantei...@ca.ibm.com Office Hours: Monday to Friday, 7:00 to 16:00 Eastern Follow me on: Twitter, developerWorks, LinkedIn -----Original Message----- From: rou...@univ.haifa.ac.il [mailto:rou...@univ.haifa.ac.il] Sent: Wednesday, January 10, 2018 4:16 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select question Hi to alll Try to figure how to run a select to get for nodename the parameter “Days since last access” greater than 3 months When I run the q node ides got Protect: ADSM2>q node ides Node Name Platform Policy Domain Days Since Days Since Locked? Name Last Access Password Set ------------------------- -------- -------------- ---------- ---------- ------- IDES Linux x86-64 CC 178 1,497 No select node_name , LASTACC_TIME from nodes where ??????? T.I.A Regards
