Symantec Management Platform (Notification Server)

 View Only
  • 1.  Physical Drive Report / Pie chart

    Posted Aug 19, 2009 03:01 PM
    Hi,

    I'm trying to create pie chart/dashboard for % free drive space for just one of our File Servers.

    I know KB 34368 explains how to create a pie chart...however i need to modify this report first.

    View -  Inventory Solutions - Reports - Windows - Physical Drive - Disk Free Space Less that 'N' Percent

    Basically this report brings back results for each physical drive on my server, which is fine, except i want a pie chard for each drive.

    Question is....how do i specifiy a Drive letter? Say D:?
    The report below shows g. [Device ID]  [Drive]

    I'm assuming i need to change the 'Device ID' part?

    SELECT DISTINCT 
        i.[Name],     
        g.[Device ID] [Drive],    
        g.[Free Space in MBytes] * 100 / [Size in MBytes] [Free Space %], 
        g.[Free Space in MBytes] [Free Space(MB)], 
        g.[Size in MBytes] [Total Size(MB)],   
        g.[_ResourceGuid] [ResourceGuid]   
    FROM dbo.vComputer i    
        JOIN dbo.Inv_AeX_HW_Logical_Disk g    
            ON g.[_ResourceGuid] = i.Guid   
        JOIN dbo.Inv_AeX_AC_Identification d   
            ON d.[_ResourceGuid] = i.Guid  
        JOIN dbo.CollectionMembership cm   
            ON cm.ResourceGuid = d.[_ResourceGuid]  
    WHERE g.[Size in MBytes] IS NOT NULL    
    AND g.[Free Space in MBytes] IS NOT NULL   
    AND g.[Size in MBytes] <> 0   
    AND g.[Description] = %Type%    
    AND g.[Free Space in MBytes] * 100 / [Size in MBytes] >= %Free Space Percent%    
    AND d.[System Type] LIKE 'Win%'    
    AND i.[Name] LIKE '%ComputerName%'   
    AND d.Domain LIKE '%Domain%'   
    ORDER By [Free Space %]


  • 2.  RE: Physical Drive Report / Pie chart

    Posted Aug 20, 2009 01:39 AM
    Does someone know how i include the Real Time summary report on a web portal???


    imagebrowser image




  • 3.  RE: Physical Drive Report / Pie chart

    Posted Sep 02, 2009 03:40 AM
    ...bump....


  • 4.  RE: Physical Drive Report / Pie chart

    Posted Sep 02, 2009 11:27 AM
    in the report you posted, that it is limited to a single drive. Is the RTS summary a report or a dashboard?


  • 5.  RE: Physical Drive Report / Pie chart

    Posted Sep 07, 2009 09:48 AM
    Hi,

    Basically when you right-click on a server, and go to resource manager and the Real Time System, and summary it gives you the pie charts above relating to the physical drives free space and used space.

    I'd like to create a dashboard which has this view constantly available or displayed. and was wondering if there is simply a way to link a dashboard to the summary pie charts of the drive space.

    Steve