Why not... It's a bit messy with the way Microsoft installs the suite with all the individual apps but should be close to usefull.
Create the view in list_viewdef_statistic_office.php [code]<?php
$query_array=array("headline"=>__("Statistic for Microsoft Office Versions"), "sql"=>" SELECT DISTINCT software_name, software_version, COUNT( * ) AS count_item, round( 100 / ( SELECT count(software_uuid) FROM software, system WHERE software_name LIKE 'Microsoft Office%' AND software_timestamp=system_timestamp AND software_uuid=system_uuid ) * COUNT( * ) ,$round_to_decimal_places ) AS percentage FROM software, system WHERE software_name LIKE 'Microsoft Office%' AND software_timestamp=system_timestamp AND software_uuid=system_uuid GROUP BY software_name ", "sort"=>"software_name", "dir"=>"ASC", "get"=>array("file"=>"list.php", "title"=>__("Systems installed this Version of this Software"), "var"=>array("name"=>"%software_name", "version"=>"%software_version", "view"=>"systems_for_software_version", "headline_addition"=>"%software_name", ), ), "fields"=>array("10"=>array("name"=>"software_name", "head"=>__("Name"), "show"=>"y", "link"=>"y", ), "20"=>array("name"=>"software_version", "head"=>__("Version"), "show"=>"y", "link"=>"y", ), "30"=>array("name"=>"count_item", "head"=>__("Count"), "show"=>"y", "link"=>"n", "search"=>"n", ), "40"=>array("name"=>"percentage", "head"=>__("Percentage"), "show"=>"y", "link"=>"n", "search"=>"n", ), ), ); ?>[/code]
Make the view accessible from the main menu
[code]Index: include_menu_array.php =================================================================== --- include_menu_array.php (revision 1251) +++ include_menu_array.php (working copy) @@ -210,8 +210,9 @@ "22"=>array("name"=>"Thunderbird Versions", "link"=>"./list.php?view=statistic_thunderbird", "image"=>"images/mail_tb.png", "title"=>"Mozilla Thunderbird Versions",), "23"=>array("name"=>"Adobe Flash Player Versions", "link"=>"./list.php?view=statistic_adobe_flash_player", "image"=>"images/adobe_flash_player.png", "title"=>"Adobe Flash Player Versions",), "24"=>array("name"=>"Adobe Reader Versions", "link"=>"./list.php?view=statistic_adobe_reader", "image"=>"images/adobe_reader.png", "title"=>"Adobe Reader Versions",), - "25"=>array("name"=>"OpenOffice.org Versions", "link"=>"./list.php?view=statistic_openoffice.org", "image"=>"images/oo.org.png", "title"=>"OpenOffice.org Versions",), - "26"=>array("name"=>"Java Versions", "link"=>"./list.php?view=statistic_java", "image"=>"images/java.png", "title"=>"Java Versions",), + "25"=>array("name"=>"Microsoft Office Versions", "link"=>"./list.php?view=statistic_office", "image"=>"images/x-office-spreadsheet.png", "title"=>"Microsoft Office Versions",), + "26"=>array("name"=>"OpenOffice.org Versions", "link"=>"./list.php?view=statistic_openoffice.org", "image"=>"images/oo.org.png", "title"=>"OpenOffice.org Versions",), + "29"=>array("name"=>"Java Versions", "link"=>"./list.php?view=statistic_java", "image"=>"images/java.png", "title"=>"Java Versions",), "30"=>array("name"=>"Memory Size", "link"=>"./list.php?view=statistic_memory", "image"=>"images/memory.png", "title"=>"Memory Size",), "40"=>array("name"=>"Processor Types", "link"=>"./list.php?view=statistic_processor", "image"=>"images/processor.png", "title"=>"Processor Types",), "50"=>array("name"=>"Hard Drive", "link"=>"./list.php?view=statistic_harddrive", "image"=>"images/harddisk.png", "title"=>"Hard Drive",), [/code]
|