From: Xavier 1 Chavanet
A valid SQL syntax for your request is :
select node_name,pwset_time from nodes where
cast((current_timestamp-pwset_time) days as decimal)> 100
Sorry, I have no electronic documentation availlable about SQL92.
Regard
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Xavier Chavanet, Kodak, EAMER Technical Services
IS-SIRM, Kodak Industrie, Bt17, Rue Paul Sabatier, ZI Nord 71102 Chalon sur
Saône CEDEX, France
Tel: (+33) (0) 3 85 99 70 13, Fax: (+33) (0) 3 85 99 19 13, E-Mail
[EMAIL PROTECTED]
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
"Sheets, Jerald" <[EMAIL PROTECTED]> on 25/06/2001 17:05:01
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Xavier 1 Chavanet/979460/Chalon/France/Europe/EKC)
Subject: ADSM/DATE/SQL
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]
