Re: Select question
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 | marclantei...@ca.ibm.com Office Hours: Monday to Friday, 7:00 to 16:00 Eastern Follow me on: Twitter, developerWorks, LinkedIn -Original Message- From: rou...@univ.haifa.ac.il [mailto:rou...@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 AccessPassword Set - -- -- ----- IDESLinux x86-64 CC 178 1,497No 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.
Re: 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 | marclantei...@ca.ibm.com Office Hours: Monday to Friday, 7:00 to 16:00 Eastern Follow me on: Twitter, developerWorks, LinkedIn -Original Message- From: rou...@univ.haifa.ac.il [mailto:rou...@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 AccessPassword Set - -- -- ----- IDESLinux x86-64 CC 178 1,497No select node_name , LASTACC_TIME from nodes where ??? T.I.A Regards
Re: Select question
On 10.1.2018. 9:11, rou...@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 AccessPassword Set > - -- >-- ----- > IDESLinux x86-64 CC > 178 1,497No > > 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.00' You may have to change the date format... Regards -- Sasa Drnjevic www.srce.unizg.hr
Re: TSM 8.1.1 on Linux crash
> On 10 Jan 2018, at 02:05, Harris, Steven > wrote: > > Remco > > Can you please explain what the fall-out is? The fall-out is TSM locking up a CPU in an uninterruptible routine, with only one solution: reboot the entire Linux box. > > I'm using TSM 7.1.0 on AIX and have issues with LTO6 drives emulating LTOs. > Sometimes I just power cycle the drive and that clears the problem, but that > does not always work. > > Whilst I don't have any linux servers or storage agents in that particular > mix, I'd like to understand what you are seeing for future reference. > > Thanks > > Steve > > Steven Harris > TSM Admin/Consultant > > Canberra Australia > > > > 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. -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622
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 AccessPassword Set - -- -- ----- IDESLinux x86-64 CC 178 1,497No select node_name , LASTACC_TIME from nodes where ??? T.I.A Regards