Added install date to report
I have a hopefully simple request. I have a query and I need to try and add the installed date to this report. Ive tried to search for it but the query keeps erroring out when I add the date string. The code below is fully functional.
S.DISPLAY_NAME as SOFTWARE_NAME,
S.DISPLAY_VERSION as VERSION,
M.NAME as MACHINE_NAME,
M.USER_FULLNAME as LAST_USER
MACHINE_SOFTWARE_JT MSJ ON S.ID = MSJ.SOFTWARE_ID
MACHINE M ON MSJ.MACHINE_ID = M.ID
S.DISPLAY_NAME like 'AgentInstall64%'
and not IS_PATCH
order by S.DISPLAY_NAME , S.DISPLAY_VERSION , M.NAME
I was hoping for 'S.DISPLAY_Installed as Installed_date'..... not so much... haha
PS. Does anyone know of a good quick reference guide for SQL commands?