Report: UPS Status (Detailed)

[francisswest]

Good morning!

We have a need to see detailed UPS information, so we did some customizations and ended up with this report:

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tsysassettypes.AssetTypename,
  tsysassettypes.AssetTypeIcon10 As icon,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  tblUps.Model,
  tblUps.BatteryStatus,
  tblUps.EstimatedMinutesRemaining,
  tblUps.EstimatedChargeRemaining,
  tblUps.BatteryTemperature,
  tblUps.BatteryVoltage,
  tblUps.BatteryCurrent,
  tblUps.AlarmsPresent,
  tblUps.Manufacturer,
  tblUps.LastChanged,
  tblUps.Name,
  tblUps.AttachedDevices,
  tblUps.UpsSoftwareVersion,
  tblUps.AgentSoftwareVersion,
  tblUps.SecondsOnBattery
From tblassets
  Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
  Inner Join tblUps On tblassets.AssetID = tblUps.AssetId
Where tblassetcustom.State = 1

Time has been weird, so I cannot remember if I snagged half of this from somewhere, straight up plagiarized it, or created it from whole cloth.  If it was your report and I just snagged it, sorry, just trying to contribute back to the community.

Thanks!

[rader]

Mine is very similar and I've added tblAssetCustom.Serialnumber to the report. This aligns with tracking the UPS serial number on the edit asset screens. Some UPS's don't give up the serial number of the UPS, only the network card inside. Looking at you CyberPowerSystems. 😀