Re: [ADSM-L] Select question
2018-01-10 17:26:58
Guys all of those are far more complex than they need be
select node_name, lastacc_time from nodes where lastacc_time>(current timestamp
- 90 days)
Cheers
Steve
TSM Admin/Consultant
Canberra Australia
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Marc Lanteigne
Sent: Wednesday, 10 January 2018 11:07 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Select question
Hello,
There's that exact query on Thobias:
http://thobias.org/tsm/sql/#toc17
-
Thanks,
Marc...
________________________________________________________
Marc Lanteigne
Accelerated Value Specialist for Spectrum Protect
416.478.0233 | marclanteigne AT ca.ibm DOT com
Office Hours: Monday to Friday, 7:00 to 16:00 Eastern
Follow me on: Twitter, developerWorks, LinkedIn
-----Original Message-----
From: rouzen AT UNIV.HAIFA.AC DOT IL [mailto:rouzen AT UNIV.HAIFA.AC DOT IL]
Sent: Wednesday, January 10, 2018 4:16 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Select question
Hi to alll
Try to figure how to run a select to get for nodename the parameter “Days since
last access” greater than 3 months
When I run the q node ides got
Protect: ADSM2>q node ides
Node Name Platform Policy Domain Days Since
Days Since Locked?
Name
Last Access Password Set
------------------------- -------- --------------
---------- ---------- -------
IDES Linux x86-64 CC
178 1,497 No
select node_name , LASTACC_TIME from nodes where ???????
T.I.A Regards
This message and any attachment is confidential and may be privileged or
otherwise protected from disclosure. You should immediately delete the message
if you are not the intended recipient. If you have received this email by
mistake please delete it from your system; you should not copy the message or
disclose its content to anyone.
This electronic communication may contain general financial product advice but
should not be relied upon or construed as a recommendation of any financial
product. The information has been prepared without taking into account your
objectives, financial situation or needs. You should consider the Product
Disclosure Statement relating to the financial product and consult your
financial adviser before making a decision about whether to acquire, hold or
dispose of a financial product.
For further details on the financial product please go to http://www.bt.com.au
Past performance is not a reliable indicator of future performance.
|
ADSM.ORG Privacy and Data Security by KimLaw, PLLC
|