Bulk Insert WMIC output to table w/ xp_cmdshell

Total article views: 57 | Views in the last 30 days: 8

(not yet rated)  Rate this |   Join the discussion |  Briefcase

This is an example of retrieving WMIC results using the xp_cmdshell proc, and inserting the results into a table.

Specifically, this script retrieves disk info from the LogicalDisk class, but WMIC provides thousands of other properties. WMIC does require it be ran from a Windows 2003 server, but can query other Windows 2000 servers when executed from a W2003 server.

NOTE: If WMIC hasn't been run on the server before, it'll do a compile on its first run. I recommend doing a manual execution of WMIC first before using this script, so you don't insert an extraneous output into the temp table

This example lists the available alias' on the system (e.g. WMIC alias list brief)

WMIC Reference:
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/wmic_overview.mspx?mfr=true

Total article views: 57 | Views in the last 30 days: 8