/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Need some help creating a Network Interface Report in KBOX

09/18/2015 1905 views
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

Comments


All Answers

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

Answered 09/18/2015 by: chucksteel
Red Belt

 
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