This is for the LanSweeper beta, created on v6009Select Top 1000000 htblticket.date As [Date Opened], htblticket.slaresolved As [Date Closed / Resolved], htbltickettypes.typename As [Ticket Category], htblticketstates.statename As [Ticket State], ...