Hi guys,

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

 

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1

What version of agent do you have?

I've been using "M.USER" for my queries.

Answered 07/24/2012 by: dugullett
Red Belt

  • Cheers that worked.
    • I believe the latest version should have fixed this.

      Release Notes
      • 1738: The current logged-on user is not always detected.
Please log in to comment

Answers

0

Have you seen this post

http://www.itninja.com/question/report-requests

Same issue has been already discussed by terabyte33 and dchristian

Answered 07/24/2012 by: jagadeish
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share