Is there a way to extract the last used backup policy info for a retired client?

The avamar version is 7.2.1-32

I'm looking for sql query to retrieve the last used backup policy for a retired client.

I need info for policy group, schedule, dataset, retention and plugins.

Is the information available in the database at all?

If yes, how can it be retrieved?

I've lost a whole day and haven't found anything. Can anybody help me?