1E Shopping Database : Query to find applications on a machine based on ip address

select  usr.FullName,mac.MachineName,mac.DomainName,mac.IPAddress,app.DisplayName,comp.RequestedTimestamp,comp.DateInstalled, 

DeliveryStatus =

CASE

comp.DeliveryStatus

           WHEN '1' THEN 'Completed'

        WHEN '2' THEN 'Failed'

        WHEN '3' THEN 'Pending'

        WHEN '' THEN 'Unknown'

END

from

tb_CompletedOrder comp

join tb_Machine mac on comp.MachineId=mac.MachineId

join tb_User usr on comp.UserId=usr.UserId

join tb_Application app on comp.ApplicationId = app.ApplicationId

where  mac.IPAddress in ('10.0.0.0')