New report

xAyiDe

Hi,

 

Anyone keen on reports? I want to make a report that counts total disk space on all managed devices and shows only one row summarizing total free and total space of all devices on network. Is this possible?

 

qle

I'm new to creating reports but if I understand what you're asking for, it should be pretty simple. Just create a new "Advanced SQL" report and paste the following into SQL tab:



select sum(volumespaceavailable) as SpaceAvailable, sum(volumesize) as TotalSpace from volumes where volumetype = 'fixed disk'



It's a very simple report listing the total available space and total space of all "fixed disks". The only problem is that Orion seems to classify "DOS Buffers" and "Cache Memory" as "fixed disks" as well.