I sent report everyday by mail thanks to DPA : it is "Backup job summary"
this report is an excel (attached), so when users received the mail they have for example this result :
,Object,VMs / SITE,Succeeded,Failed,Total Size (GB),Success Rate (%)
The result is'nt very understandable for users. I would like to add post-script before sent mail to users. I think we can do it, but I don't know how to do it.
Someone has already did that ? Someone know how to do it?
Yes DPA does provide the option for you to apply a post-processing script to the generated scheduled report. The steps would be:
- write your post-processing script to format the data as you require
- in the DPA UI select Tools, Scheduled Report Editor, open the scheduled report in question and then enter the location and name of the post-processing script into the post-processing script field in the Advanced tab
Alternatively DPA provides other output options other than csv which may be better suited to your users (i.e. html)
Thank you very much.
I would like to convert the ";" to table
I'm not very strong to write scripts. Have you an example of script for me please?
In effect, users want backup of the report, they need csv format 😞
I found a script to delimite csv file to table.
In order to insert the script into the report :
I have to write the path at the "Pre-Processing Script" or "Post-Processing Script" ?
I think DPA don't considere my script. It's a vbs script like that :
Const xlDelimited = 1
Const xlNormal = -4143
Dim CurrentPath : CurrentPath = LCase (Replace (WScript.ScriptFullName, WScript.ScriptName, "")) 'Current path
myDateString = Replace (Date(), "/", ".")
Set Excel = CreateObject("Excel.Application")
.Workbooks.Open CurrentPath & "\Sauvegarde Avamar Agents.csv"
.Sheets(1).Columns("A").TextToColumns .Range("A1"), xlDelimited, , , , True 'semicolon-delimited
.ActiveWorkbook.SaveAs .ActiveWorkbook.Path & "\Sauv_Avamar_DD_sites-" & myDateString & ".csv", xlNormal
I specify the path as you tell me, but nothing change :
Thanks a lot
The picture has not come through in the post. Please could you let me know what path you specify in the post-script field?
For the test, I specify this path in advanced :
with default template
in basic Publication method :
Report Format : Comma Separated Values (csv)
Publish via : File
File name : Sauvegarde Avamar Agents
What you have configured appears to be correct. At this stage I would recommend raising a support case via EMC Powerlink. The DPA support team can then investigate to make sure the product is correctly trying to run the script. When you raise the case please attach a copy of the publisher.log from the DPA server as this should contain any error messages when trying to run the script.