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

    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
    --,[v.CustomProperties]._Service_Location
    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 :)

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