Need to generate the daily backup report by scripting

Hi ​@Surya 

I don’t know if it’s possible to extract a report as you asked. 
I think, if you add kasten to the VBR probably there will be a way to do this.

​@Surya -- Were you able to get an answer to your question?  If so, please help the community by posting the answer and then selecting the best answer that helped you achieve this even if it is your own.

Hello @surya, normally you can use the Kasten RestAPI to do it.

I have used below workflow

VMaaS Backup Report Script – High-Level Logic

1. Connects to both openshift clusters  using Kasten API tokens.

2. Fetches RestorePoints created in the last 24 hours.

   • RestorePoints provide:
     • VM Name
     • Namespace
     • Policy Name
     • RunAction Name
     • Backup size (upload size)

3. Builds a lookup between:

   • RunAction ↔ RestorePoint
   • This helps identify which backup belongs to which VM.

4. Fetches all RunActions from Kasten.

   • RunAction is the actual backup execution record.
   • Contains:
     • Start time
     • End time
     • Status
     • Exceptions/Error details

1. Identifies failed VMs from RunAction exceptions.

   • Extracts VM names from:
     • appName
     • virtualMachine
     • other VM references in the exception payload.
   • Filters out disk names (-datadisk, -rootdisk).

2. Extracts VM-specific error messages.

   • Parses Kasten's FailedAppActions exception payload.
   • Locates the failed VM entry.
   • Traverses the exception chain.
   • Ignores generic wrapper errors such as:
     • Job failed to be executed
     • Failed snapshots for workload
     • Error snapshotting volume
   • Captures the actual root cause message.

3. Collects backup size

   • Reads RestorePoint Details API.
   • Extracts uploadSize.
   • Converts MB/GB/TB to MB.

4. Creates final report

   • One row per VM.
   • Includes:
     • Region
     • VM Name
     • Namespace
     • Policy Name
     • Status
     • Start Time
     • End Time
     • Transferred Size (MB)
     • Error Message (if failed)

5. Generates Excel report.