/build/static/layout/Breadcrumb_cap_w.png

Report last user blank!!

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

 


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: dugullett 8 years ago
Red Belt
1

What version of agent do you have?

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


Comments:
  • Cheers that worked. - fitzsilver 8 years ago
    • I believe the latest version should have fixed this.

      Release Notes
      • 1738: The current logged-on user is not always detected. - dugullett 8 years ago
Posted by: jagadeish 8 years ago
Red Belt
0

Have you seen this post

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

Same issue has been already discussed by terabyte33 and dchristian

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ