WFA QSM Table for Storage Scheme

[RoiBeci]

Hi All,

I've been trying to work with the "QSM" table in the WFA DB, but it seems to be missing there, although we have a Dictionary type called "QSM".

Can someone please point out what am I missing?

Thanks,

Roi Becidan.

[shailaja]

Hi,

QSM dictionary entry is not applicable for acquisition as there are no cache queries written for it.

Please refer to this previous community thread on this:

http://community.netapp.com/t5/OnCommand-Storage-Management-Software-Discussions/Find-QSMs-in-a-volume-Finder/m-p/80900/highlight/true#M16826

Thanks,
Shailaja

[RoiBeci]

Hi,

Maybe do you know how can I create a cache query for the "qsm" object? any reason why it was not written?

I'm not familiar with the DFM DB structure, maybe some guides that can help me cache that?

Thanks,

Roi

[abhit]

Which version of Oncommand Unified manager are you using?

Regards

Abhi

[RoiBeci]

It is OCUM 5.2 

[rkiran · Accepted solution]

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.

[RoiBeci]

seems like now my cloned qsm table has valid data inside.

thanks 🙂