2 Replies Latest reply: Mar 13, 2013 12:08 PM by jasonbku RSS

    Reclaim Space Report

    jasonbku

      VMs With More Allocated Space the Used, little widget is a nice tool, after I adjusted it to only show me systems that I can reclaim over 20GB worth of space. I would like to turn this into a scheduled report but I am having no luck even creating a report, could any one help me, I have not created any reports by hand before so this part is new to me.

        • Re: Reclaim Space Report
          Milan_Volejnik

          Hello,

           

          please follow instructions below:

           

          1) copy your query from the "VMs With More Allocated Space than Used" alert

          2) in Reporting - Data Export module choose Item Type, insert the query and select requested atributes (one by one or choose predefined templates). Then press Run Export button on the bottom left corner

          VMAN_Reports1.png

          3) after you insert report name the report starts to execute. When the report is completed you can make a schedule plan ("Configure" button). In Job Configuration window you can set recurrence of the report (Schedule tab) and also sending results via email (Notifications tab; SMTP server must be configured first in Setup - Advanced Setup - SMTP Configuration).

          VMAN_Reports2.png

          4) in Explore - Content menu you can see all the created reports

           

          Note to scheduler: the cron used in VMAN is Quartz Cron, see this link for details.

           

          Please let us know if it helps or not. Thanks.

            • Re: Reclaim Space Report
              jasonbku

              Problem is this widget doesn’t look like it is running a query, but instead performing some math, and then presetting a list with the Math it came up with. Yes the screen shot you added has a query but the power of the widget is the math

               

              If you look at the widget “VMs With More Allocated Space then Used” you will see what I would like to get sent in a weekly email.

               

              if (/virtualMachine/totalStorageSizeUsed - (sum(/virtualMachine/diskVolume/capacity) - sum(/virtualMachine/diskVolume/freeSpace)) <= 0) then 0 else /virtualMachine/totalStorageSizeUsed - (sum(/virtualMachine/diskVolume/capacity) - sum(/virtualMachine/diskVolume/freeSpace))

               

              And only showing greater then 20GB of reclaimable space.


              Can this be put into a scheduled report?