If you need to do this with a SQL query, you can use xp_cmdshell to run the appropriate wmic command. To clean it up for querying, dump the results into...