Hey All,
I've a Problem to Build an Custom Report.
I need to Replace a String here is the Code:
[Authentication::Gast::223-Nring-Mitarbeiter Gastzugang]
type=abstract
description=Liste über alle Freien Gastzugänge in einem Monat
base_table=locationlog
searches=string:VLAN:locationlog.vlan,string:Benutzer:node.pid,string:MAC:node.mac
#columns=security_event.start_date "Event date", class.description "Security
Event Name", node.status "Node status", node.mac "MAC Address",
node.computername "Computer Name", node.pid "Owner", node.device_class "Device
Class", node_category.name "Role"
columns=node.mac "MAC Address", ip4log.ip "IP", locationlog.vlan "VLAN",
node.pid "Benutzer", replace(radius_audit_log.nas_identifier, "-", ":")
"RuckusAP", node.last_seen "Zuletzt gesehen", node.regdate "Registriert am",
node.unregdate "Unregistrieren am", node.device_type "Devicetyp",
node.computername "Devicename"
joins= <<EOT
=>{locationlog.mac=ip4log.mac} ip4log|ip4log
=>{locationlog.mac=node.mac} node|node
=>{locationlog.mac=auth_log.mac} auth_log|auth_log
=>{locationlog.start_time=radius_audit_log.created_at}
radius_audit_log|radius_audit_log
EOT
node_fields=MAC Address
#person_fields=Owner
date_field=regdate
base_conditions_operator=any
base_conditions=locationlog.vlan:=:223
#role_fields=category_id
charts=scatter|Registriert am
has_limit=enabled
group_field=node.mac
date_limit=1M
As Result the Table looks like:
[cid:image003.png@01D8DC83.0A67A220]
If I delete the Part replace(radius_audit_log.nas_identifier, "-", ":")
"RuckusAP", with radius_audit_log.nas_identifier "RuckusAP" the MAC Looks like
this: 34-FA-9F-17-9F-50
So it works with Replace, but pf detect some part of the replace string like a
new Row, someone any idea?
Thanks a lot!
--
Diese Mail wurde auf Computerviren geprüft
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
