All good, query returned the correct node name.

Now I have an .idc error. When in the app that connects to the sql database, there is a link to IE that users click on to open IE.

The error is: 'unable to open http://servername/idi/scripts/distsumsetdirect.idc? Cannot download the information you requested'