Possible to count number and types of end devices connected to switches across a large network?

Hello Networkers!

I'm trying to build a spreadsheet that counts and displays the types of end devices we have distributed across a very large network.

Here is an example, assuming 2 buildings, with 1 switch in each building:

Building A has Switch A. Switch A has 15 Windows Computers, 13 Cisco VOIPS, and 3 Dell Printers.

Building B has Switch B. Switch B has 11 Windows Computers, 1 Unix Server, 4 Cisco VOIPS, and 1 Dell Printer.

Is there some toolkit or method that can help accomplish this?

I've found in the UDT (SolarWinds tool) the overall Vendor types distributed across the network, indicating some number of Windows devices across the entirety of the network, but it does not break it down to "under a given switch".

Thanks in advance!

​

​