/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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