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.
First, not all locked nodes are decommissioned, but all decommissioned nodes are locked. So checking the locked status is not a good approach to determine if a node is decommissioned.How do I query for nodes that are locked or not locked?
under Table = Nodes, there is Locked
There's no "locked" info in the admin reference guide.
Tried:Doesn't work. What's another option for querying decom'ed nodes?Code:
Query Node MYNODE locked='no' f=d
First, not all locked nodes are decommissioned, but all decommissioned nodes
If you want to look at decommissioned nodes, use:
select node_name,decomm_date from nodes where decomm_state='YES'
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'