Custom report

Custom report

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

 

Thanks
Mostafiz

                New to ADSelfService Plus?