Office Users report for specific label
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
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
Answers (2)
Please log in to answer
Posted by:
GillySpy
12 years ago
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𐽹
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𐽹
Posted by:
craig.thatcher
12 years ago
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
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
