abdulraheemsidz ✭✭✭✭✭

No worries i figured it out it was giving Macro SQL error since i copied the code wrongly, its working like a charm.... just we need to copy the above queries in alert message body for RESET action. Simulate action is showing the new variable with hours and minutes. I hope this was proper answer for the question, excellent…

Thanks for your response, just to correct a little bit about your answer. Do we have to reconfigure VMAN integration to use the HA VIP? How does VMAN handle the active/passive server swap? Yes, the VMAN integration should be configured to use the VIP rather than a specific members IP address For Orion and VMAN integration,…

@smp Friend, were u able to solve this issue by installing full oracle client ? Appreciate your response.

Thanks for sharing this, but looks like this workaround is not working for Cisco ISR 4431.

Glad to know that.

dmvrtisjr​ were you able to get through this issue, or we need to open a support case for this same problem.

etcentene​ its old but may be you can get some idea from: Triggered Alert History - Last 30 Days

Thanks aLTeReGo​. Since Multiple Subnet has DNS in picture to configure Virutal Hostname for HA to detect fail overs and work, How do we configure Netflow and SNMP traps?

How do we get this to work in Alerts ?

Thanks, Yes did it yesterday itself as laid out in article and was able to proceed in installation. The installer used was Orion 2019.4 HF1. But again today we use same installer file to deploy our APE-1. We faced same error during installation and got stuck badly now as we did same steps of article on APE and restarted…

Looks like this table "StatusInfo" has status for almost all objects of Orion, not only limited to Nodes status.

Thanks this worked like a charm. After we write our own code in Alert message body, we can use Compress HTML to compress the code and then write the final code in alert message body. Before compressing the HTML code: After compressing HTML:

Amazing, Man this is crazy ...

Thanks Nathan for your input, I did the same and it worked.

Can we have the same SWQL to work in reports ?? I mean instead of ${NodeID} can we specify a particular node and generate report.

Thanks for your valuable input, so is there a way to change this intervals in Orion somewhere? in old VMAN appliance we can change it in schedules.

Thanks for your response. Originally I thought the same, if we assume for now that Orion Polling settings are applicable on VMAN polling, but what about "Configuration Schedule" which used to gather any new vm's, any changes in Hosts, VMs etc .... how is this job running in VMAN Orion. I believe some input from SolarWinds…

Tweaked to get good fonts with date time in center of report. using custom SQL query select '<h2 style="color:rgb(139,0,0);text-align:center;font-size: 160%"> '+ convert(varchar(100),getdate()) And then in the Edit Table, select the column, and check the box "Allow HTML Tags" Final Report having Date + Time when it was…

Yes that may help in this case for now, thanks for the response.

Whats the feature request for this thread ? I would like to vote as many type of Audit Events should be mandatory captured now.

Did we get how to convert this Down Time from minutes to days:hours:min ? Truly it has to be built in capability.

Great, thanks for sharing really it is useful document.

chad.every Great post ! Just checking what credential username / password will be required ?

amarnath_r​ Nice alert, the sql query you used is checking vm creation based on what condition. SELECT VirtualMachinesView.DisplayName, VirtualMachinesView.VirtualMachineID FROM VirtualMachinesView Where convert(date,DateCreated ) > convert(date,getdate()-2) VMs created in past 2 Days criteria?

Hello jhynds, thanks for your reply, its big relieve seeing your comment

* Replace syslog/trap with the functionality from our new Log Manager product Most of orion users rely on traps / syslogs data and use Orion native alerting mechanism to get alerts based on specific traps / syslogs, seeing that SolarWinds is going to replace this with a new Module (Log Manager) is really sad thing, even we…

This should definitely be part of What we are working On It should have ability to build PIE charts on all available metrics in SolarWinds Orion (same like we can pull almost all metrics for Node and its child objects and other Orion Objects in PerfStack dashboards)

If this idea incorporated in upcoming release it will be very helpful. https://thwack.solarwinds.com/ideas/9229#comment-318651

What will be the Default Syslog Facility ? is it Kernel (messages) ??

Thanks, unfortunately we tried that long back and the xml will not include any SQL query / text.