Cacher is the code snippet organizer for pro developers

select 	UUID() as `id`,
        clients.name as `ClientName`,
		clients.company,
		locations.name as `LocationName`,
        computers.name as `ComputerName`,
        computers.Domain,
        computers.Username,
        computers.OS,
        computers.Version,
        computers.BiosMFG as `Manufacturer`,
        computers.BiosName as `Model`,
        computers.BiosVer as `SerialNo`,
        computers.ServiceVersion as `AgentVersion`,
        computers.LastContact,
        computers.DNSInfo,
        computers.TotalMemory,
        computers.RouterAddress as `PublicIP`,
        computers.uptime,
        computers.DateAdded,
        inv_processor.Manufacturer as `CPUManufacturer`,
        inv_processor.Speed as `CPUSpeed`,
        inv_processor.Cores,
        inv_processor.Name as `CPUName`,
        inv_videocard.VideoProcessor,
        inv_videocard.Mode,
        inv_videocard.Memory,
        drives.letter,
        drives.size,
        drives.free,
        drives.FileSystem,
        drives.Model as `DriveModel`,
        drives.ssd,
        drives.internal,
        plugin_warrantymaster_aux.ExpiryDate,
        plugin_warrantymaster_aux.PurchaseDate
from computers
JOIN Clients ON Clients.ClientID=Computers.clientid
JOIN Locations ON Locations.locationID=Computers.LocationID
JOIN inv_processor on inv_processor.ComputerId = Computers.ComputerID
JOIN inv_videocard on inv_videocard.ComputerID = Computers.ComputerID
JOIN Drives on Drives.ComputerID = Computers.ComputerID
JOIN plugin_warrantymaster_aux on plugin_warrantymaster_aux.ComputerID = Computers.ComputerID
where drives.missing = 0