12-22-2010 04:28 AM
Hi,
We use NOM to generate an available media report, which provides us with information of tapes currently in the tape library with master server name, volume pool name and quantity (formed from slot number count). However I am having difficulty recreating this report in Ops Center Analytics.
Any ideas?
Thanks
Sarah
12-31-2010 08:51 AM
Does the report template "Media Reports > Available Media Report" help you? You may also drill down on "Media Summary by Media Server" by selecting the media servers.
I am not using Analytics. If you have this licensed version, one of the feature of this version is to create customized report by SQL command.
12-31-2010 09:04 AM
No as it lists all media and not the total amount (count), I tried to edit it but doesn't seem to work as desired. NOM works fine with it.
I need for example Manchester = Scratch 200 backup 100 etc... Amounts not tape ID's.
Do you have any sql examples? I am new to sql and not sure what to query or filter.
Cheers
Sarah
02-16-2011 08:35 AM
Ok I think I've found a way although I can't be 100% as my data collection is playing up at the moment but if you:
create a new custom report.
-> Subcategory: Backup Media
->Tabular report
Next Page
Time Frame:
Previous 10 hours (Mine is playing up so you might get better updates than me :) )
Filters:
-> Media: Backup Media Volume Pool Name = SCRATCH
Next page
Fields required:
Master Server
Tape Library Alias
Volume Pool Name
Operation:
Volume pool name = count
In theory what we are doing here is counting how many duplications of "SCRATCH" pool are there - as we have filtered only for scratch and the fact you have added Tape Library Alias you should get a report for each library on each master server. i.e:
Tape Library Alias | Volume Pool Name | |
Production | LONTLB04 | 3 |
Production | AMSTLB01 | 14 |
fingers crossed
02-17-2011 03:38 AM
This didn't work, the values were completely out.
Thanks
Sarah
02-23-2011 08:41 AM
Sarah - flick the time frame filter to "No Time Basis"
I tested it on mine and it shows the correct data
:)
I have also created a report which lets you know how many tapes will expire in the next 24 hours for each library if you're interrested let me know
02-24-2011 02:15 AM
Hi, no joy. Surely there should be an operation on slot or tape ID to count, so it counts the number or slots in the scratch pool?
Thanks
Sarah
02-24-2011 08:04 AM
You just want a list of tapes in each volume pool and a count of tapes in those poos, correct?
I'm using OpsCenter Ananlytics 7.0.1, so assuming this was not a changed report from your version:
Under Report Templates -> Media Reports ->Tape Count, edit the report, click "Next", and change the drop-down to report on Volume Pool Name, then click on "Run Report". Once the pie-chart shows up, the "Show Chart as Table" link appears.
If this is what you are looking for, you can save this edited report, and email it on a schedule (which will include the graph and the table below it), or add it to your Dashboard.
02-25-2011 08:56 AM
Sarah,
I've just done some screen dumps for you to follow just in case you missed something (and my wording is crap :) )
I checked them against my live environment and they are identical. I have also recently upgraded to 7.1 - whether this will have any bearing on you results
You have to save some of these pictures to your desktop to see the right hand side of them
Let us know how you get on.
Thanks
03-03-2011 09:46 AM
Looks like this report is reporting on images, NOT tapes. I'll open another case with Symantec on this one, too. Darn.
UPDATE 3/3/2011: further inspection shows that the default settings on the report seem to work fine and report on the number of tapes, but changing the "Report on" field to "Volume Pool Name" instead of "Tape Type" reports some wild numbers drawn from somewhere in the database, but it's not the number of images, not the number of bytes, not a sum of the numeric values of the tape numbers, etc. No idea how it calculates these values when you select "Volume Pool Name".