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

Attachments:
Bereich1.png
Bereich1.png [ 4.44 KiB | Viewed 6036 times ]
Bereich.png
Bereich.png [ 28.83 KiB | Viewed 6036 times ]

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 :D

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/