Hi all Better to use Select * from nodes where repl_state='NONE' Repl_state can have three status: none, enabled, disabled
I think it's more correct Dmitry Dukhov https://www.tsmexplorer.copm > On 21 Sep 2022, at 19:28, Rick Adamson <rickadam...@segrocers.com> wrote: > > Eric, > Are you looking for something along these lines.....? > > select node_name,repl_state,repl_mode from nodes where repl_state='ENABLED' > order by node_name > > > -Rick Adamson > > -----Original Message----- > From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of Oscar > Kolsteren > Sent: Wednesday, September 21, 2022 11:04 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] SQL query replnodes > > * This email originated outside of the organization. Use caution when opening > attachments or clicking links. * > > ---------------------------------------------------------------------- > Hey Eric, > > Have a look in our data collector which is used to create our FREE IBM CSA > Health Check report. > > If you don't have a copy left, let me know and I'll share one. In the script > are all the select statements we use. > > Or just run a fresh collection and upload for me to create a new report. > > Best Regards, > > Oscar Kolsteren > Lead Storage Consultant, IBM Client Storage Assessment Team (UKI) > > -----Original Message----- > From: ADSM: Dist Stor Manager <ADSM-L@VM.MARIST.EDU> On Behalf Of Loon, Eric > van (ITOP DI) - KLM > Sent: 21 September 2022 09:16 > To: ADSM-L@VM.MARIST.EDU > Subject: [EXTERNAL] [ADSM-L] SQL query replnodes > > Hi everybody, > > I'm trying to find a way to list replnode(s) through a SQL query, does > anybody know where this information can be found? So something like QUERY > RPELNODE <NODENAME>, but than through a SQL query. > Thanks for any help in advance! > > Kind regards, > Eric van Loon > Air France/KLM Core Infra > ******************************************************** > For information, services and offers, please visit our web site: > https://urldefense.com/v3/__http://www.klm.com__;!!NGPcfA!JTtdb1Yf5ThxhIC1O3cYrHeyiEIrgVH0_Rok2Ohg7oTNaDo4dqQjf-8SOIzzNI3XqQCML321Q7edDLu_uWAa3-n0Lfyc7Q$ > . This e-mail and any attachment may contain confidential and privileged > material intended for the addressee only. If you are not the addressee, you > are notified that no part of the e-mail or any attachment may be disclosed, > copied or distributed, and that any other action related to this e-mail or > attachment is strictly prohibited, and may be unlawful. If you have received > this e-mail by error, please notify the sender immediately by return e-mail, > and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission of > this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > ******************************************************** > > Unless otherwise stated above: > > IBM United Kingdom Limited > Registered in England and Wales with number 741598 Registered office: PO Box > 41, North Harbour, Portsmouth, Hants. PO6 3AU > > **CONFIDENTIALITY NOTICE** This electronic message contains information from > Southeastern Grocers, Inc and is intended only for the use of the addressee. > This message may contain information that is privileged, confidential and/or > exempt from disclosure under applicable Law. This message may not be read, > used, distributed, forwarded, reproduced or stored by any other than the > intended recipient. If you are not the intended recipient, please delete and > notify the sender.
