About ekucevic

ekucevic · ‎11-23-2021

I am going to accept this solution. Really appreciate your help. One thing i noticed is these are periodic logs and usually the serial numbers can change. I added dedup lruHwSerialNumber thinking it would pull the different serial based on the time frame i know it changed but it doesnt seem to pull it.

ekucevic · ‎11-22-2021

Lets say i dont want to add in a 3rd field, I find that when i just change one of the components of your solution from "lruHwPartNumber" to "lruHwSerialNumber" it doesnt give me any results.

ekucevic · ‎11-21-2021

This is exactly what i was looking for. Really appreciate it. One more thing, i want to add in 3rd column, "lruHwSerialNumber" and also these "lruHwSerialNumber"s change over time. When i add in the serial number column will "Dedup _lruHwSerialNumber" work?

ekucevic · ‎11-19-2021

I have a log sample: | LRU Config Message from RMQ: {"endpoint":"lru/ config", "data":{"timestamp":1637322539.953,"version":"1","aircraftTailId":"N123JB",[{"lruComponent":"Modem","lruHwPartNumber":"123456","lruHwSerialNumber":"C82821190191","lruRevisionNumber":"004","lruMacAddress":true}, {"lruComponent":"Server","lruHwPartNumber":"1244632","lruHwSerialNumber":"F39718480040","lruRevisionNumber":"004","lruMacAddress":null}, What i want to do is extract the date and create a table based on the color i highlighted above. lruComponent | lruHwPartNumber | Modem 123456

ekucevic · ‎07-08-2021

Hi, Thanks for your reply, I think my issue is due to quotes within quotes? No sure. Below is a sample of my search. Basically everything in red is a sample what i am searching for. [{"lruName":"Modem","lruType":"MBR","lruMacAddress":"00:A0:BC:72:6F:44","lruModelNumber":"MBR-5500","lruSerialNumber":"C80016506037","lruPartNumber":"1244523","lruSoftwareVersion":"M3-1.3.5.2.89_2021.06.18","lruConfigVersion":"7.10.0.38"

ekucevic · ‎07-06-2021

I am a beginner here so alittle bit of a walk through could be necessary.

ekucevic · ‎07-06-2021

I source database that displays all of the info i need that is separated by colon. Example "ilruPartNumber":"12345"., "lruSoftwareVersion":"7.10.0.74". All of the info i need is separated by an " : " What i want is to separate the search to list the Name then Number. Example ilruPartNumber = 12345.

ekucevic · ‎05-25-2021

I have events in my logs. I want to capture "temp" and table it received_time="2021-05-25T15:51:22.181+00:00"] 37 pollAcu20:830 ACU: PSU: Connected: true Output voltage: 4775 0.01V, Output current: 36 0.01A Critical temp: 426 0.1 Deg C Status: 0x3 Fault: false

Posts	8
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎05-24-2021

Online Status	Offline
Date Last Visited	‎11-23-2021 05:19 PM

Help me extract this data and create a table.

Searches separated by Colon

Look at value ahead of string and table it

Re: Help me extract this data and create a table.

Re: Help me extract this data and create a table.

Re: Help me extract this data and create a table.

Help me extract this data and create a table.

Re: Searches separated by Colon

Re: Searches separated by Colon

Searches separated by Colon

Look at value ahead of string and table it