Hi Guys,

I'm trying to create a report that shows all the different versions of Office (ie 2003, 2007, 2010) installed on a specific smart label of computers.I've gotten the sql to display a list of Office products but it includes a ton of other products that aren't needed.
I'm wondering how I'd display just Microsoft Office versions for a specific computer label:?

here's my sql code:

SELECT MACHINE.NAME AS MACHINE_NAME,
DISPLAY_NAME AS SOFTWARE_NAME,
DISPLAY_VERSION AS SOFTWARE_VERSION,
SOFTWARE.PUBLISHER
FROM (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE, MACHINE_LABEL_JT, LABEL)
WHERE MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
AND MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID
AND LABEL.ID = MACHINE_LABEL_JT.LABEL_ID
AND NOT IS_PATCH AND LABEL.NAME like ('uadv- All Computers') and DISPLAY_NAME like ('Microsoft Office%')
order by MACHINE_NAME
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
you'll have to get fancier with your filtering. you could include the PUBLISHER column looking for Microsoft. Some regex pattern on version if you know the possibilitiies

You could also create a custom inventory rule that tracks them all and then a very simple report on that . Use this as a starter for the latter concept
http://itninja.com/question/should-these-system-dlls-be-installed-by-an-app.?97&mpage=1&key=custom%2Cinventory%2Coffice&#69497
Answered 09/16/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Try this out.......


SELECT MACHINE.NAME AS MACHINE_NAME,
DISPLAY_NAME AS SOFTWARE_NAME,
DISPLAY_VERSION AS SOFTWARE_VERSION,
SOFTWARE.PUBLISHER
FROM (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE, MACHINE_LABEL_JT, LABEL)
WHERE MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
AND MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID
AND LABEL.ID = MACHINE_LABEL_JT.LABEL_ID
AND NOT IS_PATCH AND LABEL.NAME like ('uadv- All Computers') and
(DISPLAY_NAME LIKE 'Microsoft Office Professional%' or
DISPLAY_NAME LIKE 'Microsoft Office Standard%' or
DISPLAY_NAME LIKE 'Microsoft Office Basic%' or
DISPLAY_NAME LIKE 'Microsoft Office Enterprise%' ) and PUBLISHER = 'Microsoft Corporation'
order by MACHINE_NAME
Answered 09/19/2011 by: craig.thatcher
Orange Belt

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