新聞財經娛樂♬資訊 News Economy

Thanks for your points

Have a nice day

Duncan

You could also use Sydi as you could create a CSV file containing your computers and it could create a workbook with all the required information.  You can get a sheet with all software as well as which computer has the software installed.  

http://sydiproject.com/guides/server-documentation-template/

Thanks Joseph, it is working correctly however i need to run it against ~3000 computers and this script will generate ~3000 .txt files for each computer.
Is there a way to add all computers details in 1 CSV or .TXT file.

You can do this with powershell and a csv file. The csv file should have a column called computername.

import-csv filename.csv | foreach {
$name=$_.computername
get-wmiobject -computername $_.computername -class win32_product | select-object name >> c:dir$name.txt}

Thanks all, however i am looking for a script which take computer name from excel and create 1 excel with all installed application name.

I need this data to validate which application need local admin rights hence i need all installed application information.

If your only requirement is computer inventory and possibly software distribution then use OCS Inventory (http://www.ocsinventory-ng.org).  If you would like resource monitoring then use something like SpiceWorks.

In terms of running inventories like this, the next questions is what are you going to do with this data?

Common next steps are patch management, version updating, licence checking, remote administration and so on.

In which case, you really need to look at a proper tool to do the job.
Spiceworks is free, and has a very good support environment.
http://www.spiceworks.com/network-management/?bcsi_scan_a7e54b77b385dbee=QiwfkM7y3oghqpJj3IxttUmIh18FAAAAqia0Bg==