September 22, 2014 — sanmansp
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’)
Advertisements
