If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
Query Node MYNODE locked='no' f=d
SELECT node_name, TO_CHAR(lastacc_time,'YYYY-MM-DD HH24:MI') as "lastacc_time" FROM - nodes WHERE DAYS(current_date)-DAYS(lastacc_time)>30
SELECT node_name FROM nodes WHERE locked not like 'YES'