Solved!
Go to SolutionB
Bj_rnMartinLars
9 Posts
0
1563
April 29th, 2009 03:00
StorageScope, custom query/report question
Hi
Recently installed StorageScope for a customer, and they would like to create a custom query that generates a report, to show the relationship between host, hba, lun/symmid and FA ports on the symmetrix, basicly the vcm-database on the symmetrix. I could dump the vcm database to a txt-file and import it to excel or similiar, but i'd have to manually map the wwn's from each hba to a server-name, which is alot of manual labor, so it would be nice to be able to do this in Storage Scope. I've tried for a while to get a custom query to do this for me, but so far i've not ended up with what i want, or the query has failed somehow
So, anyone have any good ideas to create such a query, that generates an output somewhat similiar to the example below ?
And i guess i might aswell ask if someone knows if there somewhere is a collection of useful custom query/reports that it would be possible to "import" into Storage Scope, and be able to play around with and see what is useful for this customer ?
Thanks in advance.
Recently installed StorageScope for a customer, and they would like to create a custom query that generates a report, to show the relationship between host, hba, lun/symmid and FA ports on the symmetrix, basicly the vcm-database on the symmetrix. I could dump the vcm database to a txt-file and import it to excel or similiar, but i'd have to manually map the wwn's from each hba to a server-name, which is alot of manual labor, so it would be nice to be able to do this in Storage Scope. I've tried for a while to get a custom query to do this for me, but so far i've not ended up with what i want, or the query has failed somehow
So, anyone have any good ideas to create such a query, that generates an output somewhat similiar to the example below ?
Host 1 HBA-1 Lun 1 FA-1C-0, FA-16C-0
HBA-2 Lun 1 FA-1C-0, FA-16C-0
HBA-1 Lun 2 FA-1C-0, FA-16C-0
HBA-2 Lun 2 FA-1C-0, FA-16C-0
Host 2 HBA-1 Lun 4 FA-1C-1, FA-16C-1, FA-1D-1, FA-16D-1
HBA-2 Lun 4 FA-1C-1, FA-16C-1, FA-1D-1, FA-16D-1
And i guess i might aswell ask if someone knows if there somewhere is a collection of useful custom query/reports that it would be possible to "import" into Storage Scope, and be able to play around with and see what is useful for this customer ?
Thanks in advance.
848
1
Posted April 30th, 2009 11:00
You can do this through SQL query using SRMHostArrayPath and SRMArrayPortToDevice.
1. SRMHostArrayPath gives path host -> host HBA -> Switch -> Array port. If you do not care about switch, you do not need to select switch.
2. SRMArrayPortToDevice shows array devices (Lun) and their frontend ports.
3. Then join ArrayPortKey for these two tables, you would be able to get information for Host, Host HBA, Array Port, Lun848
0
Posted May 4th, 2009 02:00
Thanks!
This more or less gave me what i wanted. Would be even better if it displayed the HBA as say "Adapter-1@hostname" instead of the WWN, but can live with that.
What i found very strange while running this query though, is the fact that storagescope lists out many more LUN's than the host really has access too, spread over multiple FA ports that it doesnt have zoned. And yes, i've double-checked some of those "extra" luns, and they are not masked/granted to this host at all in Control Center, but still Storage Scope lists them..... very weird.
If i look at the host in Storage Scope (SRM views), it says the host has 17 allocated luns from the symmetrix in question. The actual query returns 1956 rows however, making it really hard to dig out the actual useful information, hidden in what seems to be alot of wrong information.
Doh, i'm guessing my filter(s) are'nt good enough to only show the luns allocated to a spesific host... i'll keep on trying to see if i can figure out a way to do that, or if somebody has a good idea how, feel free to let me know
Update: Sort of started from scratch again, and eventually got it working like i want it to
So thanks for the help!
Message was edited by:
BjornMartinLarsen
Message was edited by:
BjornMartinLarsen848
0
Posted May 7th, 2009 12:00
I like this idea. It would be nice to have the Control Center Community have a sticky in the forum where we could post our custom queries to share with the community. We all don't have to re-invent the wheel every time, we would all learn a little bit from looking at how the queries were done so we all get more efficient at creating the reports we need. Moderator, can we do this???848
0
Posted May 7th, 2009 13:00
Tim,
Unfortunately, it does not look like sticky threads are possible on these forums.
Regards,
Séamus
RMSG Forum Modetator
Message was edited by:
Seamus Coffey
Message was edited by:
Seamus Coffey848
0
Posted May 8th, 2009 06:00
Hi All,
this is something that we intend to do on the ControlCenter Online Community. Its more suited to hosting xml files, how to videos etc and has some interesting material on there already.
Right now there are no Custom Queries on there but we plan on adding them shortly and having our resident expert on StorageScope Repository create some to act as a starting point for users to contribute theirs.
www.controlcentercommunity.com
thanks,
Barry848
0
Posted May 13th, 2009 09:00
Thanks Barry. I just went out and signed up. It really looks like if you can really push the word out there, it will be a nice community. I am looking forward to it.
Thanks,
Tim
murphy_long
3 Posts
848
0
Posted April 30th, 2009 13:00
step1 .create a query
step 2. check hosts,hbas and host arrays from the Hosts box.
in the Arrays box check Arrays, LUNS and Ports.
step 3. select columns "Hosts.Host Name", "Host.Host System Name","Arrays.Array S/N", Arrays.Symmetrix Family" "port.Array Port Name","HBAs.Node WWN" and LUNs.LUN Name".
step 4. select next or add a filter.
step 5. save and RUN
You can edit what to add or remove.