topic Re: WFA QSM Table for Storage Scheme in Active IQ Unified Manager Discussions

WFA QSM Table for Storage Scheme

RoiBeci — Thu, 05 Jun 2025 04:09:59 GMT

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.

Re: WFA QSM Table for Storage Scheme

shailaja — Wed, 10 Jun 2015 12:58:38 GMT

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

Re: WFA QSM Table for Storage Scheme

RoiBeci — Wed, 10 Jun 2015 14:42:45 GMT

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

Re: WFA QSM Table for Storage Scheme

abhit — Mon, 15 Jun 2015 04:41:05 GMT

Which version of Oncommand Unified manager are you using?

Regards

Abhi

Re: WFA QSM Table for Storage Scheme

RoiBeci — Mon, 15 Jun 2015 06:36:28 GMT

It is OCUM 5.2

Re: WFA QSM Table for Storage Scheme

rkiran — Tue, 16 Jun 2015 12:51:13 GMT

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.

Re: WFA QSM Table for Storage Scheme

RoiBeci — Sun, 21 Jun 2015 09:21:04 GMT

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

thanks 🙂