Select i.Name, vc.Name as [PC Name], id.FQDN, vc.[IP Address], vc.CreatedDate as [First Discovered Date]
, ts.StartTime, ts.Endtime
From Inv_Task_Summary_By_Resource ts
Join vItem i on i.Guid = ts.TaskItemGuid
Join Inv_AeX_AC_Identification id on ts._ResourceGuid = id._ResourceGuid
Join vComputer vc on ts._ResourceGuid = vc.Guid
Where i.Name = 'Place the Task Name'