UNSOLVED

sariaka

updated

14 years ago

S

sariaka

9 Posts

0

1162

January 31st, 2013 05:00

Customize DPA report

Hello All,

Recently, I would like to customize report DPA. I successed to do that :

Sauvegarde Avamar/Agents - Heure sauvegarde

Object

VMs / SITE

Succeeded

Failed

Total Size (GB)

Success Rate (%)

 

site1

70

64

6

18,0

91,4

 

site2

153

93

60

26,0

60,8

 

site3

50

30

20

12,0

60,0

 

site4

1

0

1

0,0

0,0

 

site5

119

73

46

29,0

61,3

 

site6

9

9

0

2,0

100,0

 

site7

235

225

10

42,0

95,7

 

site8

201

129

72

49,0

64,2

 

site9

64

45

19

49,0

70,3

 

site10

2

2

0

1,0

100,0

 

site11

8

8

0

5,0

100,0

 

site12

1

1

0

0,0

100,0

 

site13

186

171

15

27,0

91,9

 

site14

2

2

0

0,0

100,0

 

site15

8

8

0

1,0

100,0


site16

1

1

0

23,0

100,0

Total


1110

861

249

284,0


I could add a last line to have a SUM of VMS/SITES, Success number, Total Size. But I would like to have also the %Sucess Rate of the Total

i.e to do this operation : (Succeeded/VMS Sites)*100

i.e (861/1110)*100

%Success Rate = 77.568%

Anybody can help me please ?