Jump to content
Sign in to follow this  
phrozenglow

Disabled Monitor Monitor

Recommended Posts

Hey there everyone,

So I have successfully created an Internal Monitor to look for disabled Monitors. Got all of my testing done with creating tickets and all that good stuff. My problem lies when I created an SQL view to assist with gathering information in a more concise manner. I then applied the view under Table to Check and when I went to check the Query Results noticed that it is suddenly including the Computers, Locations and Client tables. This breaks the monitor. What is strange is how these tables were never included in the week I have been testing this. Anyone have any ideas as to how I can exclude these tables from there query?

Share this post


Link to post
Share on other sites
Posted (edited)

So after some more testing I have noticed something strange. When utilizing one SQL view for the monitor, information is only pulled from that view and no other tables. However, when a different view is being utilize, it will then pull the Computers, Locations, and Clients tables into the mix. I am still performing testing to determine why Automate is handling the two SQL views differently.

Edited by phrozenglow
Still an issue

Share this post


Link to post
Share on other sites

If the table has a computerid column, it will automatically join the computers, locations, and clients tables. 

If it has a locationid column, I think it will just link locations and clients.

In your view, just don’t name a column computerid or locationid. (Or, redesign the view so that it can be joined to computers, locations, and clients without error)

Share this post


Link to post
Share on other sites

So further development during testing. I discovered late yesterday that if the view has a JOIN it will automatically link those three tables. However, if the view does not have a JOIN function it will simply look at that table. I have to do some more testing but at this point it looks like I may have to create two views. One with the JOIN and the other that just pulls data from the other. I will report back once testing is completed.

Darren

Tested this morning and you are correct. Thank you!

Edited by phrozenglow
Darren is correct
  • Thanks 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.

Guest
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...