Why I no longer hate writing documentation…

Love it. Unfortunately I can’t get it to work with Office 2007.

It just starts Excel, doesn’t create a sheet with information.

Tested script with Excel 2007 and it works. It may be the option you are choosing. If you are choosing the option to gather info from “All Computers” or “All Servers” in your domain, it may take a long time to enumerate all the information. Try Option [4]Choose a Computer manually to test enumerating from a single computer.

Hmm ok, that’s what I tried. Will make it run a bit longer and see.

Would it be possible to add a software installed tab.

I added this function
# ========================================================================
# Function Name Select-FileDialog #
# Created by Hugo Peeters #
# http://www.peetersonline.nl #
###############################

# Example use:
# $file = Select-FileDialog -Title “Select a file” -Directory “D:\scripts” -Filter “Powershell Scripts|(*.ps1)”

function Select-FileDialog
{
param([string]$Title,[string]$Directory,[string]$Filter=”All Files (*.*)|*.*”)
[System.Reflection.Assembly]::LoadWithPartialName(“System.Windows.Forms”) | Out-Null
$objForm = New-Object System.Windows.Forms.OpenFileDialog
$objForm.InitialDirectory = $Directory
$objForm.Filter = $Filter
$objForm.Title = $Title
$Show = $objForm.ShowDialog()
If ($Show -eq “OK”)
{
Return $objForm.FileName
}
Else
{
Write-Error “Operation cancelled by user.”
}
}

# ==============================================================================================

And changed the line
$strText = Read-Host “Enter the path for the text file”

To
$strText = Select-FileDialog -Title “Select a file” -Directory “c:” -Filter “Text Files (*.txt)|*.txt”

now I can browse to select the text file of computers.

can someone send me final version of this script, I cannot configure it to run with excel 2007.
matiss(dot)baltalksnis@gmail.com

Hi, How do I change this script to output to notepad, we do not have Excel?
Thanks

This looks great – however when choosing option 1 for all domain computers only one machine shows up. No errors pop up but in the debug window I see the following:

“Which computer resources would you like in the report?”
Undetermined
Undetermined

Any help would be appreciated.

Thanks,

Brian

I forgot to mention that i tried Jamey Westmoreland textversion provided in this thread. It resulted in me being posted to save the textfile numerous times as specified in the script but there were never any textfiles saved.
I also tried editing the script to use OpenOffice Calc instead (it’s installed next to Office 2010 Beta on my Vista-machine) but I was never able to “wake” Calc through the script.

Regards
/Bengt

using powershell 2.
created a simple script to output the computer names and descriptions.
Trying to output from a specific OU to a spreadsheet and format the two fields: name and description with no luck so far.
here’s the script:
$strFilter = “computer”

$objDomain = New-Object System.DirectoryServices.DirectoryEntry

$objSearcher = New-Object System.DirectoryServices.DirectorySearcher
$objSearcher.SearchRoot = “LDAP://servername/OU=laptops,ou=city,DC=domain,DC=com”
$objSearcher.SearchScope = “subTree”
$objSearcher.PageSize = 1000

$objSearcher.Filter = “(objectCategory=$strFilter)”
$colResults = $objSearcher.FindAll()

foreach ($i in $colResults)
{
$objComputer = $i.GetDirectoryEntry()
Get-WMIObject Win32_BIOS -computername $objComputer.Name,$objComputer.Description
}

Help would be appreciated. thanks.

I tried to run this script but it will open a blank excel 20007 sheet. Could you please update me if i am doing anything wrong? I have not modified anything within the script.

software inventory would be nice…

This is a sample code that lists inventory software I found..

Only thing is integrate this into excel file..

$RegPath= “SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall”
$BaseKey =[Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey(“LocalMachine”, $ComputerName)
$OpenSubKey = $BaseKey.OpenSubKey($RegPath)

$file = localhost
foreach ($obj in $file) {

$OpenSubKey.GetSubKeyNames() | foreach {
$BaseKey.OpenSubKey(“$RegPath\$_”).GetValue(“DisplayName”)
}
}

Menno: Thanks for the optimization!

would it be possible for the ip address to be imported in the columns next to each other instead of the row below it? If so how would i do that.

Love the script! it has saved me weeks of work

Way to go! Just ran the script on a Win7 SP1 desktop to a WinXP SP3 box and was floored by the process. A little more testing and I’ll try it on my servers.

I’m not sure if you’re still working on this, but I’m unable to run the script against my local PC (Win7 SP1). I’ll have to try it out on an XP machine.

Thanks!

Awesome script for getting inventory on servers, however it can seem to get information on all our windows 7 clients? any ideas on this? ( i know our clients are locked down pretty tightly, firwall maybe? )

Hmmm…I wonder if this could be sent to a csv file. For example, then you could simply imnport into Excel if you must run it from a server that cannot have MS Office installed.

script is good and working in my domain, but i want to know how we can wrtite script to work only one OU ratherthan complete domain.

Thanks for sharing.

I would suggest you check out the the following:

The Microsoft Assessment and Planning Toolkit.

I found it will do all things this script will do, and give some other information you might find useful, like can this machine be virtualized!

http://technet.microsoft.com/en-us/library/bb977556.aspx