01-09-2014 02:55 AM
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
Solved! Go to Solution.
01-09-2014 03:55 AM
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 ;)
01-09-2014 03:55 AM
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 ;)
01-09-2014 06:07 AM
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
01-09-2014 06:27 AM
*edit*
never mind, your way is easier
01-12-2014 08:56 PM
Yes the command output is sometimes hard to manipulate because it list thing below each other and it could have multiple instances too.
01-15-2014 06:51 AM
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.
01-15-2014 11:05 AM
Hi,
Please explain more about this. Are you getting this information from the opscenter database?
Riaan
01-15-2014 01:34 PM
That certainly looks like OpsCenter SQL query.
01-16-2014 01:00 AM
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 :)
01-16-2014 02:14 AM
01-16-2014 07:01 AM
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
01-16-2014 10:32 PM
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 :$