Select
  PUSER.POS_USERNAME       As TcUser,
  PIMANVOLUME.PVOLUME_NAME As UserDefVol,
  PIMANVOLUME.PWNT_PATH_NAME,
  PIMANFILE.PSD_PATH_NAME,
  count(*) As NFiles
From
  PUSER
Left Join PIMANVOLUME
On
  PUSER.RVOLUMEU = PIMANVOLUME.PUID
Inner Join PUSER_PATHS
On
  PIMANVOLUME.PUID = PUSER_PATHS.PUID
Inner Join PUSERS
On
  PUSER_PATHS.PUID = PUSERS.PUID
And PUSERS.PSEQ    = PUSER_PATHS.PSEQ
And PUSER.PUID     = PUSERS.PVALU_0
Inner Join PIMANFILE
On
  PUSER_PATHS.PVAL_0 = PIMANFILE.PSD_PATH_NAME
Where
  PUSER.POS_USERNAME Like '%'
Group By
  PUSER.POS_USERNAME,
  PIMANVOLUME.PVOLUME_NAME,
  PIMANVOLUME.PWNT_PATH_NAME,
  PIMANFILE.PSD_PATH_NAME
Order By
  PUSER.POS_USERNAME