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

Excellent script!!!.

Is there any possibilty to generate & save the report in CSV format instead of opening in Excel.
As we should not install office in any of the production server. though we have the possibility to install management tools in workstation.

If the file is saved in csv or excel format we can enhance the script and send a mail to the admin DL.

Please suggest.

Thank you for your prompt response.

Please do let me know if you are ready with the script.

Kindly let me know if we can get the mount point information along with the disk space report.

Once again Thanks

Great script for a relative Powershell n00b to get started with.

I need to make one SMALL change, and for the life of me I can’t see where it should go.

On our machines we have a file c:\windows\soe.txt – I need to write the first line of this file (the SOE version) to an additional column in the general sheet

Would you be able to point me in the right direction ?

@Nate @Elizabeth

Run it from a workstation with excel installed. It doesn’t have to be run from a server, just a computer with PS, Excel, and appropriate AD rights.

Thanks. This is awesome.

Very nice script; thanks for publishing!

Such a brilliant script, yep its going to save my weeks of efforts. Thanks so much Jesse.

Fantastic script, has anyone managed to amend the script to return the current user logged on to the PC?

@Ryan

Here’s what I’ve been using.
http://pastebin.com/yCymqgZK
Modified version of this one. Way less info but only the stuff I need. Should work for you.

Simply marvelous, the way data output is segregated and way it’s written, with all the comments.

Fantastic!!! I also would like to thank Menno for the modification changes to exclude computers which are not reachable.

Great script… Ran great on small set.

If I had serial numbers,I could then look up warrantee dates. Did anyone add this?

Thank you to everyone especially Jesse!

Nevermind, I wasn’t running with powershell I was just copying and pasting the code. It is working now

Can I use this script if I’m not on a Domain? If yes, how? All PC’s on my network are on specific workgroups e.g.: Factory1, Factory2, HR, Storage, etc.

You are a Genius!!!

Great script, runs perfect !
and my boss is going to think that you are the greatest thing since sliced bread.

I am a super newbie to powershell so i apologize upfront. Im looking in this script as to where i change it to point to a .txt file for the list of computers. Thanks so much for your time and for writing this script.

Hi,

Awesome script btw… well done. I am new to all this PS stuff, but can see massive benefits and learning from you all is just such a buzz, however, I am coming a cropper on a few things. I run the script, no issue, but I get the response “Undetermined” coming up as the script is running, the excel file does populate with some devices, but not workstations etc… this happens even if I run the script under admin creds or not. Any advice on that? Also, if I use a text file with device names in it, the script just kinda seems to hang and do nothing in the SS…. am I being too impatient? Any advice or help rally appreciated.

Excellent script! First one out of the box that did everything I needed it to do. I am a newbie to PS, and I am trying to add a few parameters and wondering if I can use your expertise. I would like to add the MAC address to the network output. In addition to the address, is there a way to add each physical adapter? It is only showing 1 adapter when it is teamed. Any advice would be greatly appreciated.

Only list one DNS Server with $objItem.DNSServerSearchOrder. Anyone can help me?
I got Windows 2008 R2

Great script, I love it!!!
One small problem I’ve found, it does not report any data from our Windows 2003 servers. Any ideas of what could cause it?
The windows firewall is not enabled on this servers and WMI is running.

Awesome script!

Is there any way of scheduling the script to scan all domain computers?
I’m a Primary school technician and I have 9 schools to visit each week. Half a day isn’t enough to take a manual inventory as well as doing other requests. If I could schedule the scan at odd times of the day, collecting information as the laptops are not always on. Don’t mind if it would accumulate with many open Excel documents, just knowing what the schools have would be a huge help to me (and our sales team )

The following script includes many of the suggestions posted here, plus a few of my own:

a) Include tabs for installed software, b) Roles and Features, and c) Scheduled tasks
b) Skip computers that cannot be accessed
c) Display the computer name being skipped or inventoried (if it is accessible or not)
d) When default switch action was “undetermined”, write to Excel file instead of screen.
e) Added compatibilty for Excel 2010 and 2013. (set culture to “us-en”)
f) Updated prompt for txt file dialog

The script can be downloaded from http://pastebin.com/3R7uveJs

My previous pastebin link pointed to the wrong version of the script. Please use this version instead: http://pastebin.com/GSemjRLe