Hi Team,
I want to generate a report like below where each devices downtime value will placed in different columns. So far I found only sum of the downtime vale. Please assist.
Device Name |
From |
To |
Total Duration |
Ruoter1 |
9 Jun 2018 05:36:31 PM SGT |
9 Jun 2018 07:51:27 PM SGT |
2Hour 15 Minutes |
Router1 |
5 Jun 2018 11:37:38 AM SGT |
5 Jun 2018 11:42:35 AM SGT |
5 Minutes |
Router1 |
5 Jun 2018 11:22:38 AM SGT |
5 Jun 2018 11:27:37 AM SGT |
5 Minutes |
Router1 |
5 Jun 2018 12:07:38 AM SGT |
5 Jun 2018 2:07:36 AM SGT |
2 Hours |
Router1 |
4 Jun 2018 10:27:38 PM SGT |
4 Jun 2018 10:32:37 PM SGT |
5 Minutes |
Ruoter2 |
6 Jun 2018 11:37:38 AM SGT |
6 Jun 2018 11:42:35 AM SGT |
5 Minutes |
Ruoter2 |
3 Jun 2018 11:22:38 AM SGT |
3 Jun 2018 11:27:37 AM SGT |
5 Minutes |
Ruoter2 |
2 Jun 2018 12:07:38 AM SGT |
2 Jun 2018 2:07:36 AM SGT |
2 Hours |
Ruoter2 |
1 Jun 2018 10:27:38 PM SGT |
1 Jun 2018 10:32:37 PM SGT |
5 Minutes |