USP_SIMPLEDATALIST_BUSINESSPROCESSOWNERSFROMDATABASESPACEUSED

create procedure dbo.[USP_SIMPLEDATALIST_BUSINESSPROCESSOWNERSFROMDATABASESPACEUSED]
as begin
  set nocount on;

  select distinct
    [APPUSER].[ID] as [VALUE],
    isnull(case when [APPUSER].[DISPLAYNAME] = '' then [APPUSER].[USERNAME] else [APPUSER].[DISPLAYNAME] end, '') as [LABEL]
  from [DATABASESPACEUSED]
  inner join dbo.[BUSINESSPROCESSOUTPUT] on [BUSINESSPROCESSOUTPUT].[ID] = [DATABASESPACEUSED].[BUSINESSPROCESSOUTPUTID]
  inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [BUSINESSPROCESSOUTPUT].[BUSINESSPROCESSSTATUSID]
  inner join dbo.[BUSINESSPROCESSINSTANCE] on [BUSINESSPROCESSINSTANCE].[BUSINESSPROCESSPARAMETERSETID] = [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSPARAMETERSETID]
  inner join dbo.[APPUSER] on [APPUSER].[ID] = [BUSINESSPROCESSINSTANCE].[OWNERID]
  order by isnull(case when [APPUSER].[DISPLAYNAME] = '' then [APPUSER].[USERNAME] else [APPUSER].[DISPLAYNAME] end, '');

  return 0;
end