ADSM-L

[ADSM-L] Select question

2018-01-10 03:15:30
Subject: [ADSM-L] Select question
From: "rouzen AT univ.haifa.ac DOT il" <rouzen AT UNIV.HAIFA.AC DOT IL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 10 Jan 2018 08:11:46 +0000
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

<Prev in Thread] Current Thread [Next in Thread>

ADSM.ORG Privacy and Data Security by KimLaw, PLLC