shopping

1E Shopping Database : Sql query to find apps which failed in appstore -sort by time

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… Read More ›