02-18-2019 04:56 AM
02-18-2019 08:13 AM
I need a Netbackup script to check what all active clients do not have full backup from last 1 month.(active clients only --- not for clients which are in the deactivated policy)
I need only clinet details which are in the Activated policy only.
I have VIP environment.Vmware backups using VIP(Query)
or a SQL query for OPSCENTER Analytics will also help.
02-19-2019 01:17 AM
I use the SQL query below to report the last backups of every client/policy combination. To show Active clients only is a bit complex and tricky, because there are additional OpsCenter tables (domain_policy, domain_client, domain_policyclient) with relations between them and with many attributes indicating is thery are active, valid, in a policy, or retired..
In addition, you use VIP in your policicies, so you cannot say in advance which client will be picked up in which policy. One client can be picked up by more policies, some of them can be active, some not... So I think it is a complex task for a SQL guru.
So giving this SQL as a basic.
select policyname,clientname,max(UTCBigInttoNomTime(starttime)) "LAST BACKUP"
and statuscode in (0,1)
and policyname in
(select name from domain_policy where active=1 and status=0 and isvalid=1 and name not like 'test%')
group by policyname,clientname
order by 3 asc
02-19-2019 03:49 AM
Thanks for the opscenter SQL query but this is not fulfilling my aim.
I need only those clients in the output which are in the active policies and dont have full backups from last 1 month.Not the clients which are in the deactivated policy.Only the clients in the activated Policy.
I have VIP also configured in the Environmrnt along with MS windows backups.
02-19-2019 07:09 AM
it is not necessary to repeat the same for the third time. I have given you some hint and now you should attempt to complete this task by yourself.
02-19-2019 07:15 AM
I have very less idea for these SQL custom opscenter scripts thats why I am asking here in the forum.
I have ran the script provided by you but its not what i required.Its my humble request if anybody can provide me with the opscenter Custom SQL script for this or the Linux bash script.It would be really helpful.
02-19-2019 04:47 PM - edited 02-19-2019 04:51 PM
Erm, sunds like a gross misunderstanding of purposees of the forum, I thought they are to exchange ideas and experience, usually if you need a custom scripting job done and have no idea how to do it, you'd hire something and reasonably expected to pay for it.
02-23-2019 01:23 AM
If I can be helped by any script on this?
03-05-2019 02:27 AM
I agree with Mouse, I can give some ideas on powershell if you are on Windows ?
01-20-2022 02:10 PM
Did you manage to get a solution to requested SQL query. If you did can you share?
a week ago
please share the Windows Powershell script
i have the list of clients with me in a client.txt file
a week ago