Is there anyway I can import an alert into a report?

I'm trying to import this alert into a report./cfs-file/__key/communityserver-discussions-components-files/194/Disk_2B00_Capacity_2B00_Test.xml

I've been trying to create a report which will report on the top 10 nodes that are nearing 100% disk capacity and the specific disk that is close to full but I can't get it to work as it only ever reports back on one node. So I gave up and tried to turn a report into an alert and again it won't let me.

If anyone has the original report for Disks nearing 100% capacity it would be great if you could send me that to download again as I made the smart choice to delete it when trying to create my own! That will solve all these issues lol


  •     SELECT
         [Volumes].FullName AS [Node] ,'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node]
        ,[Volumes].Node.DetailsURL as [_LinkFor_Node]
        ,ROUND([Volumes].VolumeSize/1073741824,2) as Vol_GB
        ,ROUND([Volumes].VolumeSpaceAvailable/1073741824,2) AS GB_Free
    --    ,[Volumes].Caption AS [Volume]
        ,[Volumes].DetailsURL as [_LinkFor_Volume]
    --    ,[Volumes].Node.IP ,ROUND([Volumes].VolumePercentAvailable,2) as Avail_Percent
        ,ROUND([Volumes].VolumePercentUsed,2) as [UsedPercent]
        ,CASE WHEN [Volumes].VolumePercentUsed > [Volumes].ForecastCapacity.CriticalThreshold THEN '/Orion/images/StatusIcons/Small-Critical.gif' WHEN [Volumes].VolumePercentUsed > [Volumes].ForecastCapacity.WarningThreshold THEN '/Orion/images/StatusIcons/Small-Warning.gif' ELSE '/Orion/images/StatusIcons/Small-Up.gif' END AS [_IconFor_UsedPercent]
        ,ROUND([Volumes].VolumeSpaceUsed/1073741824,2) as GB_Used
        FROM Orion.Volumes as Volumes
    Where [Volumes].Caption LIKE '%\%' AND [Volumes].VolumePercentUsed > 80  AND [Volumes].Node.Vendor LIKE '%WINDOWS%'
    Order By [Volumes].VolumePercentUsed DESC

  • If this is the original report then thank you but thank you again if it's custom! Literally been on this most of today and can't get my own custom ones to work hahaha

  • That is a custom report you can create that will get you volumes over 80 percent which you can adjust. If you put Select Top 10 at the top is should be close to what you are trying to create. 

  • Oh mint that's great thank you mate much appreciated :)

Reply Children
No Data