here's a query inspired by a post from garth jones for something sherry kissinger whipped up. this sql query basically gives you an output of all of your machines, with the type of chassis. select sys.name0 as 'Name' , sys.manufacturer0 as 'Manufacturer' , sys.model0 as 'Model' , case enc.chassistypes0 when 1 then 'Other' when 2 then 'Unknown' when 3 then 'Desktop' when 4 then 'Low Profile Desktop' when 5 then 'Pizza Box' when 6 then 'Mini Tower' when 7 then 'Tower' when 8 then 'Portable' when 9 then 'Laptop' when 10 then 'Notebook' when 11 then 'Hand Held' when 12 then 'Docking Station' when 13 then 'All in One' when 14 then
notes, ramblings, contemplations, transmutations, and otherwise ... on management and directory miscellanea.