query report

query report

hello

i need a query that shows the following information

dns name
connected ip
mac address
switch ip
port number
group name