Cacher is the code snippet organizer for pro developers

SELECT
	[t1].[computer_id]
	, [Deployment Server] = (SELECT TOP 1 UPPER([hostname]) FROM mmsettings)
	, [t1].[name]
	, [JobName] = [t3].[name]
	, [ScheduledBy] = [t4].[netbiosdomain] + '\' + [t4].[name]
	, [StartTime] = [t2].[start_time]
	, [Duration (minutes)] = DATEDIFF(MI, [t2].[start_time], getdate())
FROM
	[computer] [t1]
	left join [event_schedule] [t2] ON [t1].[computer_id] = [t2].[computer_id]
	left join [event] [t3] ON [t2].[event_id] = [t3].[event_id]
	left join [securityuser] [t4] ON [t2].[user_id] = [t4].[user_id]
WHERE status_code = -1