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

Please log in to comment

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

Please log in to comment
Answer this question or Comment on this question for clarity