1
select distinct `tix`.`TicketID` AS `TicketID`,`tix`.`Status` AS `TicketStatusID`,`status`.`TicketStatus` AS `TicketStatus`,`tix`.`Priority` AS `TicketPriorityID`,`priority`.`Name` AS `TicketPriority`,`infocat`.`CategoryName` AS `TicketCategory`,`tix`.`Level` AS `TicketLevel`,`tix`.`StartedDate` AS `TicketCreated`,`tix`.`ContactDate` AS `TicketLastContact`,`tix`.`DueDate` AS `TicketDueDate`,`tix`.`RequestorEmail` AS `TicketContactEmail`,`tix`.`Subject` AS `TicketSubject`,`clt`.`ClientID` AS `ClientID`,`cmp`.`ComputerID` AS `ComputerID`,`clt`.`Company` AS `ClientCompany`,`clt`.`Name` AS `ClientName`,if(isnull(`loc`.`LocationID`),'Client',if(isnull(`cmp`.`ComputerID`),'Location','Computer')) AS `ContactType`,concat(`clt`.`Address1`,if(isnull(`clt`.`Address2`),'',concat(convert(char(10) using utf8),convert(char(13) using utf8),`clt`.`Address2`))) AS `ClientAddress`,`clt`.`City` AS `ClientCity`,`clt`.`State` AS `ClientState`,`clt`.`Zip` AS `ClientZip`,`clt`.`Country` AS `ClientCountry`,`clt`.`Firstname` AS `ClientFirstName`,`clt`.`LastName` AS `ClientLastName`,`clt`.`Phone` AS `ClientPhone`,`loc`.`Name` AS `LocationName`,`loc`.`Address` AS `LocationAddress`,`loc`.`City` AS `LocationCity`,`loc`.`State` AS `LocationState`,`loc`.`Zip` AS `LocationZip`,`loc`.`Country` AS `LocationCountry`,`loc_cnt`.`Firstname` AS `LocationFirstName`,`loc_cnt`.`LastName` AS `LocationLastName`,`loc_cnt`.`Phone` AS `LocationPhonePrimary`,`loc_cnt`.`Cell` AS `LocationPhoneCell`,`cmp_cnt`.`Firstname` AS `ComputerFirstName`,`cmp_cnt`.`LastName` AS `ComputerLastName`,`cmp_cnt`.`Phone` AS `ComputerPhonePrimary`,`cmp_cnt`.`Cell` AS `ComputerPhoneCell`,`cmp`.`Name` AS `ComputerName`,replace(`opsys`.`Name`,'Microsoft ','') AS `ComputerOS`,`cmp`.`MAC` AS `ComputerMAC`,`cmp`.`LocalAddress` AS `ComputerLocalAddress`,`cmp`.`RouterAddress` AS `ComputerRouterAddress`,`cmp`.`Username` AS `ComputerUsername`,`cmp`.`Domain` AS `ComputerDomain`,`net`.`DeviceID` AS `NetworkDeviceID`,`net`.`Name` AS `NetworkDeviceName`,`net`.`IPAddress` AS `NetworkIPAddress`,`net`.`ManufacturerName` AS `NetworkManufacturerName`,`net`.`ModelName` AS `NetworkModelName`,`net`.`OS` AS `NetworkOS`,`net`.`MAC` AS `NetworkMAC` from ((((((((((`labtech`.`tickets` `tix` left join `labtech`.`ticketstatus` `status` on((`tix`.`Status` = `status`.`TicketStatusID`))) left join `labtech`.`ticketpriority` `priority` on((`tix`.`Priority` = `priority`.`Priority`))) left join `labtech`.`infocategory` `infocat` on((`tix`.`Category` = `infocat`.`ID`))) left join `labtech`.`clients` `clt` on((`tix`.`ClientID` = `clt`.`ClientID`))) left join `labtech`.`computers` `cmp` on((`tix`.`ComputerID` = `cmp`.`ComputerID`))) left join `labtech`.`inv_operatingsystem` `opsys` on((`cmp`.`ComputerID` = `opsys`.`ComputerID`))) left join `labtech`.`contacts` `cmp_cnt` on((`cmp`.`ContactID` = `cmp_cnt`.`ContactID`))) left join `labtech`.`locations` `loc` on((`cmp`.`LocationID` = `loc`.`LocationID`))) left join `labtech`.`contacts` `loc_cnt` on((`loc`.`ContactID` = `loc_cnt`.`ContactID`))) left join `labtech`.`networkdevices` `net` on((`tix`.`DeviceID` = `net`.`DeviceID`))) where ((to_days(now()) - to_days(`tix`.`StartedDate`)) <= 30) limit 5000