List Jobs and Tasks

List all Jobs and Tasks 

SELECT Distinct it.Name AS 'Job/Task Name'

       ,it.Description

       ,it.CreatedBy

       ,it.CreatedDate

       ,i.Name AS 'Type'

FROM  Item AS i

       JOIN ItemReference AS ir ON ir.ChildItemGuid = i.[Guid] AND ir.Hint = 'tasktotype'

       JOIN Item AS it ON it.Guid = ir.ParentItemGuid

WHERE it.Name <> ''

ORDER BY it.Name