Hi Folks!! Background: I have zero knowledge of solarwinds. I am writing a powershell script where I want to get the data from availability report (Node, Hostname, Availbility %, etc.). I am looking for a query to get the same. My Solution: I found below query but it only gives the report information. query => SELECT…
hello guys ,, i want to retrieve a weekly report for a group of nodes during business hours only. in the custom period i only get to set to specify start and end periods. anyone i can achoeve that?
Greetings to the community, I wanted to ask if there is any type of report on interface failures and duration of interruptions on non-Cisco equipment.
I have an interesting problem. I am trying to schedule a few inventory reports in EOC. The scheduler allows me to select the reports, and show the reports on the summary page, but after I save the schedule, it shows no reports. Other types of reports (like Node Availability) work fine in EOC. Running the reports in EOC…
Hello, I have a SQL query that displays the Pool Member status of our Load Balancers like below: I have been asked to add a count to the table for each server name of how many EventType = 1 events have occurred. I can't figure out how to add that to my query. If possible, I would be very grateful if anyone could help me…
I'm trying to do a bandwidth utilization report of our Internet interfaces but would need to consider the business hours. I was able to do this for availability but would like to get the trend how our internet is utilized during business hours. Is there an out of the box report that I can modify to achieve this?
Hi Team, Greetings! I am looking to create a report that shows all the active alerts triggered in our solarwinds environment, as well as the details of acknowledged alerts and the users who acknowledged them. We need this report on a monthly basis in order to track the number of alerts and acknowledgments each month.…
Hi: I have an APM report that takes an application and provides monthly uptimes as a %. I want to add business hours, like M-F 9-5, or other similar constraints. I'm not seeing an easy way to do this in Manage Reports on the web interface. Any suggestions for how to do this? Thanks.
Here is the code below and just want be able to query for a specific Example: Node like contains "ENAC" or "Applications" Contain "ENAC"? Any help with this would be appreciated since I am not even close to being a programmer.. SELECT TOP 10 s.Component.Status as ComponentStatus, s.Component.DetailsUrl as CDetailsUrl,…
Example I want to only track the statis in a dashboard for one specific application not all of them since they want a single dashboard for each application to show case any help with this would be greatly appreciated. Her is the current code, but show for many servers and I only one or to be able to query one to many when…
It looks like you're new here. Sign in or register to get started.