Open-AudIT

I noticed that our RHEL servers don't populate into the activated "RedHat systems" group.

Any items that have their status attribute set to 'production' and have their os_family attribute set to 'RedHat'.

The os_family for our servers is "RedHatEnterpriseServer" would this be easy to tweak, so that they can be attached to the RedHat systems group?

thank you!

_________________
Server Info: running on a CentOS 7 vm
OA Version: 2.0.6 @ 500 devices

Admin - Groups - List Groups
Click edit icon for RedHat group
One method would be to change "Select SQL" to
[code]
SELECT
distinct(system.system_id)
FROM
system
WHERE
system.man_os_family LIKE 'RedHat%' AND
system.man_status = 'production'[/code]Update group description as appropriate.
Click Add button

Should work but haven't tested this.

Two solutions.
As per JPA's post (or edit the Group definition directly at open-audit/code_igniter/application/controllers/groups/RedHatSystems.xml)
I could also put a check in the processing of the audit script to force it to be os_family = "RedHat".

Typically (for example) Windows is:
os_group = Windows
os_family = Windows 2003
os_name = Windows 2003 Enterprise Server (whatever)

For Linux based systems we essentially have another level.
os_group = Linux
os_distribution = RedHat
os_family = RedHat Server
os_name = RedHat Enterprise Server 5.4 (whatever)

We obviously don't have an os_distribution column and I don't really want to make one. We would be without a column to know the distribution, but we could always (as per JPA's group definition change) filter using a like% clause instead of an =.

RedHat is likely a bad (very simple) example - think of the different Ubuntu flavour for instance... still, os_family like "%ubuntu% should cater to that as well.

I think I'll propose sticking to the group definition change for now unless someone can convince me otherwise

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