what disks attached to what or how many contollers on sql server

• tcroninlifepoint

  SSC Veteran

  Points: 235

  More actions

  December 17, 2019 at 8:53 pm

  #3708612

  is there a way at the server level to tell what drives are attached to what and how many contollers (is tsql even an option?)

• DinoRS

  SSCrazy

  Points: 2683

  More actions

  December 18, 2019 at 9:25 am

  #3708718

  tsql is not really useful here I think, have a look at this PowerShell Script instead

   

  $disks = gwmi win32_diskdrive
   
  foreach($disk in $disks)
  {
      $disk.psbase.getrelated('win32_scsicontroller')
  }
  $disks | Select *

  You can shorten the Output, most likely asides the Drive Letter you'll want SCSIBus, SCSILogicalUnit, SCSIPort and SCSITargetId