Is there a way to find out how many have users uploaded an Avatar and who uploaded an Avatar in the MUX interface?
Release : 16.0.3, 16.1.0
The following query can be used:
select SRM_RESOURCES.UNIQUE_NAME
FROM CLB_DMS_FOLDERS
INNER JOIN SRM_RESOURCES ON CLB_DMS_FOLDERS.OWNER_ID=SRM_RESOURCES.ID
Where CLB_DMS_FOLDERS.NAME LIKE 'avatar%'