This should get you going http://briandesmond.com/blog/script-to-collect-basic-inventory-data-from-machines/.
Drive info doesn't lend itself well to spreadsheets - it creates multidimensional data. You have 1 to many mappings between servers and drives. What I would do is export a separate worksheet with all the drive info as well as the server name and then you can use a PivotTable to easily view it. Thanks, Brian Desmond [email protected] c - 312.731.3132 Active Directory, 4th Ed - http://www.briandesmond.com/ad4/ Microsoft MVP - https://mvp.support.microsoft.com/profile/Brian From: MarvinC [mailto:[email protected]] Sent: Monday, July 13, 2009 1:49 PM To: NT System Admin Issues Subject: Server hw inventory software...FREE! Anyone have an app, script, or tool that'll perform a "surface level" hardware scan of your servers, regardless of brand, and present the info in spreadsheet format? I'm talking about memory, hard drive, and processor info for less than 200 physical Compaq and Dell servers. Any responses appreciated. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
