SELECT

TOP 100 START AT 1 domain_Policy.name as "Policy",

domain_client.name as "VM Guest",

adjust_timestamp(domain_JobArchive.startTime,-14400000 ) as "Job Start Time",

adjust_timestamp(domain_JobArchive.endTime,-14400000 ) as "Job End Time",

nb_VirtualMachines.operatingSystem as "Virtual OS",

domain_JobArchive.throughput as "Throughput (KB/Sec)",

(case when domain_JobArchive.state =3 and domain_JobArchive.statusCode in (0,1) then 0 else 2 end) as "Job Status (Complete/Partial)"

FROM domain_client, nb_VirtualMachines, domain_JobArchive , domain_Policy , domain_MasterServer , domain_Client

WHERE

nb_VirtualMachines.name=domain_client.name

order by startTime desc