tblUps.BatteryStatus Descriptions

[netops1]

I am creating a custom report working off of the tblUps table. That table has BatteryStatus which is an integer. What table do I need to link to to get the names we see on the asset page? In my case, I have a status id of 2, which shows as "Normal" when viewing the asset.

[netops1]

Thanks!

[RCorbeil]

Refer to the database documentation, always available as a link from the report editor. ("View database documentation", immediately to the right of the title text box.)

Name: BatteryStatus
Type: int
Comment: Status of the UPS battery. If no value is stored, the battery status is unknown. Value Meaning | 2 normal | 3 low | 4 depleted |