Hi,
Looks like QSM information is available in OCUM server in dfm database 'snapmirrorStatus' table, but I didnt find any schedule information for QSM from dfm database.
The attributes available in the table are:
snapmirrorId","snapmirrorDstId","snapmirrorSrcId","snapmirrorSrcName","snapmirrorConnId","snapmirrorDstHostId","snapmirrorDstVolId","snapmirrorDstQtreeId","snapmirrorSrcHostId","snapmirrorSrcVolId","snapmirrorSrcQtreeId","snapmirrorFlags","snapmirrorState","snapmirrorStatus","snapmirrorTotalTransMBs","snapmirrorTotalTransTimeSeconds","snapmirrorTransMBs","snapmirrorTransTimeSeconds","snapmirrorSyncToAsync","snapmirrorDiscoverTimestamp","snapmirrorTimestamp","snapmirrorUpdateTimestamp","snapmirrorRplPlcyId","snapmirrorFalvrPlcyId","snapmirrorLastDataset"
Here are the steps to cache the data from WFA:
Clone the certified 'QSM' Dictionary Entry:
- enable to be cached property for 'dest_interface', 'src_interface', 'src_qtree' and 'dest_qtree' attributes
- disble can be null property for 'src_qtree' and 'dest_qtree' attributes
- enable natural key property for 'src_qtree' and 'dest_qtree' attributes
Add a new cache query for the cloned dictionary entry to acquire the data. You can try to use the following cache query:
SELECT
snapmirrorStatus.snapmirrorId AS id,
destInterface.objName as dest_interface,
srcInterface.objName as src_interface,
snapmirrorStatus.snapmirrorSrcQtreeId AS src_qtree_id,
snapmirrorStatus.snapmirrorDstQtreeId AS dest_qtree_id
FROM
dfm.snapmirrorstatus snapmirrorStatus
JOIN
dfm.objects srcInterface
ON snapmirrorStatus.snapmirrorSrcHostId = srcInterface.objId
JOIN
dfm.objects destInterface
ON snapmirrorStatus.snapmirrorDstHostId = destInterface.objId
AND snapmirrorStatus.snapmirrorSrcQtreeId IS NOT NULL
AND snapmirrorStatus.snapmirrorDstQtreeId IS NOT NULL
Note: I have not tested this with real qtree QSM data.