UFN_QUERY_OLAPDATASOURCE_ETLHISTORY

CREATE function dbo.[UFN_QUERY_OLAPDATASOURCE_ETLHISTORY]
(
  @CONTEXTID uniqueidentifier
)
returns table
as
  return
  select top 100 percent
    [ID],
    [ETLSTARTTIME],
    [ETLENDTIME],
    [COMPLETED],
    datediff(minute,[ETLSTARTTIME],[ETLENDTIME]) as [TOTALMINUTES],
    [ETLCONTROLID] [PARENTEETLCONTROLID],
    [DATAWINDOWOPEN],
    [DATAWINDOWCLOSE],
    [SSISPACKAGENAME],
    [ISPARENT],
    [NUMROWSADDED],
    [NUMROWSUPDATED]
  from dbo.[ETLHISTORY]
  where [OLAPDATASOURCEID] = @CONTEXTID
  order by [ETLSTARTTIME] desc;