List Policies that have a specific schedule

[-matt-]

NBU 7.5.6
Master Win2k8 R2

Hi all,

Does anyone know a way of listing policies that have a specific schedule?
It appears possible in the admin console  - Policies - Summary of all Policies, adding Policy Name to the column layout, and indexing the list by the required schedule name, but unlike the other views in the Summary, you cannot copy and paste out to excel for example.
bpplist seems to be where I need to head, but I'm no good at manipulating the output.

Thanks in advance.

Matt

[RiaanBadenhorst · Accepted solution]

Hi Matt,

You'll need to port this to windows (playing with dir and findstr maybe).

On linux I can run the command below where 10min is my schedule I'm looking for.

find /usr/openv/netbackup/db/class -print | grep 10min | egrep -v 'days|info'

Output is this, where TEST2 and TEST are the policies that have the above mentioned schedule.

/usr/openv/netbackup/db/class/TEST2/schedule/10mins
/usr/openv/netbackup/db/class/TEST/schedule/10mins
 

I don't see any NBU commands that will give this to you without putting the output into an array with perl and then manupulating it. Which is probably what you're seeing when you looking the in the GUI.

So yeah, this is not what you've asked for, but it gets you the info ;)

[-matt-]

Thanks Riaan,

I'd not thought to look at the folder structure on the file system.

dir schedule_name /s /b

although not the most elegant it did result in the output I need.

Appreciate you post.

Matt

[Will_Restore]

*edit*

never mind, your way is easier

[RiaanBadenhorst]

Yes the command output is sometimes hard to manipulate because it list thing below each other and it could have multiple instances too.

[Falquian]

Hi, Matt:

Have a look at this query :)

select vi1.Name [Shared Schedule], i2.Name [Item using Shared Schedule]

from dbo.ItemSchedule isc

join vItem vi1 on vi1.Guid = isc.ScheduleGuid

join Item i2 on i2.Guid = isc.ItemGuid

where vi1.ClassGuid = '79181A10-E30E-4823-BC52-2AC63B918AAA' --Shared Schedules

order by vi1.Name, i2.Name

You can create a report based on it.

[RiaanBadenhorst]

Hi,

Please explain more about this. Are you getting this information from the opscenter database?

Riaan

[Will_Restore]

That certainly looks like OpsCenter SQL query.

[Falquian]

Hi:

It's a query you can use to create a report, so you'll see all the policies linked to all the shared schedules in your altiris implementation. Once you have the report, you can run it whenever you need :)

[Marianne]

in your altiris implementation.

HUH? This is NetBackup!

[Will_Restore]

Hmm, I see Falquian posted same in Notification Server thread

https://www-secure.symantec.com/connect/forums/what-does-nshourly-do

It doesn't seem to work well with the question in this thread, which has been solved anyway.  The simple solution was Windows command posted by Matt above. 

dir schedule_name /s /b

[Falquian]

Now I see in the header of the first message that you are referring to NBU...I'm really sorry for not realizing of that detail.

I thought you were asking for help in SMP, and that what I offered.

Sorry for the inconvenience :$