On 10.1.2018. 9:11, rouzen AT univ.haifa.ac DOT 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