couldberunning

This is what i came to search for. We have a large number of application monitors (over 100 currently and expanding) and this would make life much easier when trying to see if a specific node has been assigned to an application monitor. 

Dang. On your Orion Core server go to the database manager. We are looking for this if you do not see the UDT tables your info may be stored elsewhere. My query is dependent on that. Also, I have see a glitch when switching back and forth from swql and sql where sometimes it says it not valid.. cancel out go back in and…

After talking this over we are going to put it into our processes to verify that one server is marked yes for runbook and then do a scheduled report every six months to rap up any loose ends where it might of been skipped. Thanks for your help again. 

Switch to SQL in the circle instead of swql

Gotcha let me check on the format in there and will get back with you. The format I used above is used in the report viewer directly in Orion. 

I think i have the fix. I will post in a moment once i know for sure. 

The runbook process on our side is manual. We basically go to the application owners and have them update contact info, server info ect on there application. The alert is to remind us to do this. So when they submit the runbook i would update the custom property runbook date. 5 months 1 week down the road i want orion to…

That would have worked like a charm and been ten times easier then how I corrected. I will mark this as solution as I am 99% sure that would have corrected. Thanks.

I see. By chance do you use the User Device Tracker portion of Orion. Thats is where all my query's point to. I am out of the office for the remainder of the day but will see if i can provide further assistance tomorrow. My original query should be able to pulled from within Orion if you use device tracker. I rarely use…

Are you doing this directly from the database or from the create new report under manage reports in Orion?

Do you have an example where you have done this before. I am out researching it right now but i am fairly new to the SQL world.

Yes, I should of added that to my Original post. There is not any view limitations. I am currently in the progress of redoing my default template to see if something possibly was corrupted in my default template. Also, I have checked the APM sections of the database and did not see any issues that stood out.

The alert will be polling from two application custom properties. They are: Runbook Runbook signoff date The Runbook is just a Yes/No custom property. Do we use a runbook for this template?If so it will have a Runbook signoff date. We need to update our runbooks every six month so the alert designed above takes the date in…

Also this issue would be resolved if custom properties could be added to the template layer instead of the node layer.

Alright so we removed any remaining references to the default template, recreated default template with a template that we know worked and seemed to resolve. We are about to Update all of our products so we will have a clean install then. If i find more info on how it occurred i will gladly post. Thanks all for the help.

Alright so here is where we stand. It appears my default application template is corrupt. It is not pulling in the info correctly. As a remedy we changed the application view ID in the database to one that we know that works and the detail page populated correctly. So now we are trying to correct our default view. No clue…

I believe it is how you have the first portion of your rule set up. Trigger Alert when ALL of the following apply. Group name is equal to menu. Is it alerting on all your items that are up in that group? EDIT: I read your initial question incorrectly. I see what you are saying now. Let me dig a little.

On your solarwinds server when you open up the database manager you should see Add default server. When you click on this it should add your Orion database into this view. At that time you should be able to expand to the section above. User device tracker is a cross product integration and you may not be using it. I should…

Do you have this section? I think that is the report you are looking for.

See if this helps. It will be SQL under create reports. SELECT a.AccountName, a.lastupdated FROM UDT_User a ORDER BY a.[Lastupdated] ASC If last updated is not the field your last login let me know. I am trying to locate in the database where last login is stored. Also this is using user device tracker.