Tuesday, October 17, 2017

Query to extract users and groups from content store

select cn.NAME as GRUPPEop.NAME as BENUTZER
from cmreford1 ro
inner join cmobjnames cn on ( cn.CMID = ro.CMID  )
inner join cmobjprops33 op on ( op.CMID = RO.REFCMID )
--WHERE OP.NAME LIKE '%Martins-Volpi%'

No comments:

Post a Comment