Upgrade to OpsCenter 7.7.3
Hi Guys, I'm planning to upgrade my environment to NBU 7.7.3. My problem now is that my current OpsCenter server runs on a Solaris server and and now Solaris is not listed here: https://sort.veritas.com/checklist/install#report . I can see all the other platforms but not Solaris. Does this mean OpsCenter 7.7.3 does support Solaris platforms ?
Opscentre report to report back arbirary timeframe for genuinely failed backups
Ops centre has a canned report for failed backups but thats not quite what I need: I need one that tells me a backup that ran and failed and didnt complete successfully at all over a period, ie the client wasnt backed up: thats primarily what we are interested in right? In other words, lets take a typical weekends set of full backups: I need to be able to report policy/client combo failed all attempts at backup ie for that combo I have not achieved a successful backup. Lets say failed means any non-zero status. I'm looking at the consecutive failures report....this may be what I'm after. Thanks in advance for your input.Jim.
Custom report needed - Daily success rate per data type
We have been using the daily success (stock) report but noticed it doesn't fit the needs - Specifically, I'd like to break it up so it seperates PROD from Non-PROD servers in the daily stats. All of the non-prod servers have a 't' in their hostname, so that should make it a simple And then, would like to separate it further between APP, DATABASE and OS backups ... Luckily, all application policies have the key word "APP" ... and databases have either SQL or ORACLE keywords in their policy. Finally, the OS backups all have "_Server_" in their policy name. The end-goal is to generate this for each day, going back for the last 30 days. But I would appreciate some guidance on how this can be accomplished ... nested queries ? JOIN or UNION statements ? Seems like I would have to build SQL queries to get each column data ... then generates percentage % columns for each ... and somehow combine into multiple columns and then 1 row per day. Let me know your ideas and I'll share the solution for all to benefit ...OpsCenter Custom Queries - is it possible to combine output from 2 queries?
I have created a custom query to report on the daily job status codes. And I would like to have OpsCenter combine both Queries into (1) report (i.e. Email) Is that even possible with OpsCenter SQL? I tried a UNION but no luck ... The first report, shows all the jobs with "Partial success" status codes 1 to 6 ... // --------- Query #1 --------- // SELECT clientName as 'Client', policyName, mediaServerName as 'Media Server', statusCode as 'Exit Status', UtcBigIntToNomTime(startTime) as 'Start Time', UtcBigIntToNomTime(endTime) as 'End Time', ((endTime - startTime)/600000000) AS 'Run Time (minutes)', parentJobId AS 'Job ID' FROM domain_JobArchive WHERE DATEDIFF(hour, UtcBigIntToNomTime(startTime), GETDATE()) <= 24 and statusCode > 0 and statusCode <= 6 and masterServerId = 61 ORDER BY 1,5 // ----------------------- // While, the second query lists the count for each status code ... // ------------- Query #2 ---------------- // SELECT statusCode AS STATUS, COUNT(*) AS COUNT FROM domain_JobArchive WHERE DATEDIFF(hour, UtcBigIntToNomTime(endTime), GETDATE()) <= 24 and masterServerId = 61 GROUP BY statusCode // ------------------------------------------- //