/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Report last user blank!!

07/24/2012 2601 views

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:
0 Comments   [ + ] Show comments

Comments



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.

All 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

 
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