This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Volume Report - Fixed Disk - Available - Size - Used - overall volume capacity with Thresholds

SolarEGGs lol that always makes me laugh anyway,

Here is a report for a question that i wanted to answer and i know that before i post this i have wayyyyyy OVER  thought this and yea sure it can be done in the SolarWinds interface but i want to become awesome supreme SolarWinds SQL genius emoticons_happy.png

So off we go..

the first part of this report is selecting the volume size's, volume space used, volume space available, percent used by adding them all up giving you the total volume sizes. i have based the where statement to only show vendors like Windows and select the volume type as Fixed disk thats all thats really happening here in the first part. you can indeed change the where statement to include custom properties and group your beloved nodes how every you want.

--you can edit this WHERE statement to filter the out any nodes you want to see  in the report

WHERE(n.n_customer like 'name of Customer') AND VolumeType IN('Fixed Disk', 'FixedDisk')

pastedImage_13.png

Version 1.3

***NEW***

Report features:

  • Report now includes THRESHOLDS per volume that will check the thresholds of your volumes and present them here.
  • Order percent used by highest first
  • clickable drives for direct volume landing page
  • clickable Nodes for direct Node landing page
  • report includes volumes, Size, Used, Available, Percent used, Warning Thresholds, Critical thresholds  
  • custom properties enabled for customer and any CP you use to group nodes

WHERE

-- you can change this report to only show your customers or vendors any CP you want really

(n.n_customer LIKE 'name of Customer') AND (VolumeType like 'Fix%') AND (n.Vendor like 'Windows')

to group the nodes simply

pastedImage_3.png

your end product will look like this emoticons_grin.png

pastedImage_0.png

Simply download the attached for the two reports and one SUPER important thing to remember is

stay EGGY SolarWinds emoticons_silly.png

please feel free to ask any questions on improvements or adjustments

credits to alexslv​ for the rounding and converting magic.

attachments.zip
Parents Reply Children
No Data