KACE Product Support Question
Report last user blank!!
I am looking to run a report to identify all versions of Mapinfo pro on the network. I am looking to include product version, computer name and last user.
I used the syntax below and it pulled back everything except last user:
select S.DISPLAY_NAME as SOFTWARE_NAME,
S.DISPLAY_VERSION as VERSION,
M.NAME as MACHINE_NAME,
M.USER_FULLNAME as LAST_USER
FROM SOFTWARE S
left join MACHINE_SOFTWARE_JT MSJ on S.ID = MSJ.SOFTWARE_ID
left join MACHINE M on MSJ.MACHINE_ID = M.ID
where S.DISPLAY_NAME like 'Mapinfo prof%'
and not IS_PATCH
order by S.DISPLAY_NAME, S.DISPLAY_VERSION, M.NAME
Community Chosen Answer
What version of agent do you have?
I've been using "M.USER" for my queries.