We are in the process of upgraded all of our users from Office 2003/2007 to Office 2010. We recently found out running Office 2010 on Windows XP on an older model machine (we're a dell shop - one model we had an issue with is Dell Latitude D630) seems to slow the machine down quite a bit. I'm far from being a MySQL guru (not even close), so I was hoping I could find some help with this.

I'm looking for a report that will group computers by model running Windows XP and either Office 2007 or 2003. Also would like the computer name and if possible, the user name (which could also be found under computer description - we put the end users name in that field on their machine).

I've "borrowed" the following which works, but I'm not sure on how to add correctly the additional information I would like.

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 'Microsoft Office Professional Edition 2003'
and not IS_PATCH
order by S.DISPLAY_NAME, S.DISPLAY_VERSION, M.NAME

I know I'm a noob when it comes to this, but I appreciate any assistance with this in advance.

Thanks much!
Kirk
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

Answer this question or Comment on this question for clarity