Hi fdiaz,
Yes, I took part in the MG216-L: OpsCenter and OpsCenter Analytics Hands On Lab. You can find attached a text file with both SQL Querys.
Regards,
César.
Hey Cesar...since you attended Vision did you take part in the MG216-L: OpsCenter and OpsCenter Analytics Hands On Lab ??? On page 18 it talks about two SQL Query that were used during the hand on lab...
Custom SQL Reporting
OpsCenter Analytics offers the ability to use custom SQL scripting to pull reports. This is pretty advanced stuff and requires the customer to understand the SQL database structure, command calls and know how to make use of the Schema that we publish. Not for the faint hearted. While it is beyond the scope of this HOL to show you how to create a custom SQL report, we did want to show you what one looks like. If you are interested in doing this, follow these steps which should take just a few minutes.
Most customers who run dedupe are asking about “dedupe savings”. Is it really worth it? While the canned OC reports can show this at a glance, it doesn‟t really drill down into the data to truly show a nice table breakdown of the savings. Check out these custom SQL queries that really show it off.
1. Click on Reports
2. Click on Create New Report
3. Select Create a report using SQL Query
4. Click Next
5. On your desktop, locate a file named “OCA Custom SQL 1.txt and open it with notepad
6. There is information about the script and what it will be doing to pull the information in the top part of the .TXT file. Read it.
7. Highlight the text in the second paragraph starting at SELECT „Last 24 hours‟ all the way to the end
8. Copy this information and paste it into the SQL Report box
9. Click Next
What you will see is a report showing the dedupe information from the last 24 hours, seven days and a total. It shows how much information was “Pre Dedupe” and the breaks it down to how much was actually backed up. This is a powerful report for a customer who wants to know how much storage space is being saved by dedupe.
Now, lets say they want to see it per Policy. Check this out.
1. Click Back to get back to the box you pasted the report into
2. Open OCA Custom SQL 2.txt from the desktop
