Report for Inventory of all Devices

Try this one

Note that you will have to do some tweaking as indicated by the commenters.

Thanks, was able to get it to work. 

Is there a way to include in the inventory to show what kind of device it is, not just Machine type, much simpler, such as router, switch, etc.?

Yep - anything you see in the Node Details page can be queried, just have to be good at SQL and poke around the database.