- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2024
06:52 PM
- last edited on
‎05-15-2024
03:23 PM
by
Riley
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2024 12:26 AM
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. 😀
