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 | marclanteigne AT ca.ibm DOT com
Office Hours:  Monday to Friday, 7:00 to 16:00 Eastern

Follow me on: Twitter, developerWorks, LinkedIn


-----Original Message-----
From: rouzen AT UNIV.HAIFA.AC DOT IL [mailto:rouzen AT UNIV.HAIFA.AC DOT IL]
Sent: Wednesday, January 10, 2018 4:16 AM
To: ADSM-L AT VM.MARIST DOT 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