node:Static_Data
bretype:core::Static Data
editor:sortkey=5ea15db4167a7c97
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
Record
"Thu Mar 12 00:00:03 2020
Acct-Session-Id = ""0/0/3/320_032848C5""
Framed-IP-Address = 43.255.148.191
Framed-Protocol = PPP
User-Name = ""waterfro1@kalianet.to""
Cisco-AVPair = ""connect-progress=LAN Ses Up""
Cisco-AVPair = ""nas-tx-speed=1000000000""
Cisco-AVPair = ""nas-rx-speed=1000000000""
Acct-Session-Time = 5382
Acct-Input-Octets = 71721063
Acct-Output-Octets = 256278499
Acct-Input-Packets = 175185
Acct-Output-Packets = 238067
Acct-Authentic = RADIUS
Acct-Status-Type = Interim-Update
NAS-Port-Type = Ethernet
NAS-Port = 50331968
NAS-Port-Id = ""0/0/3/320""
Connect-Info = ""ACCESS-DYNAMIC""
Cisco-AVPair = ""client-mac-address=c471.5457.9edd""
Cisco-AVPair = ""circuit-id-tag=1 atm 02/34:0.34""
Service-Type = Framed-User
NAS-IP-Address = 10.254.32.14
PMIP6-Home-HN-Prefix = 3546:3732:3343::/50
Event-Timestamp = ""Mar 12 2020 00:00:03 +13""
NAS-Identifier = ""ha_bng2.kalianet.to""
Acct-Delay-Time = 0
Proxy-State = 0x3836
Acct-Input-Octets64 = 71721063
Acct-Output-Octets64 = 256278499
FreeRADIUS-Acct-Session-Start-Time = ""Mar 11 2020 22:30:21 +13""
Tmp-String-9 = ""ai:""
Acct-Unique-Session-Id = ""242a5d975725a2e3cb54058f74c10900""
Timestamp = 1583924403"
"Thu Apr 23 15:26:00 2020
Acct-Session-Id = ""0/0/3/320_032848C5""
Framed-IP-Address = 43.255.148.191
Framed-Protocol = PPP
User-Name = ""waterfro1@kalianet.to""
Cisco-AVPair = ""connect-progress=LAN Ses Up""
Cisco-AVPair = ""nas-tx-speed=1000000000""
Cisco-AVPair = ""nas-rx-speed=1000000000""
Acct-Session-Time = 5382
Acct-Input-Octets = 71721063
Acct-Output-Octets = 256278499
Acct-Input-Packets = 175185
Acct-Output-Packets = 238067
Acct-Authentic = RADIUS
Acct-Status-Type = Interim-Update
NAS-Port-Type = Ethernet
NAS-Port = 50331968
NAS-Port-Id = ""0/0/3/320""
Connect-Info = ""ACCESS-DYNAMIC""
Cisco-AVPair = ""client-mac-address=c471.5457.9edd""
Cisco-AVPair = ""circuit-id-tag=1 atm 02/34:0.34""
Service-Type = Framed-User
NAS-IP-Address = 10.254.32.14
PMIP6-Home-HN-Prefix = 3546:3732:3343::/50
Event-Timestamp = ""Mar 12 2020 00:00:03 +13""
NAS-Identifier = ""ha_bng2.kalianet.to""
Acct-Delay-Time = 0
Proxy-State = 0x3836
Acct-Input-Octets64 = 71721063
Acct-Output-Octets64 = 256278499
FreeRADIUS-Acct-Session-Start-Time = ""Mar 11 2020 22:30:21 +13""
Tmp-String-9 = ""ai:""
Acct-Unique-Session-Id = ""242a5d975725a2e3cb54058f74c10900""
Timestamp = 1583924403"
EOX
editor:XY=250,60
end:Static_Data

node:Output_Embedded_Key_Value_Pairs
bretype:core::Filter
editor:Label=Output Embedded Key Value Pairs
editor:sortkey=5ea19f05240e27c1
input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
output:@40fd2c7420761db6/=
prop:Script=<<EOX
## Convert each line in the record into a List
valuesList = Record.replace("\r\n", "\n").split("\n")

## Create an incrementing record ID variable
RecordID = execCount

## Get the date string for the current record
RecordDateStr = valuesList[0]

## Get the number of key=value elements in the record
numElements = len(valuesList)

## Initialize some variables for the loop
i = 1
key = str(null)
value = str(null)
test = str(null)

## Specify the output metadata 
output 1 {
    emit RecordID, RecordDateStr, key, value
    where false
} 

## Split out the key and value items and output each pair in a separate record
while i < numElements{
    keyValPair = valuesList[i].split(" = ")
    key = keyValPair[0]
    value = keyValPair[1].replace("\"", "")
    
    do output 1 {
        emit RecordID, RecordDateStr, key, value
    }
    
    i = i + 1
}

EOX
editor:XY=420,60
end:Output_Embedded_Key_Value_Pairs