I wanted to create a query that would only show data protection volumes (SM destinations), and I noticed that volume.type == 'flexible', rather than 'dp'. This is with 8.2 and OCUM 5.2. I haven't tried it with OCUM 6 yet.
I would try this with 6.0, the database structure is entirely different and I have checked my environment and I'm getting "dp" or "rw" type names back from volume.type using OCUM 6.0 and 8.2 Ontap sims.