Hello Experts, We have opscenter Analytics and need a custom report that should include Active Policy details with the below column . Its not possible in the template so May I have SQL queury for the below. The purpose here is to get as much as de...
Hi, is it possible to pull out old policies information(Policy type, storage unit(what i need)) just to make comparison between the current configuration with the old configuration? i tried using the policy comparison function on the opscenter b...
Hello, is there an easy way "how-to" to setup a daily email report on failed backups for each group like SQL, MySQL and/or Oracle using template? Thanks, BV
I'm beginner in OpsCenter and try to do some things with veiw_exportimport.bat . At the end of my test i have more then 15 unnecessary objects in ObsCenter, like this : <object id="o12" name="name.test" action="declare" type="GENERIC" dbic="226" />...
Hi, i wish to have a report that shows up the top 20 biggest (in data and backup size) servers for over the last 2 years (interval 1 month). is there a template because i couldnt find it or can anyone help me by providing the SQL query? a...
This is a weird problem. We needed to upgrade everything when the vulnerabiliy email came out. I was running 7.5.0.6 on everything. We decided to update OpsCenter to 7.6.1.2 as a stepping stone to 7.7. This is monitoring 5 netbackup environments, 2 r...
Hey all, I have a really nice dashboard setup. Is there way I can copy it or make it default so that all other users can see it?
I have made a daily scheduled backup-report about the status of my servers. When there are items, Opscenter send me a mail and that is correct. but.. when the list is clean no email has to be sent. But it is strange that happens. I select " Send em...
Hi All, Need help to find out a Opscenter query to find client server's names that are backing up in multiple policies. Thanks M@inak
I have to add new OpsCenter server entry in matser server properties for 500+ Backup domains. Could you please share if any script or easiest way to update the same instead of manully logging on each master and update through GUI (Hostproerties --> ...
Hello, I,m trying to use this query : SELECT DISTINCT A.clientName as 'Client Name', A.policyName as 'Policy Name', A.scheduleName as 'Schedule name', LIST( DISTINCT A.statuscode) as 'Status Code', ( select DATEDIFF(DAY,UtcB...
Hi, Could someone pleadse help me with the SQL script/steps to generate a list of all client list for a master server Opscenter version - 7.7.1
I thought that this would be easy... but alas, it appears not as easy as I was hoping. I'm trying to generate an hourly disk pool report for a re-sizing analysis. I would like to know hourly how my advanced disk pools are affected by our "regular" ...
Hi , Is it possible to send reports of backup failures only if there are failures. Currently we send out a daily report which will contain any failed overnight backups. Management have requested we dont send a report unless there are failed backups....
scenario-: In my environment there is time window is 22:00:00 to 21:00:00. So, i want to create the ops center report for those backup which is completed after the time window as "Late Success". need help.......urgently basis.
I have a SQL script that is recreating the Master Server Throughput report with Media Servers in place of the Master server. I am stuck on trying to figure out how to show the "Last Job" time. I know I can get each jobs end time via domain.Job or dom...
I am trying to figure out how OpsCenter combines reports such as Master Server Throughput and Total Jobs of a Server. I need to make the Media Server Throughput report have the same colunms as the Master Server Throughput report. I am running versio...
Hi, I have a problem with SQL query. I am not very familiar with SQL and this is probably the reason. The SQL looks: select (a.Id) as "Image", UTCBigIntToNomTime(a.writeEndTime) as "WriteEndTime", (select UTCBigIntToNomTime(c.copyDate) ...
I know this seems simple but I am looking for a SQL query (I'm not a query wizard) but I am trying to get the total data backed up on a daily, weekly and monthly basis for the master server and each media server My customer is saying that the data ...
Due to high volume of workload on my end, am not able to sit down & put this together hence need an urgent help with following in a tabular form- I've created different opscenter VIEWS, I would like to have following report for in thier respect...
