On 10.1.2018. 9:11, rou...@univ.haifa.ac.il wrote: > 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 >
SELECT cast((NODES.NODE_NAME) as char(30)) as "NODE", cast((NODES.LASTACC_TIME) as char(28)) as "LASTACC_TIME" from nodes where LASTACC_TIME<'2017-10-01 00:15:00.000000' You may have to change the date format... Regards -- Sasa Drnjevic www.srce.unizg.hr
