WMI data reader to collect disk information of remote computer

• harikumar.mindi

  SSCommitted

  Points: 1972

  More actions

  June 29, 2016 at 10:06 am

  #400339

  Hi Geeks,

  I am stuck on a SSIS package collecting disk information for a remote computer. Currently i have the package collecting disk information for remote computers within the same domain, however i would need this package to fetch the information of a computer in a different domain. There is a trust relationships between the domains hence same login can be used to login to both the servers.

  We are passing the server name to the WMI datareader task and using the below code to fetch the information "Select BlockSize,Capacity, Caption,FreeSpace, SerialNumber,SystemName

  from Win32_Volume where Caption like "%:%" and DriveType = 3"

  I tried to pass the IP instead of servername and still it does not work.

  Any other workaround solutions for this issue ?

  Thanks,