P.Bhattacharjee ✭

Comments

  • Use this SWQL in a Custom Report (Advanced Database Query → SWQL): SELECT DISTINCT n.Caption AS [Node Name], n.IP_Address AS [IP Address], n.MachineType, hi.Name AS [Sensor Name], hi.OriginalStatus AS [Status], hi.Value AS TemperatureRaw, CASE WHEN hi.HardwareUnit.Name = 'DegreesC' THEN ROUND(((hi.Value * 9.0) / 5.0) + 32,…
    in Cisco Switch Temperature Reports Units in Farenheight Comment by P.Bhattacharjee March 19
  • @naveensingh43 Try creating reports with the below . 1) Nodes without disks (no fixed volumes monitored) SELECT n.NodeID, n.Caption, n.IPAddress, n.Vendor, n.ObjectSubType AS PollingMethodFROM Orion.Nodes nLEFT JOIN Orion.Volumes v ON v.NodeID = n.NodeID AND v.VolumeType = 'Fixed Disk'WHERE v.VolumeID IS NULL AND (n.Vendor…
    in “Nodes Without Monitoring” Health Report Comment by P.Bhattacharjee March 19
Avatar