Tickets Over 30 Days old
Replace 'lansweeperurl' with your server for success.Select Top 1000000 'http://lansweeperurl/Ticket.aspx?tid=' + Cast(htblticket.ticketid As varchar) As hyperlink_Subject, htblticket.subject As hyperlink_name_Subject, htblticket.date As [Date Ope...