Need Script to Poll AD for Servers

I would get the Quest AD cmdlets and use powershell for most of this. Here are some examples.

get-qadcomputer | Where {$_.osname -match "Server"} | Select Name, OSVersion, OSSerivcePack

$Servers = get-content c:\servers.txt
$Servers | Foreach {gwmi -computer $_ -class win32_service | Where {
    ($_.startname -ne "LocalSystem") -And ($_.Startname -ne "NT AUTHORITY\LocalService") -And ($_.startname -ne "NT AUTHORITY\NetworkService")}} | 
        Select __Server, Name, StartName

SOLUTION

rlandquist

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

rlandquist

Here is the link to download the Quest AD cmdlets:
http://www.quest.com/powershell/activeroles-server.aspx

ASKER

Experts,

I was able to use the line posted in http:#a35514409 to get an enumerated list. When using the code in post http:#a35514190 I get this error for each line in the CSV:

Get-WmiObject : The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
At C:\Users\*********\Desktop\serverservices.ps1:2 char:25
+ $Servers | Foreach {gwmi <<<<  -computer $_ -class win32_service | Where {
    + CategoryInfo          : InvalidOperation: (:) [Get-WmiObject], COMException
    + FullyQualifiedErrorId : GetWMICOMException,Microsoft.PowerShell.Commands.GetWmiObjectCommand

Further guidance is appreciated.

DrUltima

If you are importing a CSV file try this with the rest of the code posted before.

$Servers = import-csv c:\servers.csv
$Servers | Foreach {gwmi -computer $_.Computername

ASKER

KenMcF,

That made the script run, but it didn't error check (if the server is in AD but not live, it throws an error). I also noticed that on successful polls, it throws the data to the console. Here is what I used:

$Servers = import-csv c:\users\*******\desktop\serverlist.csv
$Servers | Foreach {gwmi -computer $_.Computername -class win32_service | Where {
    ($_.startname -ne "LocalSystem") -And ($_.Startname -ne "NT AUTHORITY\LocalService") -And ($_.startname -ne "NT AUTHORITY\Network Service")}} | Select __Server, Name, StartName

Admittedly, I don't know nearly enough about PowerShell, but it seems to export it, I would need something like this:

$Servers = import-csv c:\users\********\desktop\serverlist.csv
$Servers | Foreach {gwmi -computer $_.Computername -class win32_service | Where {
    ($_.startname -ne "LocalSystem") -And ($_.Startname -ne "NT AUTHORITY\LocalService") -And ($_.startname -ne "NT AUTHORITY\NetworkService")}} | Select __Server, Name, StartName | Export-Csv c:\users\********\desktop\ServicesExport.csv

I also have no idea how to make it do a "If you can't find the server, then just log it as unavailable" type of entry.

DrUltima

Here is one that will test to see if the host is up before it does the WMI query. I can post more tonight when I have more time to output if the server was not avalible.

$Servers | Foreach {
If (Test-Connection $_.ComputerName -count 1 -q){
gwmi -computer $_.ComputerName -class win32_service | Where {  
    ($_.startname -ne "LocalSystem") -And ($_.Startname -ne "NT AUTHORITY\LocalService") -And ($_.startname -ne "NT AUTHORITY\NetworkService")}}} | 
        Select __Server, Name, StartName | 
            Export-Csv d:\ServicesExport.csv

ASKER

KenMcF,

Thank you again. I look forward to your further assistance. The last thing I would like to do is determine (by polling DNS or the computer itself) what the IP address should be.

DrUltima

Chris Dent

The Native (.NET) way is:

[Net.Dns]::GetHostEntry("somehostname")

There are non-native ways, but this is the simplest :) Pull the AddressList property off any response you get. I'd chuck that into Select-Object myself.

Chris

SOLUTION

Chris Dent

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Chris,

Thanks for jumping in... It works as you have placed it (once I changed file names and locations). Unfortunately, I only get entries for servers who have domain-used services doing it this way. It would be better if I can get the IP address in the first report, which is generated with this single line:

get-qadcomputer| where-object {$_.OSName -like "*server*"}|select-object computername, osname, osservicepack, computerrole | export-csv C:\users\********\desktop\serverlist.csv -notype

DrU

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

Chris Dent

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.