Query to find software
Created: 14 Jun 2010 | 1 comment
Within NS 6.x I went to all reports and drilled down to: Computers With Selected Application Installed. I then tried many different strings to find any/all versions of Microsoft Project. No results came back. I then tried entering %excel% and it returned nothing. I then tried %Microsoft Office% and it only retunred about 250 machines Now, I know that is false since or company image has Office baked into it so it show about 1,000 machines.
If I want to query for all versions of Microsoft Project what would be string be?
And why would it only find 250 machines when I search for %Microsoft Office%? It should return close t0 1,000 workstations.
Discussion Filed Under:
Comments
I could not find a report in
I could not find a report in NS6 that is called: Computers With Selected Application Installed. What is the path in the NS console?
Try this report for finding Office:
SELECT DISTINCT
p.[name] [Office Name],
COUNT (*) [Count]
FROM inv_aex_os_add_remove_programs p
JOIN vcomputer c ON c.guid = p._resourceguid
WHERE (p.[Name] = 'Microsoft Office XP Professional with FrontPage'
OR p.[Name] = 'Microsoft Office XP Professional'
OR p.[Name] = 'Microsoft Office XP Standard'
OR p.[Name] = 'Microsoft Office Professional Edition 2003'
OR p.[Name] = 'Microsoft Office Standard Edition 2003'
OR p.[Name] = 'Microsoft Office Professional Plus 2007'
OR p.[Name] = 'Microsoft Office Enterprise 2007'
)
GROUP BY p.[name]
Order BY COUNT (*)
Would you like to reply?
Login or Register to post your comment.