Service Desk Plus MSSQL query Last Update Time
I'm wanting to see if I can get some help with a SQL query that can add a column showing the number of days since the request was updated. I found the following query below from the forums that filters the database by records. but cant seem to figure out how to make a calculated field that shows the number of days since update. Any help you can give would be greatly appreciated.
Thanks
Tony Blandin
SELECT ti.FIRST_NAME "Technician",
wo.WORKORDERID "Request ID",
aau.FIRST_NAME "Requester",
cd.CATEGORYNAME "Category",
sdo.NAME "Site",
dateadd(s,wos.LAST_TECH_UPDATE/1000,'19700101') "Last Update Time"
FROM WorkOrder wo
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID
LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
WHERE (std.ispending='1') AND datediff(dd,dateadd(s,wos.LAST_TECH_UPDATE/1000,'19700101'),getdate()) >1 AND wo.ISPARENT='1'
ORDER BY 1,6,pd.PRIORITYNAME