How to get list of servers with the SCSI controller model ?

Hi All,

using powershell in Active Directory, can anyone here please share the Powershell script to list all server name and its SCSI card name ?

I wonder if that is possible.
LVL 12
Senior IT System EngineerSenior Systems EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavidPresidentCommented:
Here is a MSFT blog site that lists several MSFT-written tools that can enumerate device manager remotely.

http://blogs.technet.com/b/wincat/archive/2012/09/06/device-management-powershell-cmdlets-sample-an-introduction.aspx
Senior IT System EngineerSenior Systems EngineerAuthor Commented:
Ok, so I f I have several hundreds servers in an OU can it shows or export it to csv ?
DavidPresidentCommented:
The script won't care how many systems you have, but it will care that you have a supported client operating system.  You would have to modify the script to create output in csv format.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
The script will not care for remote systems at all, and it is overkill for a "simple" task like this.
The difficulty is
  a) to get all AD computers without having the ActiveDirectory cmdlet available (it is W2008 (?))
  b) to run the query on remote machines,
  c) to filter for interesting data,
  d) creating something usable as report.

Mixing different techniques makes it work:
dsquery computer |
  % {
    $pc = $_.Split('=,')[1]
    Write-Host -f yellow $pc
    Get-WmiObject Win32_SCSIController -computer $pc } | select SystemName, Name, Manufacturer, Status
   } | export-CSV -NoType 'C:\Temp\EE\SCSI Report.csv'

Open in new window

There is no way to check for servers only. But if you follow a naming convention making servers stick out of the AD computer names, the dsquery results can be filtered for that.
Senior IT System EngineerSenior Systems EngineerAuthor Commented:
Hi @QLemo, I've created this simple script using Powershell Quest AD to narrowed down the search:

$ErrorActionPreference = "SilentlyContinue"

$server = Get-QADComputer -SearchRoot 'domain.com/Production Servers' -OSName "Windows*Server*" | Where-Object { Test-Connection $_.Name -Count 1 -Quiet }

foreach($computer in $server) {
	
}

Open in new window


is it possible to use that by merging it with your script above ?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
$ErrorActionPreference = "SilentlyContinue"

Get-QADComputer -SearchRoot 'domain.com/Production Servers' -OSName "Windows*Server*" |
  ? { Test-Connection $_.Name -Count 1 -Quiet } |
  % {
    $pc = $_.Name
    Write-Host -f yellow $pc
    Get-WmiObject Win32_SCSIController -computer $pc } | select SystemName, Name, Manufacturer, Status
   } | export-CSV -NoType 'C:\Temp\EE\SCSI Report.csv'  

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Senior IT System EngineerSenior Systems EngineerAuthor Commented:
many thanks !
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.