Open-AudIT

Hello,

In the Antivirus Report I can´t Filter Out the "Avast!" Software cause of a disallowed Character.
I think it must be the "!" in the Name.

[code]xxx.xxx.xxx.xxx/index.php/report/show_report/48/13/out___software_name___avast!%20Antivirus[/code]

And the Antivirus Report didnt lists Trend Micro Software.

I´ve fixed it for my uses:

Here is my Report.

[quote]<?xml version="1.0" encoding="ISO-8859-1"?>
<report>
<details>
<report_name>Installed - AntiVirus</report_name>
<report_description></report_description>
<report_display_in_menu>y</report_display_in_menu>
<report_sql><![CDATA[SELECT system.system_id, system.hostname, sys_sw_software.software_name, sys_sw_software.software_version FROM system INNER JOIN sys_sw_software ON (system.system_id = sys_sw_software.system_id AND system.timestamp = sys_sw_software.timestamp AND (software_name like '%virus%'or software_name like '%trend micro%' or software_name like '%endpoint%')) JOIN oa_group_sys ON (system.system_id = oa_group_sys.system_id and oa_group_sys.group_id = @group) GROUP BY hostname ORDER BY hostname]]></report_sql>
<report_view_file>v_report</report_view_file>
<report_view_contents></report_view_contents>
<report_processing></report_processing>
<report_sort_column>0</report_sort_column>
</details>
<columns>
<column>
<column_order>0</column_order>
<column_name>System Name</column_name>
<column_variable>hostname</column_variable>
<column_type>link</column_type>
<column_link>/main/system_display/</column_link>
<column_secondary>system_id</column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<column_order>1</column_order>
<column_name>Software Name</column_name>
<column_variable>software_name</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<column_order>2</column_order>
<column_name>Version</column_name>
<column_variable>software_version</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
</columns>
</report>

Edit the file open-audit/code_igniter/application/config/config.php
On line 144 add the exclamation mark to the list of permitted URI characters as below.
[code]$config['permitted_uri_chars'] = 'a-z 0-9~%.:|(),_\-!';[/code]
Let me know how you go

PS - I have added '%trend micro%' to the Installed - Antivirus report.

_________________
Support and Development hours available from [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.

It works:)

Thanks for the Help!

hope this will be fixed in the next Version, too:)