What time frame are you looking at? There is the application hourly table right near the detail one. I think I would try out the new web reports for this and see if I could put the graph up top followed by the table details summarized hourly or daily.
I'm looking at doing weekly reports and our server currently collects 32 days of detailed statistics. To be honest I hadn't tried web reports graphing yet - I will look at it and I'll post if I find anything that works for this.
...our server currently collects 32 days of detailed statistics...
That's a bit impressive! Mind sharing your component monitor count and SQL specs?
Today I took a moment to look over the web reports for this. It doesn't seem I am able to what I want in there either. I can make a graph exactly like the one in the application details, but the issues I find with this are that I seem to have to add every monitor manually (I want to be able to say select all application monitors where node custom property X = Y) and I can't single out certain statuses to look at. In the end I would like my report to be able to show all the application monitors that fit that criteria and say for example here are the percentages of time they were in critical status or in unreachable status.
@zackm - I don't know the exact specifics of the hardware (I wasn't involved in that stuff) but I do know it has 24 logical CPU cores, 32GB RAM, and 4 240GB SSDs in RAID 10 for the database data. We currently have over 5000 nodes and 2280 component monitors.
1 of 1 people found this helpful
1) </drool> @ your server. that's a nice one for sure!
2) try this to get you in the ballpark. (ties in the nodes table so you can call your custom property)
select n.caption ,a.name ,d.availability ,d.percentavailability from apm_applicationstatus_detail d join apm_application a on d.applicationid = a.id join nodes n on a.nodeid = n.nodeid where d.percentavailability <> 100 and n.CUSTOMPROPERTY = 'stuff'
Just edit the last line according to your needs. You may have to work with this some more (maybe an AVG or something for your hourly stuff). If you have more questions, please let me know.
Loop1 Systems: SolarWinds Training and Professional Services
Could you please tell how is PercentAvailability calculated?
Also could you please explain a bit on the below query which derives PercentAvailability for this month's Application status. I didn't quite understand RecordCount as well.
max(APM_ApplicationStatus.TimeStamp) as Month,
APM_Application.Name AS ApplicationName,
sum(APM_ApplicationStatus.PercentAvailability * APM_ApplicationStatus.RecordCount) / sum(APM_ApplicationStatus.RecordCount) AS PercentAvailability
FROM APM_ApplicationStatus with(nolock)
INNER JOIN APM_Application with(nolock) ON APM_Application.ID = APM_ApplicationStatus.ApplicationID
INNER JOIN Nodes with(nolock) ON Nodes.NodeID = APM_Application.NodeID
WHERE APM_ApplicationStatus.TimeStamp >= dateadd(minute, datediff(minute, getdate(), getutcdate()), dateadd(month, datediff(month, 0, getdate()), 0))
GROUP BY APM_Application.ID, APM_Application.Name, Nodes.Caption
ORDER BY Nodes.Caption, APM_Application.Name