Parsing Locally Registered SQL Server names XML file using Vb .Net -


i need retrieve names of locally registered ms sql servers stored in xml file. located @ "c:\users\xyz\appdata\roaming\microsoft\microsoft sql server\100\tools\shell\regsrvr.xml"

once retrieved, need populate these in combobox. using below code. not figure out tag use xml "m_xmld.selectnodes" code. advise appreciated.

 if system.io.file.exists(regsrvrfile)                 dim m_xmld xmldocument                 dim m_nodelist xmlnodelist                 dim m_node xmlnode                 'create xml document                 m_xmld = new xmldocument()                 'load xml file                 m_xmld.load(regsrvrfile)                 'get list of name nodes                  m_nodelist = m_xmld.selectnodes("/model/instances/document/data/registeredservers")             end if         end if 

sample xml attached.

<?xml version="1.0"?> <model xmlns="http://schemas.serviceml.org/smlif/2007/02">   <identity>     <name>urn:uuid:96fe1236-abf6-4a57-b54d-e9baab394fd1</name>     <baseuri>http://documentcollection/</baseuri>   </identity>   <xs:bufferschema xmlns:xs="http://www.w3.org/2001/xmlschema">     <definitions xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08">       <document>         <docinfo>           <aliases>             <alias>/system/schema/registeredservers</alias>           </aliases>           <sfc:version domainversion="1" />         </docinfo>         <data>           <xs:schema targetnamespace="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema" elementformdefault="qualified">             <xs:element name="registeredserversstore">               <xs:complextype>                 <xs:sequence>                   <xs:any namespace="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" processcontents="skip" minoccurs="0" maxoccurs="unbounded" />                 </xs:sequence>               </xs:complextype>             </xs:element>             <xs:element name="servergroup">               <xs:complextype>                 <xs:sequence>                   <xs:any namespace="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" processcontents="skip" minoccurs="0" maxoccurs="unbounded" />                 </xs:sequence>               </xs:complextype>             </xs:element>             <xs:element name="registeredserver">               <xs:complextype>                 <xs:sequence>                   <xs:any namespace="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" processcontents="skip" minoccurs="0" maxoccurs="unbounded" />                 </xs:sequence>               </xs:complextype>             </xs:element>             <registeredservers:bufferdata xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08">               <instances xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08">                 <document>                   <docinfo>                     <aliases>                       <alias>/registeredserversstore</alias>                     </aliases>                     <sfc:version domainversion="1" />                   </docinfo>                   <data>                     <registeredservers:registeredserversstore xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema">                       <registeredservers:servergroups>                         <sfc:collection>                           <sfc:reference sml:ref="true">                             <sml:uri>/registeredserversstore/servergroup/analysisservicesservergroup</sml:uri>                           </sfc:reference>                           <sfc:reference sml:ref="true">                             <sml:uri>/registeredserversstore/servergroup/centralmanagementservergroup</sml:uri>                           </sfc:reference>                           <sfc:reference sml:ref="true">                             <sml:uri>/registeredserversstore/servergroup/databaseengineservergroup</sml:uri>                           </sfc:reference>                           <sfc:reference sml:ref="true">                             <sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup</sml:uri>                           </sfc:reference>                           <sfc:reference sml:ref="true">                             <sml:uri>/registeredserversstore/servergroup/reportingservicesservergroup</sml:uri>                           </sfc:reference>                           <sfc:reference sml:ref="true">                             <sml:uri>/registeredserversstore/servergroup/sqlservercompacteditionservergroup</sml:uri>                           </sfc:reference>                         </sfc:collection>                       </registeredservers:servergroups>                     </registeredservers:registeredserversstore>                   </data>                 </document>                 <document>                   <docinfo>                     <aliases>                       <alias>/registeredserversstore/servergroup/analysisservicesservergroup</alias>                     </aliases>                     <sfc:version domainversion="1" />                   </docinfo>                   <data>                     <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema">                       <registeredservers:parent>                         <sfc:reference sml:ref="true">                           <sml:uri>/registeredserversstore</sml:uri>                         </sfc:reference>                       </registeredservers:parent>                       <registeredservers:name type="string">analysisservicesservergroup</registeredservers:name>                       <registeredservers:servertype type="servertype">analysisservices</registeredservers:servertype>                     </registeredservers:servergroup>                   </data>                 </document>                 <document>                   <docinfo>                     <aliases>                       <alias>/registeredserversstore/servergroup/centralmanagementservergroup</alias>                     </aliases>                     <sfc:version domainversion="1" />                   </docinfo>                   <data>                     <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema">                       <registeredservers:parent>                         <sfc:reference sml:ref="true">                           <sml:uri>/registeredserversstore</sml:uri>                         </sfc:reference>                       </registeredservers:parent>                       <registeredservers:name type="string">centralmanagementservergroup</registeredservers:name>                       <registeredservers:servertype type="servertype">databaseengine</registeredservers:servertype>                     </registeredservers:servergroup>                   </data>                 </document>                 <document>                   <docinfo>                     <aliases>                       <alias>/registeredserversstore/servergroup/databaseengineservergroup</alias>                     </aliases>                     <sfc:version domainversion="1" />                   </docinfo>                   <data>                     <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema">                       <registeredservers:registeredservers>                         <sfc:collection>                           <sfc:reference sml:ref="true">                             <sml:uri>/registeredserversstore/servergroup/databaseengineservergroup/registeredserver/mysqlserver\dbinstance</sml:uri>                           </sfc:reference>                         </sfc:collection>                       </registeredservers:registeredservers>                       <registeredservers:parent>                         <sfc:reference sml:ref="true">                           <sml:uri>/registeredserversstore</sml:uri>                         </sfc:reference>                       </registeredservers:parent>                       <registeredservers:name type="string">databaseengineservergroup</registeredservers:name>                       <registeredservers:servertype type="servertype">databaseengine</registeredservers:servertype>                     </registeredservers:servergroup>                   </data>                 </document>                 <document>                   <docinfo>                     <aliases>                       <alias>/registeredserversstore/servergroup/databaseengineservergroup/registeredserver/mysqlserver\dbinstance</alias>                     </aliases>                     <sfc:version domainversion="1" />                   </docinfo>                   <data>                     <registeredservers:registeredserver xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema">                       <registeredservers:parent>                         <sfc:reference sml:ref="true">                           <sml:uri>/registeredserversstore/servergroup/databaseengineservergroup</sml:uri>                         </sfc:reference>                       </registeredservers:parent>                       <registeredservers:name type="string">mysqlserver\dbinstance</registeredservers:name>                       <registeredservers:servername type="string">mysqlserver\dbinstance</registeredservers:servername>                       <registeredservers:usecustomconnectioncolor type="boolean">false</registeredservers:usecustomconnectioncolor>                       <registeredservers:customconnectioncolorargb type="int">0</registeredservers:customconnectioncolorargb>                       <registeredservers:servertype type="servertype">databaseengine</registeredservers:servertype>                       <registeredservers:connectionstringwithencryptedpassword type="string">data source=mysqlserver\dbinstance;integrated security=true;pooling=false;multipleactiveresultsets=false</registeredservers:connectionstringwithencryptedpassword>                       <registeredservers:credentialpersistencetype type="credentialpersistencetype">persistloginname</registeredservers:credentialpersistencetype>                     </registeredservers:registeredserver>                   </data>                 </document>                 <document>                   <docinfo>                     <aliases>                       <alias>/registeredserversstore/servergroup/integrationservicesservergroup</alias>                     </aliases>                     <sfc:version domainversion="1" />                   </docinfo>                   <data>                     <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema">                       <registeredservers:registeredservers>                         <sfc:collection>                           <sfc:reference sml:ref="true">                             <sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup/registeredserver/mysqlserver</sml:uri>                           </sfc:reference>                         </sfc:collection>                       </registeredservers:registeredservers>                       <registeredservers:parent>                         <sfc:reference sml:ref="true">                           <sml:uri>/registeredserversstore</sml:uri>                         </sfc:reference>                       </registeredservers:parent>                       <registeredservers:name type="string">integrationservicesservergroup</registeredservers:name>                       <registeredservers:servertype type="servertype">integrationservices</registeredservers:servertype>                     </registeredservers:servergroup>                   </data>                 </document>                 <document>                   <docinfo>                     <aliases>                       <alias>/registeredserversstore/servergroup/integrationservicesservergroup/registeredserver/mysqlserver</alias>                     </aliases>                     <sfc:version domainversion="1" />                   </docinfo>                   <data>                     <registeredservers:registeredserver xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema">                       <registeredservers:parent>                         <sfc:reference sml:ref="true">                           <sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup</sml:uri>                         </sfc:reference>                       </registeredservers:parent>                       <registeredservers:name type="string">mysqlserver</registeredservers:name>                       <registeredservers:servername type="string">mysqlserver</registeredservers:servername>                       <registeredservers:usecustomconnectioncolor type="boolean">false</registeredservers:usecustomconnectioncolor>                       <registeredservers:customconnectioncolorargb type="int">0</registeredservers:customconnectioncolorargb>                       <registeredservers:servertype type="servertype">integrationservices</registeredservers:servertype>                       <registeredservers:connectionstringwithencryptedpassword type="string">server=mysqlserver</registeredservers:connectionstringwithencryptedpassword>                       <registeredservers:credentialpersistencetype type="credentialpersistencetype">persistloginname</registeredservers:credentialpersistencetype>                     </registeredservers:registeredserver>                   </data>                 </document>                 <document>                   <docinfo>                     <aliases>                       <alias>/registeredserversstore/servergroup/reportingservicesservergroup</alias>                     </aliases>                     <sfc:version domainversion="1" />                   </docinfo>                   <data>                     <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema">                       <registeredservers:parent>                         <sfc:reference sml:ref="true">                           <sml:uri>/registeredserversstore</sml:uri>                         </sfc:reference>                       </registeredservers:parent>                       <registeredservers:name type="string">reportingservicesservergroup</registeredservers:name>                       <registeredservers:servertype type="servertype">reportingservices</registeredservers:servertype>                     </registeredservers:servergroup>                   </data>                 </document>                 <document>                   <docinfo>                     <aliases>                       <alias>/registeredserversstore/servergroup/sqlservercompacteditionservergroup</alias>                     </aliases>                     <sfc:version domainversion="1" />                   </docinfo>                   <data>                     <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema">                       <registeredservers:parent>                         <sfc:reference sml:ref="true">                           <sml:uri>/registeredserversstore</sml:uri>                         </sfc:reference>                       </registeredservers:parent>                       <registeredservers:name type="string">sqlservercompacteditionservergroup</registeredservers:name>                       <registeredservers:servertype type="servertype">sqlservercompactedition</registeredservers:servertype>                     </registeredservers:servergroup>                   </data>                 </document>               </instances>             </registeredservers:bufferdata>           </xs:schema>         </data>       </document>     </definitions>   </xs:bufferschema> </model> 

your query missing namespaces, , doesn't seem point node. try this:

dim xml string = "<?xml version=""1.0""?><model xmlns=""http://schemas.serviceml.org/smlif/2007/02""><identity><name>urn:uuid:96fe1236-abf6-4a57-b54d-e9baab394fd1</name><baseuri>http://documentcollection/</baseuri></identity><xs:bufferschema xmlns:xs=""http://www.w3.org/2001/xmlschema""><definitions xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08""><document><docinfo><aliases><alias>/system/schema/registeredservers</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><xs:schema targetnamespace=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema"" elementformdefault=""qualified""><xs:element name=""registeredserversstore""><xs:complextype><xs:sequence><xs:any namespace=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" processcontents=""skip"" minoccurs=""0"" maxoccurs=""unbounded"" /></xs:sequence></xs:complextype></xs:element><xs:element name=""servergroup""><xs:complextype><xs:sequence><xs:any namespace=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" processcontents=""skip"" minoccurs=""0"" maxoccurs=""unbounded"" /></xs:sequence></xs:complextype></xs:element><xs:element name=""registeredserver""><xs:complextype><xs:sequence><xs:any namespace=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" processcontents=""skip"" minoccurs=""0"" maxoccurs=""unbounded"" /></xs:sequence></xs:complextype></xs:element><registeredservers:bufferdata xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08""><instances xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08""><document><docinfo><aliases><alias>/registeredserversstore</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:registeredserversstore xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:servergroups><sfc:collection><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/analysisservicesservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/centralmanagementservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/databaseengineservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/reportingservicesservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/sqlservercompacteditionservergroup</sml:uri></sfc:reference></sfc:collection></registeredservers:servergroups></registeredservers:registeredserversstore></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/analysisservicesservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">analysisservicesservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">analysisservices</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/centralmanagementservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">centralmanagementservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">databaseengine</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/databaseengineservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:registeredservers><sfc:collection><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/databaseengineservergroup/registeredserver/mysqlserver\dbinstance</sml:uri></sfc:reference></sfc:collection></registeredservers:registeredservers><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">databaseengineservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">databaseengine</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/databaseengineservergroup/registeredserver/mysqlserver\dbinstance</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:registeredserver xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/databaseengineservergroup</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">mysqlserver\dbinstance</registeredservers:name><registeredservers:servername type=""string"">mysqlserver\dbinstance</registeredservers:servername><registeredservers:usecustomconnectioncolor type=""boolean"">false</registeredservers:usecustomconnectioncolor><registeredservers:customconnectioncolorargb type=""int"">0</registeredservers:customconnectioncolorargb><registeredservers:servertype type=""servertype"">databaseengine</registeredservers:servertype><registeredservers:connectionstringwithencryptedpassword type=""string"">data source=mysqlserver\dbinstance;integrated security=true;pooling=false;multipleactiveresultsets=false</registeredservers:connectionstringwithencryptedpassword><registeredservers:credentialpersistencetype type=""credentialpersistencetype"">persistloginname</registeredservers:credentialpersistencetype></registeredservers:registeredserver></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/integrationservicesservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:registeredservers><sfc:collection><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup/registeredserver/mysqlserver</sml:uri></sfc:reference></sfc:collection></registeredservers:registeredservers><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">integrationservicesservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">integrationservices</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/integrationservicesservergroup/registeredserver/mysqlserver</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:registeredserver xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">mysqlserver</registeredservers:name><registeredservers:servername type=""string"">mysqlserver</registeredservers:servername><registeredservers:usecustomconnectioncolor type=""boolean"">false</registeredservers:usecustomconnectioncolor><registeredservers:customconnectioncolorargb type=""int"">0</registeredservers:customconnectioncolorargb><registeredservers:servertype type=""servertype"">integrationservices</registeredservers:servertype><registeredservers:connectionstringwithencryptedpassword type=""string"">server=mysqlserver</registeredservers:connectionstringwithencryptedpassword><registeredservers:credentialpersistencetype type=""credentialpersistencetype"">persistloginname</registeredservers:credentialpersistencetype></registeredservers:registeredserver></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/reportingservicesservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">reportingservicesservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">reportingservices</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/sqlservercompacteditionservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">sqlservercompacteditionservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">sqlservercompactedition</registeredservers:servertype></registeredservers:servergroup></data></document></instances></registeredservers:bufferdata></xs:schema></data></document></definitions></xs:bufferschema></model>"  dim m_xmld xmldocument   dim m_nodelist xmlnodelist dim m_node xmlnode 'create xml document m_xmld = new xmldocument() 'load xml file m_xmld.loadxml(xml)  dim m_xmlnsmgr xmlnamespacemanager m_xmlnsmgr = new xmlnamespacemanager(m_xmld.nametable) m_xmlnsmgr.addnamespace("rs", "http://schemas.microsoft.com/sqlserver/registeredservers/2007/08") m_xmlnsmgr.addnamespace("sfc", "http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08") m_xmlnsmgr.addnamespace("sml", "http://schemas.serviceml.org/sml/2007/02") 'get list of name nodes  m_nodelist = m_xmld.selectnodes("//rs:registeredserver", m_xmlnsmgr)  each el in m_nodelist      console.writeline(el.selectsinglenode("rs:servername", m_xmlnsmgr).innertext) next console.readkey() 

this select registeredserver nodes in "registeredservers" namespace, , loop through them servername node in same namespace.


Comments

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

javascript - Get parameter of GET request -