It is possible to create a Report with the following values from SolarWinds.

That is, that each value of a node at the end adds up to 100 for a period of 1 day, 1 week or even 1 month???

Example...

NodeID	Caption	1.- % Availability	2.- % Warning	3.- % Critical	4.- % Unknown	5.- % Unmanaged	6.- % Flapping	7.- % Hard Down	8.- % Downtime	9.- % N/A	TOTAL
1	Switch 1	100	0	0	0	0	0	0	0	0	100
2	Server 2	50	10	10	0	30	0	0	0	0	100
3	VMWare 3	25	0	0	0	75	0	0	0	0	100
4	Storage 4	80	10	10	0	0	0	0	0	0	100
5	Firewall 5	0	0	0	0	0	0	0	100	0	100

I am using this table "dbo.ResponseTime ", but do you know if there are others that I should consult?

Thanks

Find more posts tagged with

solarwinds reports

hybrid

npm

report

Accepted answers

All comments

adam.beedell

Sounds like either you use the status/availability/percentdown stat, or it'll be very hard
Probably "flapping" is in the warning/critical sections, itherwise it's not a defined status so you'd need to remove it from one of the others. Same with Unknown and N/A

Might need a bunch of case statements and a CTE or two

jjhj

I'm going to look up what you tell me, in any case, and if you already locate the name of the tables involved, it will be a pleasure to read you again.