Open-AudIT

I want to share this report I created, it would be nice a section in open-audit.org with user reports to download, with votes.

I have one question, in the report I joined multiple rows in one field. As a separator, I tried both <br> and \n, but it doesn't work as expected (it writes aaa<br>bbb or aaa bbb). Any suggestion on which separator to use?

Thanks

Nice report, I like!

But what I believe is likely happening is that in the views folder in the CI application, the output of the query is set to display literally the results from MySQL. I don't think is possible to add HTML to the SQL query without changing or creating a new view for this particular report

_________________
Old OA Setup: 500 Windows 7 workstations & 200 Apple OSX with OA v1.5.2 on Windows Server 2003 and WAMP 2
New OA Setup: 100 Windows servers with OA 2.2 on Windows Server 2016 and WAMP 3

Thanks for the nice template.

Can you have another HW report on 3 following: HW adding - HW removing - HW changing ONLY?

[quote="sccuser"]Thanks for the nice template.

Can you have another HW report on 3 following: HW adding - HW removing - HW changing ONLY?

[quote="sgiunchi"]I don't know how to do it, I don't think it's possible with the actually collected data.

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

Big apologies - this slipped off my radar. It will be in the next release, but here's a copy.
It's untested (other than it runs) as I don't have any devices with hardware changes (at the moment).


[code]<?xml version="1.0" encoding="ISO-8859-1"?>
<report>
<details>
<report_name>Alerts - Hardware</report_name>
<report_display_in_menu>y</report_display_in_menu>
<report_sql><![CDATA[SELECT oa_alert_log.alert_id, oa_alert_log.system_id, oa_alert_log.timestamp, system.man_ip_address, system.hostname, system.man_description, oa_alert_log.alert_details FROM system, oa_alert_log, oa_group_sys WHERE oa_alert_log.user_id is NULL AND oa_alert_log.system_id = system.system_id AND oa_alert_log.system_id = oa_group_sys.system_id AND oa_group_sys.group_id = @group AND oa_alert_log.alert_table like 'sys_hw_%' GROUP BY oa_alert_log.alert_id ORDER BY oa_alert_log.timestamp DESC ]]></report_sql>
<report_view_file>v_report_alerts</report_view_file>
<report_view_contents></report_view_contents>
<report_processing></report_processing>
<report_sort_column>0</report_sort_column>
<report_description>Any Hardware Alerts created by newly found, no longer present or changed items.</report_description>
</details>
<columns>
<column>
<column_order>0</column_order>
<column_name>Timestamp</column_name>
<column_variable>timestamp</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>1</column_order>
<column_name>IP Address</column_name>
<column_variable>man_ip_address</column_variable>
<column_type>ip_address</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>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>3</column_order>
<column_name>System Description</column_name>
<column_variable>man_description</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>4</column_order>
<column_name>Details</column_name>
<column_variable>alert_details</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>5</column_order>
<column_name>Tags</column_name>
<column_variable>tag</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>[/code]

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