Thanks both. However I need it in a format where I provide the client name, and get the client policy name and last successful backup in a format like:
<client name> <policy name> <last successfull backup>
You should have asked for that information originally.
I can think of two ways to do what you want, one is with OpsCenter (not sure which report or whether you would require some customer SQL), the other would be using bperror and a bunch of scripting to filter out the information you want.
Look at the output from "bperror -client <client name>" (and then review the syntax for the bperror command). Problem with this is that it won't display policies that haven't been run for a period of time (>30 days), as the input for bperror has a limited range back. You may therefore need the output from the original command suggested to determine which policies the client is part of to ensure you report accurately.
Someone may have already done this and be willing to share their scripts.