How can I get a list of hosts using a particular retention

[nevix]

I know how to find a list of all the policies using a particular retention but I really need to have a list of hosts.  I do not want to go through each policy 1 at a time as I have over 100 policies using the retention level I am interested in.

[revarooo]

I don't know of any way you can do that. Opscenter might be able to do it.

Any reason why you need to do this?

1 policy may have multiple schedules with different retentions. Also you may have a client in multiple policies too

[RiaanBadenhorst]

bpimagelist -rl "retention level" will show you all images for the specific retention level (as derived from bpretlevel).

You can customize that and add -client / -policy / -d start date / -e end date

As mentioned above, OpsCenter can do it as well, let me know if you need that.

[Marianne]

Or you can use bppllist output, pipe to egrep to get the particular retention and associated client names.

[revarooo]

Riaans suggestion would work, but any changes to schedules retention lists would not be reflected in the output derived from bpimagelist.

Depends what you actually want here?

[RiaanBadenhorst]

Yes, bpimagelist will show you what its retention is. If for some reason it was changed since back it would not be reflect. This isn't supposed to be an audit mechnism.

[nevix]

I am trying to find the hosts that have a retention outside the standard offering.  Once I have this we will have to contact the owner of said hosts to confirm deviation from the norm.

~Kevin

[revarooo]

What Retention Level is considered "standard offering" and what represents "non-standard" from the bpretlist command output?

[nevix]

Our Standard are retention levels 10 and 1.  The one I am concerned about because of the high number of schedule count is 8.  The other levels only have a handful of references and can easily be filtered by hand.

~Kevin

[revarooo · Accepted solution]

try this - Linux/Unix only:

for policyname in `bppllist`
do
RL=`bppllist $policyname | grep "^SCHED " | awk '$6 == 8 {print $6}'`
if [ "$RL" == "8" ]
then
echo "Policy name: $policyname is retention $RL"
bpplclients $policyname
fi
done

The 8 is your retention level - change this if you need to.

[nevix]

Thanks... I will try this.