How i can find out how many Office Products are installed in the DOMAIN

[TronixS]

Hello,

 

i read my SCCM 2007 Book, search many in the WWW und try out Something but the results are not okay.

 

Can anyone explain me how i make a easy query to find out How many Office 2000 / XP / 2003 / 2007 are installed in my Domain.

 

All clients have the actually Agent installed but not all Systems are installed with SCCM, we have changed our Installation System Server from SYMANTEC LSD to SCCM 2007.

 

Thank.

 

with best regards

André Jansen

[wmmayms]

This is a very basic report that will do what you want:

 

SELECT

DisplayName0,

Version0,

COUNT(*)

 

FROM

v_GS_ADD_REMOVE_PROGRAMS

 

WHERE DisplayName0 LIKE '%Office%'

 

GROUP BY

DisplayName0,

Version0

 

If you need it more specified change the row in red to suit your needs.

[Eswar Koneti]

Hi,

Here is the simple report which gives you list of machines with office in the domain on XP machines.

 

 

SELECT
c.Name0,
a.DisplayName0

FROM 
v_GS_ADD_REMOVE_PROGRAMS a,
v_R_System c,
v_FullCollectionMembership b,
v_GS_OPERATING_SYSTEM d

WHERE a.ResourceID = c.ResourceID
AND b.ResourceID = c.ResourceID
AND a.DisplayName0 like "%Office%%" 
AND d.Caption0 like "Microsoft Windows XP Professional%"
AND b.CollectionID=@coll

GROUP BY
c.Name0,
b.CollectionID,
a.DisplayName0,
d.Caption0

ORDER BY c.Name0

 

Prompt:

begin
if (@__filterwildcard = '')
SELECT DISTINCT CollectionID, Name FROM v_Collection ORDER BY Name
else
SELECT DISTINCT CollectionID, Name FROM v_Collection
WHERE CollectionID like @__filterwildcard
ORDER BY Name
end