![]() When arp.version0 LIKE '.0' then 'SP1' when arp.version0 LIKE '.0' then 'SP2' when arp.version0 LIKE '.0' then 'SP3' when arp.version0 LIKE '.1000' then 'SP1' when arp.version0 LIKE '.1000' then 'SP2' when arp.version0 LIKE '.1000' then 'SP3' when arp.version0 LIKE '.1000' then 'SP1'Įnd as 'Service Pack', arp.Version0, Count(DISTINCT v_r_system.resourceid) AS 'Count'įROM v_ADD_REMOVE_PROGRAMS arp, v_r_system, V_RA_System_SMSInstalledSi tes ASSG I've run the following query directly on the database but so far its been "debugging query" for over 30 minutes Software inventory is turned on, and I can see that there are approx 1100 systems with Office 2012, but it doesn't show the service pack information. I need to find out how many computers in the network are running Office 2010 and which service pack.
0 Comments
Leave a Reply. |