I've been trying to create a custom report wich shows me the IP, serial number (bios), manufacturer, monitor (ande serial) and logged on user but i get stuck at the first line, it keeps giving me waaaay to mutch results (eacht serial and ip gets 40+ replicas with a diffrent user) so I was wondering if anyone here could be of help
here's what i got so far:
[code]select network_card.net_ip_address, system.net_user_name, bios.bios_serial_number FROM openaudit.network_card, openaudit.system, openaudit.bios [/code]
this indeed gives me the wanted information, but waaay to mutch...
so i added:
[code]group by bios.bios_serial_number[/code]
but now i get 1 ip, 1 username and a lot of serial numbers... so i'm back at quare one