Welcome! » Log In » Create A New Profile

Select question

Posted by rouzen@univ.haifa.ac.il 
rouzen@univ.haifa.ac.il
Select question
January 10, 2018 12:59AM
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 was imported via the External PhorumMail Module
Sasa Drnjevic
Re: Select question
January 10, 2018 01:59AM
On 10.1.2018. 9:11, rouzen@univ.haifa.ac.il wrote:
> 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
>



SELECT cast((NODES.NODE_NAME) as char(30)) as "NODE",
cast((NODES.LASTACC_TIME) as char(28)) as "LASTACC_TIME" from nodes
where LASTACC_TIME<'2017-10-01 00:15:00.000000'


You may have to change the date format...

Regards

--
Sasa Drnjevic
www.srce.unizg.hr
This message was imported via the External PhorumMail Module
Marc Lanteigne
Re: Select question
January 10, 2018 04:59AM
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@ca.ibm.com
Office Hours: Monday to Friday, 7:00 to 16:00 Eastern

Follow me on: Twitter, developerWorks, LinkedIn


-----Original Message-----
From: rouzen@UNIV.HAIFA.AC.IL [mailto:rouzen@UNIV.HAIFA.AC.IL]
Sent: Wednesday, January 10, 2018 4:16 AM
To: ADSM-L@VM.MARIST.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 was imported via the External PhorumMail Module
Harris, Steven
Re: Select question
January 10, 2018 02:59PM
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@VM.MARIST.EDU] On Behalf Of Marc Lanteigne
Sent: Wednesday, 10 January 2018 11:07 PM
To: ADSM-L@VM.MARIST.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@ca.ibm.com
Office Hours: Monday to Friday, 7:00 to 16:00 Eastern

Follow me on: Twitter, developerWorks, LinkedIn


-----Original Message-----
From: rouzen@UNIV.HAIFA.AC.IL [mailto:rouzen@UNIV.HAIFA.AC.IL]
Sent: Wednesday, January 10, 2018 4:16 AM
To: ADSM-L@VM.MARIST.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.
This message was imported via the External PhorumMail Module
Sorry, only registered users may post in this forum.

Click here to login