Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

NS collection for Office 2007 installation

Updated: 24 May 2010 | 1 comment
alpe's picture
+2 2 Votes
Login to vote

Could anybody help med creating a collection to indentify computers without MS office 2007 installed. I need this collection for installation purposes but when I use “AeX SW Microsoft Office” I also get computers with no office 2007 but with FileFormatConverters 2007 for office 2003 installed.

Comments

TheSmiz's picture
23
Jun
2009
2 Votes 0
Login to vote

Query

Would you be open to using the Add/Remove inventory?

Office Professional 2007 brands: 'Microsoft Office Professional 2007'

So, you could create a sollection like the following:

SELECT r.Guid
FROM vResource r
LEFT JOIN AeXInv_AeX_OS_Add_Remove_Programs ar ON ar.WrkStaId = r.ResourceId AND ar.[Name] = 'Microsoft Office Professional 2007'
WHERE ar.[Name] IS NULL
AND r.isManaged = 1

If you have a different version of 2007, you can enter the brand from add/remove programs in place of "Microsoft Office Professional 2007".

Note: this is for the NS6 environent.  If you are using 7, let me know and we can make some changes.

RS