Hi Arturo...
        The following is from the scripts.smp in the server directory.  You
can modify it to suit your needs or use other examples from that file.
        /usr/lpp/adsmserv/bin/scripts.smp
        Good Luck
        MV

        /* Display nodes that have not accessed ADSM since X
*/

        def script q_inactive desc='Show nodes with no access since a date'
        upd script q_inactive '/*
---------------------------------------------*/'
        upd script q_inactive '/* Script Name:  Q_INACTIVE
        upd script q_inactive '/* Script Name:  Q_INACTIVE
*/'
        upd script q_inactive '/* Description: Display nodes that have not
*/'
        upd script q_inactive '/*              accessed ADSM since a
specified */'
        upd script q_inactive '/*              date
*/'
        upd script q_inactive '/* Parameter 1: date yyyy-mm-dd (ISO) format
*/'
        upd script q_inactive '/* Example:     run q_inactive 1998-10-11
*/'
        upd script q_inactive '/*
---------------------------------------------*/'
        upd script q_inactive "select node_name,lastacc_time from nodes
        upd script q_inactive "select node_name,lastacc_time from nodes
where -"
        upd script q_inactive "  lastacc_time <'$1'"


        Hello
        Does anyone know the command to perform a query from the webclient
to find out how many days since last access for all nodes.

        Arturo Lopez
        IT Systems Programmer
        210.913.1845
        210.753-1845