Open-AudIT https://www.open-audit.org/phpBB3/ |
|
Group Software by Name https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6392 |
Page 1 of 1 |
Author: | Brick [ Wed Jan 07, 2015 10:34 pm ] |
Post subject: | Group Software by Name |
Hi, is there a way to group simmilar software by name ? e.g software like Adobe Flash Player. This kind of software is displayed in every Version. (V11, V12, V13 ...) or Adobe Reader. (10.10, 10.11, 10.2, 10,3 ...) Cheers Brick |
Author: | Mark [ Thu Jan 08, 2015 7:27 am ] |
Post subject: | Re: Group Software by Name |
On which page(s)? The Installed Software Query (this should already be grouped by name)? The Device Details page? |
Author: | Brick [ Thu Jan 08, 2015 4:54 pm ] | |||
Post subject: | Re: Group Software by Name | |||
Hi, yes, in the installed software query.. look at the screenshots i have attached. Cheers Brick
|
Author: | jpa [ Fri Jan 09, 2015 4:26 am ] |
Post subject: | |
The first screenshot is easier to change than the second. For the first you could create a new report based on the original report in code_igniter\application\controllers\reports\Installed-Software.xml. Modify the report_sql in the xml file and change the group by clause. You should probably remove the software_version column from the report as well. [code]GROUP BY sys_sw_software.software_name, sys_sw_software.software_version to GROUP BY sys_sw_software.software_name[/code] The second situation is much harder as the name has the version in it which is causing the grouping you don't want. Since every software package defines its name differently you'd need to find a way to strip the version out. I don't know of a good way to do this generically. |
Author: | Mark [ Fri Jan 09, 2015 9:16 am ] |
Post subject: | Re: Group Software by Name |
What JPA said |
Author: | Brick [ Fri Jan 09, 2015 4:54 pm ] |
Post subject: | Re: Group Software by Name - solved |
ok, thanks JPA... works fine.. |
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |