Custom Widget pulling information from different areas

Hi - I am trying to create a widget running information on Hard Disk space along with specific information on cpu load etc.

I am asking it to focus on a specific group rather than every node. Whats missing is the hard drive information

the SWQL script is below

SELECT n.Caption AS [Node Name]
, n.Status
, n.IPAddress
, n.StatusDescription AS [Status Description]
, n.DetailsURL AS [Node Details URL]
, n.MachineType AS [Vendor Name]
, n.VendorInfo.Icon AS [System Vendor Icon]
, n.CPULoad AS [CPULoad]
, n.ResponseTime AS [Response Time]
, n.PercentMemoryUsed AS [Memory Usge]
, n.PercentLoss AS [Packet Loss]
, CONCAT ('/Orion/SSH/Terminal.aspx?NodeId=' , n.NodeID) AS [SSH]
FROM Orion.Nodes n

LEFT JOIN Orion.ContainerMembers ON ContainerMembers.name=n.caption AND MemberEntityType='Orion.Nodes'

WHERE ContainerMembers.ContainerID = '122'

How do i join the information from 'orion volumes' section so i can display that part in my widget output?

Any help will be brilliant

Find more posts tagged with

Widgets

SWQL

Modern Dashboard

disc space

Accepted answers

All comments

nwbarwell

update

SELECT n.Caption AS [Node Name]
, n.Status
, n.IPAddress
, n.StatusDescription AS [Status Description]
, n.DetailsURL AS [Node Details URL]
, n.MachineType AS [Vendor Name]
, n.VendorInfo.Icon AS [System Vendor Icon]
, n.CPULoad AS [CPULoad]
, n.ResponseTime AS [Response Time]
, n.PercentMemoryUsed AS [Memory Usge]
, n.PercentLoss AS [Packet Loss]
, n.Volumes.VolumePercentUsed AS [Disk Space]
, CONCAT ('/Orion/SSH/Terminal.aspx?NodeId=' , n.NodeID) AS [SSH]
FROM Orion.Nodes n
LEFT JOIN Orion.ContainerMembers ON ContainerMembers.name=n.caption AND MemberEntityType='Orion.Nodes'

WHERE ContainerMembers.ContainerID = '122'

I have found a way to add it - My next question where does the "round" option go - Just so i can round the storage to the nearest whole number

jm_sysadmin

Here's a sample, first I change to GB, then I round to the first decimal place.

SELECT
--Data that I need
    -- Volume Name, status, URL, size, free space (GB), % free
    [Volume].[DisplayName]                                      AS [Volume Name],
    [Volume].[Status]                                           AS [Volume Status],
    [Volume].[DetailsURL]                                       AS [Volume URL], 
    Round( ([Volume].[VolumeSize]/1073741824),1)                AS [Size (GB)],
    Round( ([Volume].[VolumeSpaceAvailable]/1073741824) ,1)     AS [Free Space (GB)],
    Round( ([Volume].[VolumePercentUsed],1))                    AS [% Used],
    [Volume].RelyDatastores.DisplayName                         AS [DataStores],

    -- Server Name, status, URL, IP address, OS,
    [Server].[Caption]                                          AS [Server Name],
    [Server].[Status]                                           AS [Server Status],
    [Server].[DetailsURL]                                       AS [Server URL],
    [Server].[IP_Address]                                       AS [Server IP],
    CASE    
        WHEN [Server].[MachineType] LIKE '%Windows%'    THEN 'Windows'
        WHEN [Server].[MachineType] LIKE '%Linux%'      THEN 'Linux'
        WHEN [Server].[MachineType] LIKE '%IBM%'        THEN 'AIX'
        ELSE 'Unknown'
    END                                                         AS [OS],
FROM
--From the following location
    -- Volumes
    Orion.Volumes AS [Volume]
    -- Node
    INNER JOIN Orion.Nodes AS [Server] ON [Volume].[NodeID] = [Server].[NodeID]

Where 1 = 1
--When these criteria are met 
    -- fixed disk 
    AND [Volume].[Type] LIKE '%Fixed%' 
    -- is server
    AND [Server].[IsServer] = 'True'
        -- When less than 20 gb free
    AND [Volume].[VolumeSpaceAvailable] <= '20480000000'</pre>