Jump to content

Add Agent DNS Servers field to Dataviews 1.0.0

   (4 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.

  • Like 4
  • Thanks 1

User Feedback

Join the conversation

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




Thank you, still good in 2020.3 !!! :D

After import, do a dataview like Inventory - Network,  right click the header to select colums and pick the 'Agent DNS Servers'.


Awesome work Darren.

Link to review
  • Create New...