My Patience is running low. I'm exhausted and shouldn't have to pull my sql admin for every report I need. Days and hours trying to write what are really simple reports shouldn't be like pulling teeth.
Pain points that even our sql admin couldn't get past are:
1. Timestamp column. We couldn't find one.
2. Availability percentage. The table we found listed either 100% or 0% not an actual accurate percentage.
3. Connection between tables. When you need to grab data from different tables you need to find a common point like interface id. Sometimes the common point is not on all tables.
We found a query in the old report writer that shows the availability using sum functions among other things. But my sql admin couldn't find a way to narrow the list down to specific interfaces during a specific time. After 2 days we gave up because we where going no where. A call to solarwinds resulted in them saying to open a feature request which I have done. A thwack search yield another query that was designed by another user and this one we got closer, but could not get useful data approved by management as they indicated the information wasn't useful to them.
What we where looking for is simple. One column for interface name (MPLS interfaces), Filtered for the last 7 days, another column with time stamp and availability. We are trying to figure out which MPLS interfaces need maintenance and may need upgrade and thus far network team has had to rely on other tools as solarwinds has not met their needs. Every time they ask me for a report they wait 1 week while I try to figure out how to get it completed involve the write people only to get frustrated when I have to turn around and say that report is not possible. It angers me and makes me want to tell my upper management to ditch this software and go with a different solution.
I am looking for help as I'm pretty sure we aren't the only company looking for interface reports. And we will be thankful to anyone who can either share a report they have or a query that we can run for our own reporting. And if you can recommend third party reporting that can better help us put reports together that would be golden for us. We've been really struggling with our teams losing trust in solarwinds when we have to turn around and tell them reports they want can't be completed.