Ladies and Gentlemen,
Do any of you out there have links to a SQL reference for ADSM ( I
already have the documentation from the Administrator's guide) or a SQL
92/93 reference? I am interested specifically with doing date calculations
using fields from DB, BACKUPS, and FILESPACES and NODES. Particularly, I
need to be able to add & subtact dates at a whim. THe command line adsm
client allows queries against ACTLOG like so:
q actlog begindate=TODAY-1 begintime=17:00:00 enddate=TODAY
endtime=05:59:59
effectively delivering me a specific date range from the activity log.
Utilizing the same general syntax (which does not work), I think you can
ascertain what I'm trying to get from the following:
Example: (from the shell)
dsmadmc -id=id -pa=pa -outfile=out.file -commadelimited "select
NODE_NAME,PWSET_TIME from NODES where PWSET_TIME>TODAY-100"
I want a listing of all PWSET times older than around 100 days. Thataways I
can harass those folks to change their passwords (Hospital policy prevents
from using PW aging techniques...one person can't get logged in fast enough,
someone has less of a chance of surviving trauma).
So then, to acheive the above desired result, what would my syntax be to
select all the node_name(s) and PW_SET dates older than 100 days?
Thanks!
Jerald Sheets, Systems Analyst TIS
Our Lady of the Lake Regional Medical Center
5000 Hennessy Blvd, Baton Rouge, LA 70808
Ph.225.765.8734..Fax.225.765.8784
E-mail: [EMAIL PROTECTED]
