Jump to content

Add Agent DNS Servers field to Dataviews 1.0.0

   (3 reviews)

About This File

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.  I suggest copying one or a few of the stock Dataviews, and then running this. While it will update all dataviews, many will be flagged as having changes the next time Solution Center is ran and may be reset to original. The copied Dataviews should preserve the additional column.

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.

  • Thanks 1



User Feedback

Create an account or sign in to leave a review

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

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

Jaffer Mohammed

  

As Always @DarrenWhite99 you are the best man!

Unsure where you got your skills from, but when you die "give me your brain" lol 

Share this review


Link to review
Jonathan Springham

  

Needed this first thing today and this was exactly what I was looking for; Thank you!

Share this review


Link to review
ckochosky

  

Needed this in a pinch, worked perfectly. Thank you!

 

Share this review


Link to review
×