ok, I see the issue.
As I said before, you can't cross DMs. Each DM is designed to provide you all the data elements that are relative within each DM. Remember they are a subset of the database NOT direct access to the database. So, when you try to create a report from the Host Assets DM and Storage Assets DM, you get the join error because we can't join across DMs. For the report you need, stay within the specific DM. Here's how:
In Query Studio (or Business Insight Advanced if you have OCInsight 6.3), select Inventory DM
Then expand (in your case) iSCSI Assets.
Expand Storage and drag Storage name to the work area
Then Expand Host under iSCSI Path and drag Host Name to the work area.
You can then group them any way you want (show how many hosts are connected to each array or how many arrays are used by each host...) and you can add other elements like number of connections, etc... But you have to drag elements from under the same DM (ie: iSCIS path )
When you are done, save the report and create another report using the same elements from the FC Path DM.
You can add the two reports to a Dashboard later if you want them both on the same view.
BTW, if you know sql you can go directly to the database and extract the elements you want but you need to remember to make sure they are relative to eachother and your report is accurate. the DMs try to do that for you.
Hopefully that helps.
Please confirm.
Thanks
Dave