~100 systems with varying office versions, office xp, 2003, 2007, 2010

[holden j caufield]

Is there a central way to determine which ones have office 2007/2010 installed on what workstations?

 

[Paperlantern]

Powershell can do this if you can stomach the code. My suggestion would be to start with this function

function Get-InstalledPrograms($computer = '.') {
	$programs_installed = @{};
	$win32_product = @(get-wmiobject -class 'Win32_Product' -computer $computer);
	foreach ($product in $win32_product) {
		$name = $product.Name;
		$version = $product.Version;
		if ($name -ne $null) {
			$programs_installed.$name = $version;
		}
	}
	return $programs_installed;
}

Modify it to filter the results and only show office version, then plunk it into a script that pulls from a csv file or from active directory all of the computer names that you want. You may have to google a bit to find the syntax for each piece you need, but i assure you powershell can do it.

Youll be looking at something along the lines of it doing the following

Create an array by pulling computer names from a certain OU or OUs. Then, for each item in the array, run the above script to get the resulting installed office version, drop that in another variable, then when finished print the variable to the screen.

Yes there is more to it than that, and it might take you a couple hours to build the script and experiment with it (it usually takes me 2 - 4 hours to build any script i work with what with all the googling and trial and error) but when you are done, and it works, everything goes VERY quick after that. Plus you can then use the same script to get similar information for other programs down the road if necessary, saving lots of time in the future.

Installing powergui prior to beginning would be a good place to start working.

EDIT - I also found this page with a little more googling on the subject, this might be all you need with a tiny bit of editing, its virtually exactly what i described above, id still get powergui though to work with it.

http://techibee.com/powershell/powe...y-softwares-installed-on-remote-computer/1389

 

[xSauronx]

do you have any desktop management or av apps? mcafee and sep can do software inventories on pcs, some other suites can do inventory/mangement, such as spiceworks, which is free. not sure what kind of sorting/collection it can do as i havent used that feature much.

im assuming you are on a domain

 

[Red Squirrel]

You could use winaudit. There is a way to load it into a sql database as well so you can write scripts to parse it out better. I never did it myself but my coworker did it when I worked in a similar environment but with 500 computers. You still need a way to push it though, so you'll need to have a desktop management app unless you want to go around with a USB stick and do it manually.

 

[gmaster456]

Use belmanage
http://www.belarc.com/belmanage.html

 

[Paperlantern]

Use belmanage
http://www.belarc.com/belmanage.html

If he wants to spend $5000 to answer one question I would be surprised. It does look good though, and isnt badly priced for all it does. However if the OP just wants the answer to the question, with no client piece to install and no cost, really, the powershell script is the way to go.

 

[gmaster456]

True. It's probably not worth it for the amount of client machines he has.

 

[holden j caufield]

we have symantec endpoint is there a way to search registry keys?

 

[AFurryReptile]

We use Spiceworks. It's free, robust, well-supported, and has loads of features - including the ability to track everything that's installed on your network.

 

[mechBgon]

You could also run Microsoft Baseline Security Analyzer to centrally scan all the domain computers. You'll need to run it with Domain Admin credentials to scan the whole domain. I think the result details from the Office scans would allow you to determine Office versions.

As a bonus, you'll probably identify some systems that are behind on their updating.