Jump to content
Sign in to follow this  
DarrenWhite99

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
10 hours ago, MGreen said:

Have i ever told you I love you man?

You've said amazing: 

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

  • Haha 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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×