Need some help creating a Network Interface Report in KBOX
Hello,
I need to generate a report where you can see what network adapters are in each computer from inventory.
I have tried a few test but I can't elaborate one with exactly what I want... Indeed I think I managed to gather all info but the one I need.
I did something similar in the past to get McAfee .DAT versions but if I'm honest I don't recall how I did it.
Does anyone knows how to do this? Either by GUI or SQL Sequence?
Thanks in advance
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
8 years ago
This query will list the NICs installed on each machine:
SELECT NAME, OS_NAME, GROUP_CONCAT(NIC.NIC) AS NICS FROM ORG1.MACHINE
JOIN MACHINE_NICS NIC ON NIC.ID = MACHINE.ID
GROUP BY MACHINE.ID
