Hi everyone i want to generate a report regarding the users roles/rights but i found some of the variable while generating report. Can anybody share his/her response whether this is possible or not in SolarWinds . * Report of Listing of users along with their access roles/rights , which cover at least the following…
Looking to create a report that will grab node information, cusom properties and threshold values; I've got this far; SELECT cp.Environment, n.Caption, n.Description, n.DetailsUrl, n.DisplayName, n.IP_Address FROM Orion.Nodes AS n JOIN Orion.NodesCustomProperties AS cp ON n.NodeID = cp.NodeID WHERE cp.Environment =…
Morning. Trying to get my head around this one, but its proving to be a nightmare. I want a report of all nodes, which alerts that can trigger on said node, and related ServiceNow actions on the alert(s) that can trigger For example: HOSTNAMEIPAlert NameService now dataTEST-HOST10.10.10.1Device down in AWSFull details…
When I generate a report it comes out in print format like this.. But when I export it to Excel, the report comes out like this.. with no percentage column. Any idea or is Excel/CSCV not supported anymore.. If not, what are my options.
Hello, I'm trying to build a custom report that lists all currently triggered instances of an alert named "BOF Display - Node Down". This report needs to include the node name, IP, Acknowledgement status, and the ServiceNow incident number. I just cannot wrap my head around the SWQL query needed to generate this report.…
My manager is looking for something similar to this post linked below, where it shows how long a WAN interface is above 80%. The solution in this link looks good, though I think it was written for the deprecated Report Writer. Does anyone have a similar query for web-based reporting today? Getting duration of High…
I am new to SolarWinds reports, and was surprised when I went to Report Manager and found nothing there. I've downloaded a few reports from this site, but was wondering if there should be some standard reports available out of the box. Can anyone enlighten me? Thanks, Joe
Hello Everyone, I am working on creating a custom report to meet user requirements. The organization has multiple WAN links provided by different vendors, each with various speeds such as 1 Gbps, 10 Gbps, 50 Mbps, 75 Mbps, and so on. Scenario:The users want a report that shows how many times the utilization threshold was…
Question: How can I get a report of "Node is down" alerts, which includes a field for either Downtime or Reset Time? Background: I created a basic, working "Node is down" alert. The only trigger action is send an email. The only reset action is send an email. The reset action message, contains: "Object was down for…
It looks like you're new here. Sign in or register to get started.