2013-12-13 07:17 AM
I want to build a workflow that lets the user choose a filer->volume->snapshot, clone from that snap, and map the lun in that clone to an igroup on that filer with a pre-set LUN ID (say 15 or 16).
I also want to build a reverse workflow that will take that flexcloned lun, UNMAP it, and then destroy the cloned volume.
Having trouble getting my head around how to do this. BTW, this is on 7-mode.
Thanks for any advice/help.
Solved! SEE THE SOLUTION
2013-12-15 07:08 AM
I don't believe there is a workflow that's been shared that does exactly what you've requested. That said, there are several workflows that get close, but I think those are for clustered ONTAP, not 7-mode. I'm not sure if you've looked through all of the "Pirate Packs" that are shared on the WFA communities, but it might be worthwhile doing so. Here is a LINK to see the available Pirate Packs. You can also click on the 'Workflow Examples' category, and look at the documents to see the other examples of workflows that have been shared.
Hope this helps,
2013-12-15 07:22 AM
Thanks- I got the Clone one to work (developed my own workflow), working on the Map Lun part and feel comfortable that will work as well. Found some issues with WFA2.1, installe d 2.0.1 and had greater success.
One thing that would be VERY helpful- can someone publish the database schema of objects your can SQL against when creating queries in the user inputs? I find I have to select * and test to see what fields I have available, or dig through the dictionairies. There should be a reference doc out there- is there one? Must be. Link someone?
2013-12-15 08:15 AM
@Found some issues with WFA2.1, installe d 2.0.1 and had greater success.
What issue did you run into with WFA2.1 that you had to switch to WFA2.0.1?
@One thing that would be VERY helpful- can someone publish the database schema of objects your can SQL against when creating queries in the user inputs? I find I have to select * and test to see what fields I have available, or dig through the dictionairies. There should be a reference doc out there- is there one? Must be. Link someone?
There is sure an online Reference Manual located at Help -> Reference Manual where you can look at Dictionary items. But with WFA2.1 there is a very useful feature available call "SQL query auto-complete" which can help you a lot. Give it a try, you'll love it.
2013-12-15 01:51 PM
Actually the sql autocomplete wasnt context aware, was nice but needs improvement. Also I found that if I select t1., t2. from two joined tables that both contained a "name" field, only the second one would be returned.
I will look in the ref doc under dictionary- thx. Got enough query building in where I got the hang of the fields.
Sent from Boxer | http://getboxer.com<http://bit.ly/1hRkK2W>
2013-12-15 04:17 PM
I've done a lot of schema work and I find MySQL Workbench very useful for prototyping queries and browsing the data. It's handy for performance tuning queries too if you have complex ones.
Either install it locally, or edit the mysql/my.ini on your WFA server and comment out the bind-address=localhost setting at the end and restart the DB to allow remote connections. Then connect using wfa/Wfa123. You can view data but you can't change data except for the playground database.
Hope that's useful!
2013-12-16 08:17 AM
Thanks for your feedback on SQL auto-complete feature. We well try to improve it in future..
Regarding storage.snapshot, I'm looking into this issue. I'll keep you updated about it.
2013-12-17 08:14 AM
I can't reproduce the issue you are pointing about storage.snapshot table in WFA2.1. If you enable acquisition for it, the table does get populated upon the next acquisition.
You may also like to see this thread: