Hello Adai,
It's WFA version 2.1.0.70.32, running against cDOT (8.2P2 and P3)systems.
The query is as follows:
SELECT
vserver.name
FROM
cm_storage.cluster cluster,
cm_storage.vserver vserver
WHERE
vserver.cluster_id = cluster.id
AND cluster.name = '${ClusterName}'
AND vserver.is_repository IS NOT TRUE
AND (
vserver.type = 'cluster'
OR vserver.type = 'data'
)
ORDER BY
vserver.name ASC
We don't have execution logs as these SQL queries are just during the user input steps, before the workflow is ever told to preview/execute. Put a screenshot below that shows the evaluated at run-time value for the query. ClusterName selects all clusters that OnCommand knows about… based on that selection, the VserverName query will update to only show the vservers owned by that cluster. And likewise the VolumeName will only show the volumes owned by that vserver. Those are just SQL queries defined in the user inputs but I don’t believe there is any log for them as they are dynamic.
Please let me know what other information will help. Thanks!
Kevin,
To answer to your first question: qtree.disk_limit_mb table in WFA, the values returned are actually in KB instead of MB
I don't see it. Its returned in MB.
On Cluster:
f3270-251-16-18::*> quota policy rule show -fields disk-limit
vserver policy-name volume type target qtree disk-limit
------- ----------- -------- ---- --------------------- ----- ----------
dhruvd default vol_test tree qtree_21022014_133557 "" 200MB
----
Data from WFA tables, query executed outside of WFA:
PS C:\Users\Administrator> Get-MySqlData -Query "SELECT *
FROM
cm_storage.qtree
WHERE qtree.name LIKE '%133557%'"
1
id : 160
name : qtree_21022014_133557
oplock_mode : 0
path : /vol_test/qtree_21022014_133557
security_style : ntfs
volume_id : 106
disk_limit_mb : 200
disk_soft_limit_mb : 0
files_limit : 0
soft_files_limit : 0
threshold_mb : 0
disk_used_mb : 0
Data from query execution within WFA:
