Re: Help to Operational Report.

2016-10-07 Thread David Ehresman
Can you post-process your output with sed 's/(SESSION:.*$//' -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bo Nielsen Sent: Friday, October 07, 2016 5:40 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Help to Operational Report. I try to

Re: Help to Operational Report.

2016-10-07 Thread Loon, Eric van (ITOPT3) - KLM
Hi Bo! I doubt if that will be possible at all. Both the message as the part you would like to get rid of (SESSION: 113123) have a variable length. If CHARINDEX was supported you could have used LEFT(message, CHARINDEX('(SESSION' )) to return everything left of (SESSION, but unfortunately it

Re: Azure support for cloud-based storage pools?

2016-10-07 Thread Del Hoobler
Hi Rick, The Spectrum Protect server and clients are already supported running in Azure. Check this out: http://www-01.ibm.com/support/docview.wss?uid=swg21239546#Microsoft%20Azure As for using BLOB storage, you would need a gateway today... but we understand the need for native attachment

Help to Operational Report.

2016-10-07 Thread Bo Nielsen
I try to create a select in Operational Report, but I need some help. I want to display Missed file details for a couple of nodes, as in the standard Report. I can't figure out the last of the the message. My select: select nodename, substr(char(date_time), 1, 20) as TME,