/build/static/layout/Breadcrumb_cap_w.png

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?
riGpjw.jpeg

Thanks in advance



0 Comments   [ + ] Show comments

Answers (1)

Posted by: chucksteel 9 years ago
Red Belt
0
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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ