This SQL query contains the majority of the columns you’ll need to get you going from Device OS, Chassis Types, AD site, IP addresses and more! I also tidy a few things up like device manufacturer which is a mismatch depending on who the provider is.