Matt,
Mysql clients sometimes resolve some things which a native mysql query would not be able to. Not this case, but I've seen other cases where mysql client return different data as they can resolve some things. Thats why sometimes some things work on clients like mysql workbench but not at WFA end.
Let's see what's happening here. I want to execute the query keeping WFA and Mysql Clients aside. Just a native code to run query. It has no built-in intelligence to do anything.
Can you try the following:
- On your WFA windows server open a powershell ISE console.
Import-module 'C:\Program Files\NetApp\WFA\PoSH\profile.ps1'
If you have default installation else edit it accordingly. Now define variable for query
$query="SELECT
a.name
from
cm_storage.cluster a
inner join
(
SELECT
a.name,
a.cluster_id
FROM
cm_storage.vserver a
inner join
(
SELECT
a.name,
a.vserver_id
FROM
cm_storage.volume a
inner join
(
SELECT
DISTINCT REPLACE(b.share_path,
'/',
'') as share,
a.name
FROM
vc.data_store a
join
vc.nas_share b
ON a.id = b.data_store_id
) b
on a.name = b.share
where
b.name = 'WDGT1OS01SRM_clone_mkoo_ssumner'
) b
on a.id = b.vserver_id
where
a.name not like '%DRN0%'
) b
on a.id = b.cluster_id"
Execute the query.
Invoke-MySqlQuery -Query $query
If you are getting 0 results, then there is something wrong with your query which somehow Mysql workbench is able to resolve. If you get data same as mysql workbench and still nothing at WFA, WFA needs to be debugged.
Waiting for your response.
sinhaa
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.