NS collection for Office 2007 installation
Updated: 24 May 2010 | 1 comment
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.
Discussion Filed Under:
Comments
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
Would you like to reply?
Login or Register to post your comment.