SQL Query To Count Microsoft Office Versions From Add And Remove Programs

 

This SQL Query will allow you to get a count of the Microsoft Office versions deployed.

 

SQL Query:

 

Select

Count(ResourceID) Counts,

DisplayName0,

Publisher0,

Version0

From v_Add_Remove_Programs

 

Where Publisher0 = 'Microsoft Corporation'

And DisplayName0 Like 'Microsoft Office%'

 

Group By DisplayName0, Publisher0, version0

Order By Counts Desc

 

 

 

Published Monday, May 26, 2008 7:40 AM by dhite
Filed under:

Comments

No Comments