Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
Solved! See The Solution
6 REPLIES 6
Highlighted
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
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:
Thanks,
Shailaja
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
Which version of Oncommand Unified manager are you using?
Regards
Abhi
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
seems like now my cloned qsm table has valid data inside.
thanks