Find which users have an avatar in MUX

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Is there a way to find out how many have users uploaded an Avatar and who uploaded an Avatar in the MUX interface?

Environment

Release : 16.0.3, 16.1.0

Resolution

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%'