Tickets Over 30 Days old

[JTolivar_GS]

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 Opened],
  htbltickettypes.typename As [Ticket Category],
  htblticketstates.statename As [Ticket State],
  htblusers.name As [User],
  tblAssets.AssetName As Asset,
  htblusers1.name As Agent
From htblticket
  Left Join htblticketstates On htblticketstates.ticketstateid =
    htblticket.ticketstateid
  Left Join htbltickettypes On htblticket.tickettypeid =
    htbltickettypes.tickettypeid
  Left Join htblusers On htblusers.userid = htblticket.fromuserid
  Left Join htblagents On htblagents.agentid = htblticket.agentid
  Left Join htblusers htblusers1 On htblagents.userid = htblusers1.userid
  Left Join tblAssets On htblticket.assetid = tblAssets.AssetID
Where htblticket.date <= DateAdd(DAY, -30, GetDate()) And
  htblticketstates.statename != 'Closed'

[dconway]

Cast(htblticket.ticketid As varchar) As hyperlink_Subject,
Line is incorrect
Cast(htblticket.ticketid As nvarchar) As hyperlink_Subject,