Hi all - I have a very simple query that shows me systems by BIOS date, to assist with evergreening:
[code]<?php
$query_array=array("headline"=>__("List all BIOS Dates"), "sql"=>"SELECT * FROM bios, system WHERE bios_uuid = system_uuid", "sort"=>"bios_version", "dir"=>"ASC", "get"=>array("file"=>"system.php", "title"=>__("Go to System"), "var"=>array("pc"=>"%system_uuid", "view"=>"summary", ), ), "fields"=>array("10"=>array("name"=>"system_uuid", "head"=>__("UUID"), "show"=>"n", ), "20"=>array("name"=>"bios_version", "head"=>__("BIOS Release Date"), "show"=>"y", ), "30"=>array("name"=>"net_ip_address", "head"=>__("IP"), "show"=>"y", "link"=>"y", ), "40"=>array("name"=>"system_name", "head"=>__("Hostname"), "show"=>"y", "link"=>"y", ), "50"=>array("name"=>"net_user_name", "head"=>__("Network User"), "show"=>"y", "link"=>"y", ), "60"=>array("name"=>"net_domain", "head"=>__("Domain"), "show"=>$show_domain, ), "70"=>array("name"=>"system_os_name", "head"=>__("OS"), "show"=>$show_os, ), "80"=>array("name"=>"system_service_pack", "head"=>__("Servicepack"), "show"=>$show_service_pack, ), "90"=>array("name"=>"system_timestamp", "head"=>__("Date Audited"), "show"=>$show_date_audited, ), "100"=>array("name"=>"system_system_type", "head"=>__("System Type"), "show"=>$show_type, "align"=>"center", ), "110"=>array("name"=>"system_description", "head"=>__("Description"), "show"=>$show_description, ),
), ); ?>[/code]
I would like to replace the Description column with the system_man_description field since it's here where admins will put info like "hack box - do not upgrade"...it seems more convenient than relying on the computer description local to each PC. However I'm no SQL expert and can't quite grasp what needs to change in order for this to work. I'm sure I need to add system_man into the SELECT statement and change the array name to system_man_description, but that doesn't quite do it. Can someone please assist?
Thanks,
-Doug
|