We want to create a report which will show the events like power supply up/down for past 7 days or 20 days? Specifically we need only power supply status in hardware. Default report will just show you the current status like up/critical but didn't give you the event data. So we need to capture the events happen in the past days for particular power supply sensor(Mainly AC power supply or power module status). Rest of the power supply sensor we don't need.
I tried to apply filter on existing report but still that shows all power supply sensor like voltage sensor etc even those are disabled now. But still this report would not serve my purpose as i need events when this happen with the date and time and name of that supply sensor (hardware type name). So both the event and overall hardware status table are different and I am not sure how to pick up those values and represent them in proper format.
For these specific devices I do have custom property which i tried in the filter and able to get those devices but only issue with the events data.
we have event retention period of 20 days.
