Open-AudIT https://www.open-audit.org/phpBB3/ |
|
Each computer shows 2 video cards https://www.open-audit.org/phpBB3/viewtopic.php?f=10&t=3077 |
Page 1 of 1 |
Author: | jhsedona [ Fri Nov 21, 2008 5:55 pm ] |
Post subject: | Each computer shows 2 video cards |
I want to show most of list include video card in one screen sorting by system name. but Some computers shows 2 video cards. So it shows duplicated system with 1 video card,and next line 2nd video card. Is there a way to modify sql key to grab and shows 1 system with 2 video cards in one line ? This is what i did, but it shows twice of current systems. "sql"=>"SELECT * FROM `system`, `processor`, `hard_drive`, `video` WHERE system_uuid = hard_drive_uuid AND system_uuid = processor_uuid AND system_uuid = video_uuid AND hard_drive_uuid = processor_uuid AND system_timestamp = processor_timestamp AND system_timestamp = hard_drive_timestamp AND processor_device_id = 'CPU0' AND hard_drive_index = 0" and this for listing "fields"=>array("10"=>array("name"=>"system_uuid", "head"=>__("UUID"), "show"=>"n", ), "155"=>array("name"=>"video_caption", "head"=>__("Video"), "show"=>"y", ) Any help will be appreciated. |
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |