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/