Jump to content
Sign in to follow this  

Agent DNS Servers column in Dataviews

Recommended Posts

Ever wonder which Dataview includes the agents DNS servers?  None.
Ever wonder how you can get a dataview to include them?

The attached SQL will modify all dataviews that include the computer's local IP (Agent IP Address) to also include the DNS server information as "Agent DNS Servers". I started out planning to create a specific dataview, but I think it is better to make this column available in any dataview.

Save the file and import into Control Center using Tools -> Import -> SQL File. It will ask if you want to "Import 1 Statement into the database". If it says there are many statements choose "No", you have an older (buggy) Control Center and you will need to import using SQLYog or some other tool.

This attachment has been moved. See https://www.labtechgeek.com/files/file/18-add-agent-dns-servers-field-to-dataviews/

  • Thanks 1

Share this post

Link to post
Share on other sites
55 minutes ago, DarrenWhite99 said:

You've said amazing: 

But you haven't professed your love, in these forums as least.. :x

Well don't hold your breath waiting for it ;)


  • Haha 1

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...