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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Category

Uncategorized

Tags

, , , , , , ,