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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share