Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- About rfds
rfds
Path Finder
Member since:
05-29-2013
04-13-2021
Community Statistics
| Posts | 13 |
| Solutions | 1 |
| Karma Given | 3 |
| Karma Received | 5 |
| Member Since | 05-29-2013 |
Activity Feed
- Karma Re: strptime/strftime not working for martin_mueller. 06-05-2020 12:47 AM
- Got Karma for How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned?. 06-05-2020 12:47 AM
- Karma Re: geoip search results not correct for ziegfried. 06-05-2020 12:46 AM
- Karma Re: Google Maps and Splunk 6 - limited results graphing. for pmos69. 06-05-2020 12:46 AM
- Got Karma for Scheduled PDF Delivery to file or folder not via email. 06-05-2020 12:46 AM
- Got Karma for Scheduled PDF Delivery to file or folder not via email. 06-05-2020 12:46 AM
- Got Karma for Scheduled PDF Delivery to file or folder not via email. 06-05-2020 12:46 AM
- Got Karma for Re: Scheduled PDF Delivery to file or folder not via email. 06-05-2020 12:46 AM
- Posted Custom style with MapBox map on All Apps and Add-ons. 09-09-2019 07:25 AM
- Tagged Custom style with MapBox map on All Apps and Add-ons. 09-09-2019 07:25 AM
- Tagged Custom style with MapBox map on All Apps and Add-ons. 09-09-2019 07:25 AM
- Posted Re: How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned? on All Apps and Add-ons. 06-09-2015 08:58 PM
- Posted Re: How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned? on All Apps and Add-ons. 06-09-2015 01:14 AM
- Posted Re: How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned? on All Apps and Add-ons. 06-09-2015 12:44 AM
- Posted Re: How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned? on All Apps and Add-ons. 06-02-2015 12:52 AM
- Posted Re: How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned? on All Apps and Add-ons. 06-01-2015 06:58 PM
- Posted Re: How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned? on All Apps and Add-ons. 06-01-2015 05:10 AM
- Posted How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned? on All Apps and Add-ons. 06-01-2015 12:41 AM
- Tagged How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned? on All Apps and Add-ons. 06-01-2015 12:41 AM
- Tagged How to troubleshoot why REST API Modular Input stopped working and how to create my own response handler to split the array returned? on All Apps and Add-ons. 06-01-2015 12:41 AM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 1 | |||
| 0 | |||
| 3 |
09-09-2019
07:25 AM
Found this article:
https://www.splunk.com/blog/2017/06/01/enhancing-splunk-visualizations-with-mapbox.html
Trying to use my own style created in MapBox applied to a default MapBox map - I.e.
https://api.mapbox.com/v4/mapbox.streets
https://api.mapbox.com/v4/mapbox.streets/{z}/{x}/{y}@2x.png?access_token=your-access-token
Found this:
https://docs.mapbox.com/api/maps/#vector-tiles
Tried adding “style” like this:
https://api.mapbox.com/v4/mapbox.mapbox-streets-v8/12/1171/1566.mvt?style=mapbox://styles/mapbox/streets-v11@00&access_token=YOUR_MAPBOX_ACCESS_TOKEN
However, the map doesn’t render in Splunk - works ok with the default though (
https://api.mapbox.com/v4/mapbox.streets/{z}/{x}/{y}@2x.png?access_token=your-access-token)
Any ideas please?
... View more
06-09-2015
08:58 PM
Nevermind - I made a typo which I've corrected and it is all working now. Thanks a lot for your help.
... View more
06-09-2015
01:14 AM
I just also tried this on a different Splunk instance - running on Mac OS X rather than Windows. On the Mac OS X instance the events are getting indexed the way I want after specifying the new custom response handler.
Could these issues be caused due to running on Windows?
Thanks
... View more
06-09-2015
12:44 AM
Excellent, thanks for that. I just tried adding that class to responsehandlers.py like I did the other day with my less elegant attempt. I restarted Splunk and also tried disabling and enabling the rest_ta Splunk app, but having specified that response handler in a REST input that does was indexing events using the default handler, no further events are getting indexed. I also tried adding a whole new input and specifying the new handler and a new index just for testing but no events get indexed.
Any ideas please?
Many thanks
... View more
06-02-2015
12:52 AM
I've tried adding my own response handler to responsehandlers.py with the aim of getting each flight element indexed indiviudally as follows:
class FlightXMLHandler:
def __init__(self,**args):
pass
def __call__(self, response_object,raw_response_output,response_type,req_args,endpoint):
if response_type == "json":
flightxmlrawdata = json.loads(raw_response_output)
flightxmlfirstlevel = flightxmlrawdata['FlightInfoExResult']
flightxmlflights = flightxmlfirstlevel['flights']
for flight in flightxmlflights:
print_xml_stream(json.dumps(flight))
else:
print_xml_stream(raw_response_output)
I based this on the following python code I got working offline - outputs each flight element as a separate line:
import json
flightxmlrawresponse = 'PASTED RAW XML EXAMPLE ABOVE HERE'
flightxmlrawdata = json.loads(flightxmlrawresponse)
flightxmlfirstlevel = flightxmlrawdata['FlightInfoExResult']
flightxmlflights = flightxmlfirstlevel['flights']
for flight in flightxmlflights:
print json.dumps(flight)
Doesn't seem to work though - any ideas where I'm going wrong?
... View more
06-01-2015
06:58 PM
Found this in splunkd.log:
06-02-2015 01:17:35.951 +0930 ERROR ExecProcessor - message from "python "C:\Program Files\Splunk\etc\apps\rest_ta\bin\rest.py"" Exception performing request: HTTPConnectionPool(host='flightxml.flightaware.com', port=80): Max retries exceeded with url: /json/FlightXML2/FlightInfoEx?ident=VHFVF (Caused by <class 'socket.error'>: [Errno 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond)
... View more
06-01-2015
05:10 AM
Also, when I clone the input that is not working and set it to a different (test) index it works ok.
... View more
06-01-2015
12:41 AM
1 Karma
Hi,
I've installed this app in my Splunk 6.2.3 instance running on Windows and have been able to use it to set up a few data inputs, for example here is one pulling in data using the flightaware.com FlightXML API - returns recent flight info for a particular aircraft 'ident':
[rest://FlightXML VH-FVF]
auth_password = ____________
auth_type = basic
auth_user = ________
endpoint = http://flightxml.flightaware.com/json/FlightXML2/FlightInfoEx
host = VH-FVF
http_method = GET
index = flightaware
index_error_response_codes = 0
polling_interval = 60
response_type = json
sourcetype = flightxml
streaming_request = 0
url_args = ident=VHFVF
I've got a few of these working - all the same except I've changed the host and url_args values. These are returning and indexing an array of flights.
I thought I'd have a go at setting up my own response handler to parse and split the array returned so that each element of the flights array is indexed individually. Somehow in doing this I think I've broken the one input in the example below, but all the others work ok still. I've tried removing and re-adding the input, reset $SPLUNKHOME$\etc\apps\rest_ta\bin\responsehandlers.py and $SPLUNKHOME$\etc\apps\rest_ta\bin\responsehandlers.pyc to default, restarted Splunk and even restarted the whole server but still no new events are getting indexed.
Can someone please offer some advice on how to troubleshoot this?
Also, I'd love some advice on how to create my own response handler to split the array. I'm new to python.
Here is an example of the raw output indexed at the moment in line with the input above:
{"FlightInfoResult":{"next_offset":15,"flights":[{"ident":"FD531","aircrafttype":"PC12","filed_ete":"01:21:00","filed_time":1432678027,"filed_departuretime":1432684800,"filed_airspeed_kts":269,"filed_airspeed_mach":"","filed_altitude":170,"route":"DCT YTHI RIKAB N640 AD","actualdeparturetime":1432688340,"estimatedarrivaltime":1432690260,"actualarrivaltime":1432690360,"diverted":"","origin":"YTHI","destination":"YPAD","originName":"","originCity":"","destinationName":"Adelaide Int'l","destinationCity":"Adelaide, South Australia AU"},{"ident":"FD531","aircrafttype":"PC12","filed_ete":"00:55:00","filed_time":1432678011,"filed_departuretime":1432679400,"filed_airspeed_kts":271,"filed_airspeed_mach":"","filed_altitude":180,"route":"DCT AD J15 YORKE","actualdeparturetime":1432680900,"estimatedarrivaltime":1432683480,"actualarrivaltime":1432683480,"diverted":"","origin":"YPAD","destination":"YTHI","originName":"Adelaide Int'l","originCity":"Adelaide, South Australia AU","destinationName":"","destinationCity":""},{"ident":"FD520","aircrafttype":"PC12","filed_ete":"00:41:00","filed_time":1432657590,"filed_departuretime":1432661700,"filed_airspeed_kts":266,"filed_airspeed_mach":"","filed_altitude":160,"route":"DCT REN V395 BLACK V454 AD","actualdeparturetime":1432662120,"estimatedarrivaltime":1432664460,"actualarrivaltime":1432664449,"diverted":"","origin":"YREN","destination":"YPAD","originName":"Renmark","originCity":"Renmark, South Australia AU","destinationName":"Adelaide Int'l","destinationCity":"Adelaide, South Australia AU"},{"ident":"FD520","aircrafttype":"PC12","filed_ete":"00:19:00","filed_time":1432657590,"filed_departuretime":1432658700,"filed_airspeed_kts":269,"filed_airspeed_mach":"","filed_altitude":170,"route":"DCT AD V361 SEDAN V324 REN","actualdeparturetime":1432658520,"estimatedarrivaltime":1432660260,"actualarrivaltime":1432660260,"diverted":"","origin":"YPAD","destination":"YREN","originName":"Adelaide Int'l","originCity":"Adelaide, South Australia AU","destinationName":"Renmark","destinationCity":"Renmark, South Australia AU"},{"ident":"FD520","aircrafttype":"PC12","filed_ete":"00:19:00","filed_time":1432641249,"filed_departuretime":1432655400,"filed_airspeed_kts":269,"filed_airspeed_mach":"","filed_altitude":170,"route":"DCT YTBB DCT RIKAB N640 AD","actualdeparturetime":1432651860,"estimatedarrivaltime":1432653720,"actualarrivaltime":1432653707,"diverted":"","origin":"YTBB","destination":"YPAD","originName":"Tumby Bay","originCity":"Tumby Bay, South Australia AU","destinationName":"Adelaide Int'l","destinationCity":"Adelaide, South Australia AU"},{"ident":"FD520","aircrafttype":"PC12","filed_ete":"01:00:00","filed_time":1432641231,"filed_departuretime":1432642200,"filed_airspeed_kts":271,"filed_airspeed_mach":"","filed_altitude":180,"route":"DCT AD J15 YORKE DCT","actualdeparturetime":1432643760,"estimatedarrivaltime":1432646340,"actualarrivaltime":1432646186,"diverted":"","origin":"YPAD","destination":"YTBB","originName":"Adelaide Int'l","originCity":"Adelaide, South Australia AU","destinationName":"Tumby Bay","destinationCity":"Tumby Bay, South Australia AU"},{"ident":"FD523","aircrafttype":"PC12","filed_ete":"02:00:00","filed_time":1432622082,"filed_departuretime":1432629900,"filed_airspeed_kts":270,"filed_airspeed_mach":"","filed_altitude":220,"route":"DCT MTG V259 AD","actualdeparturetime":1432633680,"estimatedarrivaltime":1432637400,"actualarrivaltime":1432637400,"diverted":"","origin":"YMTG","destination":"YPAD","originName":"Mount Gambier","originCity":"Mount Gambier, South Australia AU","destinationName":"Adelaide Int'l","destinationCity":"Adelaide, South Australia AU"},{"ident":"FD523","aircrafttype":"PC12","filed_ete":"00:49:00","filed_time":1432622082,"filed_departuretime":1432622700,"filed_airspeed_kts":269,"filed_airspeed_mach":"","filed_altitude":230,"route":"DCT AD W519 MTG","actualdeparturetime":1432623283,"estimatedarrivaltime":1432626240,"actualarrivaltime":1432626240,"diverted":"","origin":"YPAD","destination":"YMTG","originName":"Adelaide Int'l","originCity":"Adelaide, South Australia AU","destinationName":"Mount Gambier","destinationCity":"Mount Gambier, South Australia AU"},{"ident":"FD523","aircrafttype":"PC12","filed_ete":"01:37:00","filed_time":1432606716,"filed_departuretime":1432611900,"filed_airspeed_kts":266,"filed_airspeed_mach":"","filed_altitude":150,"route":"DCT MARGO H84 AD","actualdeparturetime":1432616400,"estimatedarrivaltime":1432618140,"actualarrivaltime":1432618133,"diverted":"","origin":"YPIR","destination":"YPAD","originName":"Port Pirie","originCity":"Port Pirie, South Australia AU","destinationName":"Adelaide Int'l","destinationCity":"Adelaide, South Australia AU"},{"ident":"FD523","aircrafttype":"PC12","filed_ete":"00:42:00","filed_time":1432606716,"filed_departuretime":1432610100,"filed_airspeed_kts":242,"filed_airspeed_mach":"","filed_altitude":60,"route":"","actualdeparturetime":1432612260,"estimatedarrivaltime":1432612800,"actualarrivaltime":1432612800,"diverted":"","origin":"YBOC","destination":"YPIR","originName":"Booleroo Centre","originCity":"Booleroo Centre South Australia AU","destinationName":"Port Pirie","destinationCity":"Port Pirie, South Australia AU"},{"ident":"FD523","aircrafttype":"PC12","filed_ete":"00:57:00","filed_time":1432606716,"filed_departuretime":1432607400,"filed_airspeed_kts":271,"filed_airspeed_mach":"","filed_altitude":180,"route":"DCT AD","actualdeparturetime":1432609140,"estimatedarrivaltime":1432611300,"actualarrivaltime":1432611300,"diverted":"","origin":"YPAD","destination":"YBOC","originName":"Adelaide Int'l","originCity":"Adelaide, South Australia AU","destinationName":"Booleroo Centre","destinationCity":"Booleroo Centre South Australia AU"},{"ident":"FD512","aircrafttype":"PC12","filed_ete":"00:33:00","filed_time":1432522032,"filed_departuretime":1432530000,"filed_airspeed_kts":272,"filed_airspeed_mach":"","filed_altitude":200,"route":"DCT YKIG DCT RUVUS V259 AD","actualdeparturetime":1432529880,"estimatedarrivaltime":1432532340,"actualarrivaltime":1432532340,"diverted":"","origin":"YKIG","destination":"YPAD","originName":"Kingston","originCity":"Kingston, South Australia AU","destinationName":"Adelaide Int'l","destinationCity":"Adelaide, South Australia AU"},{"ident":"FD512","aircrafttype":"PC12","filed_ete":"00:33:00","filed_time":1432522032,"filed_departuretime":1432524600,"filed_airspeed_kts":272,"filed_airspeed_mach":"","filed_altitude":190,"route":"DCT AD W519 LRT DCT","actualdeparturetime":1432524863,"estimatedarrivaltime":1432526880,"actualarrivaltime":1432526880,"diverted":"","origin":"YPAD","destination":"YKIG","originName":"Adelaide Int'l","originCity":"Adelaide, South Australia AU","destinationName":"Kingston","destinationCity":"Kingston, South Australia AU"},{"ident":"FD536","aircrafttype":"PC12","filed_ete":"00:59:00","filed_time":1432278114,"filed_departuretime":1432292400,"filed_airspeed_kts":269,"filed_airspeed_mach":"","filed_altitude":170,"route":"DCT WHA H84 AD","actualdeparturetime":1432294080,"estimatedarrivaltime":1432296300,"actualarrivaltime":1432296300,"diverted":"","origin":"YWHA","destination":"YPAD","originName":"Whyalla","originCity":"Whyalla, South Australia AU","destinationName":"Adelaide Int'l","destinationCity":"Adelaide, South Australia AU"},{"ident":"FD536","aircrafttype":"PC12","filed_ete":"01:15:00","filed_time":1432278114,"filed_departuretime":1432285200,"filed_airspeed_kts":269,"filed_airspeed_mach":"","filed_altitude":170,"route":"DCT PLC DCT WHA","actualdeparturetime":1432287922,"estimatedarrivaltime":1432290120,"actualarrivaltime":1432290120,"diverted":"","origin":"YPLC","destination":"YWHA","originName":"Port Lincoln","originCity":"Port Lincoln, South Australia AU","destinationName":"Whyalla","destinationCity":"Whyalla, South Australia AU"}]}}
I'd like to split out each 'flight' element and index them individually. Ideally the timestamp of each event would just be the time the event was indexed.
Thanks a lot!
... View more
12-11-2014
09:47 PM
Ok, I put on my big boy pants and I've figured out a solution that seems to do the job - I'm noting it here for my own future reference but hopefully it might help someone else sometime:
search
| eval "Original Next Due"='Next Due'
| makemv delim="," "Next Due"
| mvexpand "Next Due"
| eval Next_Due_Date_DDMMYYY=strftime(strptime('Next Due', "%d/%m/%Y"), "%F")
| eval Next_Due_Date_ISO=strftime(strptime('Next Due', "%F"), "%F")
| eval Next_Due_Date=coalesce(Next_Due_Date_DDMMYYY,Next_Due_Date_ISO)
| rex field="Next Due" "(?\d+\.\d+) Hours"
| rex field="Next Due" "(?\d+\.\d+) Landings"
| sort Next_Due_Hours Next_Due_Landings Next_Due_Date
| table PN_SN Description "Original Next Due" Next_Due_Hours Next_Due_Landings Next_Due_Date
Where:
| eval "Original Next Due"='Next Due' -- Creates a new field with the original 'Next Due' value before I tamper with it
| makemv delim="," "Next Due" -- Converts the "," delimited "Next Due" field into a multi-value field
| mvexpand "Next Due" -- Expands the values of multi-value "Next Due" field into separate events for each value of the "Next Due" field
| eval Next_Due_Date_DDMMYYY=strftime(strptime('Next Due', "%d/%m/%Y"), "%F") -- Creates a temporary field looking for date values in the "Next Due" field with the format "%d/%m/%Y" and then converting this to ISO format "%F" (YYYY-MM-DD)
| eval Next_Due_Date_ISO=strftime(strptime('Next Due', "%F"), "%F") -- Creates a temporary field looking for date values in the "Next Due" field with ISO format "%F" (YYYY-MM-DD) and then converting this back to ISO format "%F" (YYYY-MM-DD)
| eval Next_Due_Date=coalesce(Next_Due_Date_DDMMYYY,Next_Due_Date_ISO) -- creates a new field 'Next_Due_Date' which takes the value of the first non-NULL field out of the two temporary fields "Next_Due_Date_DDMMYYY" and "Next_Due_Date_ISO"
| rex field="Next Due" "(?\d+.\d+) Hours" -- extracts a decimal number preceeding the word 'Hours'
| rex field="Next Due" "(?\d+.\d+) Landings" - extracts a decimal number preceeding the word 'Landings'
This then returns:
PN_SN Description Original Next Due Next_Due_Hours Next_Due_Landings Next_Due_Date
PN: AV6479-004D0201/2 SN: PC-006 EMS Stretcher Loader. 4839.40 Hours 4839.40
N/A Airframe - Progressive Mini Inspection. 4839.40 Hours 4839.40
N/A CARRY OUT ENGINE - 100 HOUR & MINOR ITEMS IAW PWC M/M TABLE 601 4844.70 Hours 4844.70
N/A MAINTENANCE RELEASE INSPECTION 2015-04-22, 4844.70 Hours 4844.70
N/A CARRY OUT VISUAL INSPECTION OF MOTOROLA XTL5000 WHIP ANTENNA 4844.70 Hours 4844.70
N/A CONTINUED AIRWORTHINESS- AFT FACING SEAT PROTECTION PLATE 4844.70 Hours 4844.70
N/A Perform EO14907.014/1 Issue 2. FUEL DRAIN CUP INSPECTION 4844.70 Hours 4844.70
N/A Oxygen Mask Stowage - Installation inspection 4844.70 Hours 4844.70
PN: 3037313 SN: YUAA005A562 Inspection Engine Power Turbine Blades. 4844.70 Hours 4844.70
PN: PT6A-67P SN: PCE-RY0238 EXAMINE , FIRST STAGE COMPRESSOR 4844.70 Hours 4844.70
N/A Airframe - 6 Phase Progressive Inspection. 4844.70 Hours 4844.70
N/A 5R EO 5R-1869-EO1 NAV LIGHTS ALT POWER SOURCE CONT AIRWORTHINESS INSP 2015-02-18, 4887.50 Hours 4887.50
PN: PT6A-67P SN: PCE-RY0238 Replace Oil Filter Element. 4887.50 Hours 4887.50
PN: PT6A-67P SN: PCE-RY0238 Replace Engine P3 Filter. 4887.50 Hours 4887.50
N/A 27-50/437:INBOARD FLAP DRIVE ARMS INSITU INSP/CHECK 2015-11-12, 4889.40 Hours 4889.40
N/A Fuel cross vent and outward check valve. 4898.30 Hours 4898.30
PN: 26130-2 SN: 9959525078 Overhaul Flow Divider. 4909.70 Hours 4909.70
N/A PERFORM SACRIFICIAL SEAT TRACK CONT AIRWORTHINESS INSP 4944.70 Hours 4944.70
PN: PT6A-67P SN: PCE-RY0238 AD/ENG/5 AMDT 9 - Turbine Engine Continuing Airworthiness Requirements. 5000.00 Hours 5000.00
PN: 968.32.14.102 SN: 1134 Overhaul Oil Cooler. 5000.00 Hours 5000.00
PN: 3059835-01 SN: AHX016123 Overhaul Compressor Bleed Valve. 5000.00 Hours 5000.00
PN: 10-381550-4 SN: NNA10080009 Overhaul Ignition Exciter. 5000.00 Hours 5000.00
PN: 825601-5 SN: 010282 Overhaul Engine Driven (HP) Fuel Pump. 5000.00 Hours 5000.00
PN: 10585K SN: WA39256 Overhaul Oil-to-Fuel Heater. 5000.00 Hours 5000.00
PN: 3056693-01 SN: HWDD2125-HWDH0765 Discard Power Turbine 2nd Stage Blades. 5000.00 Hours 5000.00
PN: 3037313 SN: YUAA005A562 Discard Power Turbine 2nd Stage Blades. 5000.00 Hours 5000.00
PN: 3072956 SN: PS-RY0238 Overhaul Power Section Module. 5000.00 Hours 5000.00
PN: 3072959 SN: PCE-RY0238 Overhaul Gas Generator Module. 5000.00 Hours 5000.00
PN: PT6A-67P SN: PCE-RY0238 Overhaul Engine. 5000.00 Hours 5000.00
PN: 944.81.21.409 SN: 5432 Replace Engine Shock Mount. 5000.00 Hours 5000.00
PN: 944.81.21.409 SN: 5162 Replace Engine Shock Mount. 5000.00 Hours 5000.00
PN: 944.81.21.409 SN: 5147 Replace Engine Shock Mount. 5000.00 Hours 5000.00
PN: 944.81.21.409 SN: 5146 Replace Engine Shock Mount. 5000.00 Hours 5000.00
PN: 944.81.21.409 SN: 5135 Replace Engine Shock Mount. 5000.00 Hours 5000.00
PN: 3244882-2 SN: C51108 Overhaul Over Torque Limiter. 5000.00 Hours 5000.00
PN: 210949 SN: 16890761 Overhaul Overspeed Governor. 5000.00 Hours 5000.00
PN: 8210-137E SN: 16910258 Overhaul Propeller Governor. 5000.00 Hours 5000.00
PN: 978.73.20.309 SN: 3900 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings 5000.00
PN: 978.73.20.309 SN: 3891 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings 5000.00
PN: 978.73.20.309 SN: 3874 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings 5000.00
PN: 978.73.20.309 SN: 3873 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings 5000.00
N/A SMOKE GOGGLES 200 HR CONT AIRWORTHINESS REQUIREMENTS INSPECTION 5043.60 Hours 5043.60
PN: RG-380E/44 SN: 40605586 CONCORDE BATTERY CAPACITY TEST (PC12-47E = 24-30/340; PC12-45/47 = 24-30/69 2015-07-22, 5322.90 Hours 5322.90
PN: RG-380E/44LS SN: 40649547 CONCORDE BATTERY CAPACITY TEST (PC12-47E = 24-30/340; PC12-45/47 = 24-30/69 2015-09-15, 5466.30 Hours 5466.30
N/A PHASE 6 RESET 2015-09-15, 5660.30 Hours 5660.30
PN: 532.10.12.054 SN: VLG453 Main landing gear axles and bushes. 2015-09-02, 6460.30 Hours 6460.30
PN: 532.10.12.053 SN: VLG453 Main landing gear axles and bushes. 2015-09-01, 6460.30 Hours 6460.30
N/A Horizontal runaway trim aural warning check 2015-01-23, 6815.20 Hours 6815.20
N/A Pressurization Dump switch. 2015-05-02, 7085.90 Hours 7085.90
N/A Generator Control Unit (GCU) 1 and GCU 2. 2015-09-02, 7460.30 Hours 7460.30
N/A ECS emergency shut-off system. 2015-09-03, 7460.30 Hours 7460.30
PN: 978.73.20.309 SN: 3900 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings 7000.00
PN: 978.73.20.309 SN: 3891 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings 7000.00
PN: 978.73.20.309 SN: 3874 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings 7000.00
PN: 978.73.20.309 SN: 3873 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings 7000.00
N/A UPDATE HONEYWELL DATA BASE (GREEN) 19/07/2014 2014-07-19
PN: PT6A-67P SN: PCE-RY0238 AD/PT6A/28 Req 2 (Compressor & Compressor Turbine Desalination wash -coast) 3/12/2014 2014-12-03
N/A UPDATE HONEYWELL DATA BASE (PURPLE) 3/12/2014 2014-12-03
N/A UPDATE HONEYWELL DATA BASE (BLUE) 3/12/2014 2014-12-03
N/A Horizontal runaway trim aural warning check 2015-01-23, 6815.20 Hours 2015-01-23
N/A SB 52-008: INTRODUCTION OF A NEW CARGO DOOR HANDLE SWITCH 29/01/2015 2015-01-29
N/A 5R EO 5R-1869-EO1 NAV LIGHTS ALT POWER SOURCE CONT AIRWORTHINESS INSP 2015-02-18, 4887.50 Hours 2015-02-18
PN: 25-01 SN: 16 REPLACE DUE SERVICE LIFE 1/03/2015 2015-03-01
N/A OPS 54 IFR Radio Inspection 10/03/2015 2015-03-10
N/A AD/GEN/37 AMDT 9 - Emergency Exits. 12/03/2015 2015-03-12
N/A MAINTENANCE RELEASE INSPECTION 2015-04-22, 4844.70 Hours 2015-04-22
N/A Perform EO14907.008/1 Issue 2. LIFE JACKET INSTALL CONT A/WORTHINESS REQ 29/04/2015 2015-04-29
N/A PROPAQ INSTALLATION CONTINUED AIRWORTHINESS INSPECTION REQUIREMENTS 1/05/2015 2015-05-01
N/A Perform EO14907.029/1 Issue 6. MEDICAL EQUIPMENT SUPPORTS ANNUAL INSP 1/05/2015 2015-05-01
N/A EO14907.028/1 Issue 5 Medical Equip Rails annual inspection 1/05/2015 2015-05-01
N/A EO14907.015/1 Issue 3. MEDICAL CABINET INSTALL CONT AIRWORTHINESS 1/05/2015 2015-05-01
N/A 14907.049/1 issue 3: SA Baggage Bay Annual Inspection 2/05/2015 2015-05-02
N/A Perform EO14907.023/1 Issue 4. AEA Stretcher Loader Installation Inspect 2/05/2015 2015-05-02
N/A EO14907.022/1 Issue 2. Ferno 2650 Stretcher System installation Insp 2/05/2015 2015-05-02
N/A Pressurization Dump switch. 2015-05-02, 7085.90 Hours 2015-05-02
N/A Airframe - Corrosion Protection Compound Inspection - External Areas. 13/05/2015 2015-05-13
N/A EO14907.216/1 Issue 4 Mansell NeoNatal Unit Inst. CONT AIRWORTHINESS REQ 24/05/2015 2015-05-24
PN: MT410G SN: 80454243 EPIRP LIFE LIMIT 30/05/2015 2015-05-30
PN: MT410G SN: 80454243 CARRY OUT EPIRP MT410G INSPECTION IAW MANUFACTURER'S INSTRUCTIONS 19/06/2015 2015-06-19
PN: RG-380E/44 SN: 40605586 CONCORDE BATTERY CAPACITY TEST (PC12-47E = 24-30/340; PC12-45/47 = 24-30/69 2015-07-22, 5322.90 Hours 2015-07-22
N/A PIL-SB-71-008: REPLACEMENT OF PLENUM SCREEN ASSEMBLY 23/07/2015 2015-07-23
N/A Duct over temperature switch. 2/08/2015 2015-08-02
N/A Overtemperature switch. 2/08/2015 2015-08-02
PN: 25-01 SN: 16 REPLACE DUE SERVICE LIFE 10/08/2015 2015-08-10
PN: 25-01 SN: 16 REPLACE DUE SERVICE LIFE 30/08/2015 2015-08-30
PN: 532.10.12.053 SN: VLG453 Main landing gear axles and bushes. 2015-09-01, 6460.30 Hours 2015-09-01
PN: 532.10.12.054 SN: VLG453 Main landing gear axles and bushes. 2015-09-02, 6460.30 Hours 2015-09-02
N/A EMS Lighting System. 2/09/2015 2015-09-02
N/A Carry out Bucher EMS Electrical Inspection test 2/09/2015 2015-09-02
N/A Generator Control Unit (GCU) 1 and GCU 2. 2015-09-02, 7460.30 Hours 2015-09-02
N/A Bucher EMS Oxygen Wall Outlets. 3/09/2015 2015-09-03
N/A ECS emergency shut-off system. 2015-09-03, 7460.30 Hours 2015-09-03
N/A EMS Suction System. 9/09/2015 2015-09-09
PN: 959.90.22.102 SN: 1119 CARRY OUT VCCS SYSTEM ANNUAL INSPECTION 9/09/2015 2015-09-09
PN: 3-1501 SN: 0037 LUBRICATE WHEEL BEARINGS 11/09/2015 2015-09-11
N/A Bucher EMS Wall Panels. 11/09/2015 2015-09-11
N/A Bucher EMS Overhead Track Inspection 11/09/2015 2015-09-11
N/A Bucher EMS Oxygen System Pipelines. 11/09/2015 2015-09-11
N/A Airframe - Corrosion Protection Compound Inspection - Internal Areas. 11/09/2015 2015-09-11
PN: RG-380E/44LS SN: 40649547 CONCORDE BATTERY CAPACITY TEST (PC12-47E = 24-30/340; PC12-45/47 = 24-30/69 2015-09-15, 5466.30 Hours 2015-09-15
...
If you've got a better idea let me know!
... View more
12-10-2014
10:30 PM
Hi,
I've got a bunch of TSV files that I'd like to pull into Splunk that lists when certain aircraft components are due for maintenance. I've created a tsv sourcetype for the purpose.
These aircraft components become due for maintenance based on either:
a date
the number of hours the aircraft has flown
the number of landings the aircraft has completed
a combination of the above
One of the columns in the TSV (which is now mapped to a field - 'Next Due') contains all of the above. Here is an example:
Task_Check PN_SN Description Next Due
SURVIVAL-WATER PN: 25-01 SN: 16 REPLACE DUE SERVICE LIFE 30/08/2015
SURVIVAL-RATION PACK PN: 25-01 SN: 16 REPLACE DUE SERVICE LIFE 10/08/2015
SURVIVAL-LIP BALM PN: 25-01 SN: 16 REPLACE DUE SERVICE LIFE 1/03/2015
SURVIVAL-EPIRP MT410G PN: MT410G SN: 80454243 CARRY OUT EPIRP MT410G INSPECTION IAW MANUFACTURER'S INSTRUCTIONS 19/06/2015
PIL-SB-71-008 REV 0 N/A PIL-SB-71-008: REPLACEMENT OF PLENUM SCREEN ASSEMBLY 23/07/2015
PIL-SB-52-008 REV 0 N/A SB 52-008: INTRODUCTION OF A NEW CARGO DOOR HANDLE SWITCH 29/01/2015
PHASE ENGINE INSP N/A CARRY OUT ENGINE - 100 HOUR & MINOR ITEMS IAW PWC M/M TABLE 601 4844.70 Hours
MT410G REPLACEMENT PN: MT410G SN: 80454243 EPIRP LIFE LIMIT 30/05/2015
MAINTENANCE RELEASE INSP N/A MAINTENANCE RELEASE INSPECTION 2015-04-22, 4844.70 Hours
AD/PT6A/28 req 2 (7 DAY) PN: PT6A-67P SN: PCE-RY0238 AD/PT6A/28 Req 2 (Compressor & Compressor Turbine Desalination wash -coast) 3/12/2014
AD/GEN/37R9 N/A AD/GEN/37 AMDT 9 - Emergency Exits. 12/03/2015
AD/ENG/5R9 PN: PT6A-67P SN: PCE-RY0238 AD/ENG/5 AMDT 9 - Turbine Engine Continuing Airworthiness Requirements. 5000.00 Hours
99-5r-1869-eo1 NAV LIGHTS N/A 5R EO 5R-1869-EO1 NAV LIGHTS ALT POWER SOURCE CONT AIRWORTHINESS INSP 2015-02-18, 4887.50 Hours
99-16576.001/1-200 N/A SMOKE GOGGLES 200 HR CONT AIRWORTHINESS REQUIREMENTS INSPECTION 5043.60 Hours
99-16375.001/2 N/A CARRY OUT VISUAL INSPECTION OF MOTOROLA XTL5000 WHIP ANTENNA 4844.70 Hours
99-14907.216/1 N/A EO14907.216/1 Issue 4 Mansell NeoNatal Unit Inst. CONT AIRWORTHINESS REQ 24/05/2015
99-14907.206/1 N/A PROPAQ INSTALLATION CONTINUED AIRWORTHINESS INSPECTION REQUIREMENTS 1/05/2015
99-14907.049/1 N/A 14907.049/1 issue 3: SA Baggage Bay Annual Inspection 2/05/2015
99-14907.033/1 N/A CONTINUED AIRWORTHINESS- AFT FACING SEAT PROTECTION PLATE 4844.70 Hours
99-14907.032/1 N/A PERFORM SACRIFICIAL SEAT TRACK CONT AIRWORTHINESS INSP 4944.70 Hours
99-14907.029/1 N/A Perform EO14907.029/1 Issue 6. MEDICAL EQUIPMENT SUPPORTS ANNUAL INSP 1/05/2015
99-14907.028/1 N/A EO14907.028/1 Issue 5 Medical Equip Rails annual inspection 1/05/2015
99-14907.023/1 N/A Perform EO14907.023/1 Issue 4. AEA Stretcher Loader Installation Inspect 2/05/2015
99-14907.022/1 N/A EO14907.022/1 Issue 2. Ferno 2650 Stretcher System installation Insp 2/05/2015
99-14907.015/1 N/A EO14907.015/1 Issue 3. MEDICAL CABINET INSTALL CONT AIRWORTHINESS 1/05/2015
99-14907.014/1 N/A Perform EO14907.014/1 Issue 2. FUEL DRAIN CUP INSPECTION 4844.70 Hours
99-14907.008/1 N/A Perform EO14907.008/1 Issue 2. LIFE JACKET INSTALL CONT A/WORTHINESS REQ 29/04/2015
99-14907.002/1 N/A Oxygen Mask Stowage - Installation inspection 4844.70 Hours
7920-012B PN: PT6A-67P SN: PCE-RY0238 Replace Oil Filter Element. 4887.50 Hours
79-20/43 PN: 968.32.14.102 SN: 1134 Overhaul Oil Cooler. 5000.00 Hours
7530-100 (O) PN: 3059835-01 SN: AHX016123 Overhaul Compressor Bleed Valve. 5000.00 Hours
7410-100 (O) PN: 10-381550-4 SN: NNA10080009 Overhaul Ignition Exciter. 5000.00 Hours
7310-300 (O) PN: 26130-2 SN: 9959525078 Overhaul Flow Divider. 4909.70 Hours
7310-200 (O-02) PN: 825601-5 SN: 010282 Overhaul Engine Driven (HP) Fuel Pump. 5000.00 Hours
7310-100 (O) PN: 10585K SN: WA39256 Overhaul Oil-to-Fuel Heater. 5000.00 Hours
7310-022 PN: PT6A-67P SN: PCE-RY0238 Replace Engine P3 Filter. 4887.50 Hours
7250-250 (D) PN: 3056693-01 SN: HWDD2125-HWDH0765 Discard Power Turbine 2nd Stage Blades. 5000.00 Hours
7250-250 (D) PN: 3037313 SN: YUAA005A562 Discard Power Turbine 2nd Stage Blades. 5000.00 Hours
7250-000 (O) PN: 3072956 SN: PS-RY0238 Overhaul Power Section Module. 5000.00 Hours
7230-000 (O) PN: 3072959 SN: PCE-RY0238 Overhaul Gas Generator Module. 5000.00 Hours
72-06 PN: 3037313 SN: YUAA005A562 Inspection Engine Power Turbine Blades. 4844.70 Hours
72-05 PN: PT6A-67P SN: PCE-RY0238 EXAMINE , FIRST STAGE COMPRESSOR 4844.70 Hours
7200-000 (O) PN: PT6A-67P SN: PCE-RY0238 Overhaul Engine. 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5432 Replace Engine Shock Mount. 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5162 Replace Engine Shock Mount. 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5147 Replace Engine Shock Mount. 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5146 Replace Engine Shock Mount. 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5135 Replace Engine Shock Mount. 5000.00 Hours
6120-300 (O) PN: 3244882-2 SN: C51108 Overhaul Over Torque Limiter. 5000.00 Hours
6120-200 (O) PN: 210949 SN: 16890761 Overhaul Overspeed Governor. 5000.00 Hours
6120-100 (O) PN: 8210-137E SN: 16910258 Overhaul Propeller Governor. 5000.00 Hours
34-08 N/A UPDATE HONEYWELL DATA BASE (PURPLE) 3/12/2014
34-07 N/A UPDATE HONEYWELL DATA BASE (GREEN) 19/07/2014
34-06 N/A UPDATE HONEYWELL DATA BASE (BLUE) 3/12/2014
32-10/315 PN: 532.10.12.054 SN: VLG453 Main landing gear axles and bushes. 2015-09-02, 6460.30 Hours
32-10/315 PN: 532.10.12.053 SN: VLG453 Main landing gear axles and bushes. 2015-09-01, 6460.30 Hours
32-01 PN: 3-1501 SN: 0037 LUBRICATE WHEEL BEARINGS 11/09/2015
28-10/306 N/A Fuel cross vent and outward check valve. 4898.30 Hours
27-50/437 N/A 27-50/437:INBOARD FLAP DRIVE ARMS INSITU INSP/CHECK 2015-11-12, 4889.40 Hours
27-50/30 PN: 978.73.20.309 SN: 3900 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings
27-50/30 PN: 978.73.20.309 SN: 3891 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings
27-50/30 PN: 978.73.20.309 SN: 3874 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings
27-50/30 PN: 978.73.20.309 SN: 3873 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings
27-40/1 N/A Horizontal runaway trim aural warning check 2015-01-23, 6815.20 Hours
25/06/2005 N/A Bucher EMS Wall Panels. 11/09/2015
25/06/2004 N/A Bucher EMS Overhead Track Inspection 11/09/2015
25-06-03B N/A EMS Lighting System. 2/09/2015
25/06/2003 N/A Carry out Bucher EMS Electrical Inspection test 2/09/2015
25-06-02B N/A EMS Suction System. 9/09/2015
25/06/2002 N/A Bucher EMS Oxygen Wall Outlets. 3/09/2015
25/06/2001 N/A Bucher EMS Oxygen System Pipelines. 11/09/2015
2500-302 PN: AV6479-004D0201/2 SN: PC-006 EMS Stretcher Loader. 4839.40 Hours
2431-012C PN: RG-380E/44LS SN: 40649547 CONCORDE BATTERY CAPACITY TEST (PC12-47E = 24-30/340; PC12-45/47 = 24-30/69 2015-09-15, 5466.30 Hours
2431-012C PN: RG-380E/44 SN: 40605586 CONCORDE BATTERY CAPACITY TEST (PC12-47E = 24-30/340; PC12-45/47 = 24-30/69 2015-07-22, 5322.90 Hours
24-30/311 N/A Generator Control Unit (GCU) 1 and GCU 2. 2015-09-02, 7460.30 Hours
21-40/52 N/A Duct over temperature switch. 2/08/2015
21-40/51 N/A Overtemperature switch. 2/08/2015
21-30/318 N/A Pressurization Dump switch. 2015-05-02, 7085.90 Hours
21-20/317 N/A ECS emergency shut-off system. 2015-09-03, 7460.30 Hours
21-17 PN: 959.90.22.102 SN: 1119 CARRY OUT VCCS SYSTEM ANNUAL INSPECTION 9/09/2015
5-Mar N/A OPS 54 IFR Radio Inspection 10/03/2015
0500-550 PHASE 6 RESET N/A PHASE 6 RESET 2015-09-15, 5660.30 Hours
0500-550 [2] N/A Airframe - 6 Phase Progressive Inspection. 4844.70 Hours
0500-500 N/A Airframe - Progressive Mini Inspection. 4839.40 Hours
00-00/45 (INTERNAL) N/A Airframe - Corrosion Protection Compound Inspection - Internal Areas. 11/09/2015
00-00/45 (EXT) MODERATE N/A Airframe - Corrosion Protection Compound Inspection - External Areas. 13/05/2015
I'd like to split the 'Next Due' field and map it based on the contents of it to one or two new fields - Next_Due_Date, Next_Due_Hours, Next_Due_Landings
I've used evals to split those events that contain two options and a field extraction so far:
search
| eval Next_Due_Date_Only=strftime(strptime('Next Due', "%d/%m/%Y"), "%F")
| eval Next_Due_Split=split('Next Due',",")
| eval Next_Due_1=mvindex(Next_Due_Split,0)
| eval Next_Due_2=mvindex(Next_Due_Split,-1)
| eval Next_Due_1_Date=strftime(strptime(Next_Due_1, "%d/%m/%Y"), "%F")
| table host PN_SN Description "Next Due" Next_Due_Split Next_Due_1 Next_Due_2 Next_Due_Date_Only Next_Due_Date_and_Hours_Hours Next_Due_1_Date
Extraction:
^(?:[^,\n]*,){5}\s+(?P[^ ]+)
Which produces:
Task_Check PN_SN Description Next Due Next_Due_Split Next_Due_1 Next_Due_2 Next_Due_Date_Only Next_Due_Date_and_Hours_Hours Next_Due_1_Date
SURVIVAL-WATER PN: 25-01 SN: 16 REPLACE DUE SERVICE LIFE 30/08/2015 30/08/2015 30/08/2015 30/08/2015 30/08/2015 30/08/2015
SURVIVAL-RATION PACK PN: 25-01 SN: 16 REPLACE DUE SERVICE LIFE 10/08/2015 10/08/2015 10/08/2015 10/08/2015 10/08/2015 10/08/2015
SURVIVAL-LIP BALM PN: 25-01 SN: 16 REPLACE DUE SERVICE LIFE 1/03/2015 1/03/2015 1/03/2015 1/03/2015 1/03/2015 1/03/2015
SURVIVAL-EPIRP MT410G PN: MT410G SN: 80454243 CARRY OUT EPIRP MT410G INSPECTION IAW MANUFACTURER'S INSTRUCTIONS 19/06/2015 19/06/2015 19/06/2015 19/06/2015 19/06/2015 19/06/2015
PIL-SB-71-008 REV 0 N/A PIL-SB-71-008: REPLACEMENT OF PLENUM SCREEN ASSEMBLY 23/07/2015 23/07/2015 23/07/2015 23/07/2015 23/07/2015 23/07/2015
PIL-SB-52-008 REV 0 N/A SB 52-008: INTRODUCTION OF A NEW CARGO DOOR HANDLE SWITCH 29/01/2015 29/01/2015 29/01/2015 29/01/2015 29/01/2015 29/01/2015
PHASE ENGINE INSP N/A CARRY OUT ENGINE - 100 HOUR & MINOR ITEMS IAW PWC M/M TABLE 601 4844.70 Hours 4844.70 Hours 4844.70 Hours 4844.70 Hours
MT410G REPLACEMENT PN: MT410G SN: 80454243 EPIRP LIFE LIMIT 30/05/2015 30/05/2015 30/05/2015 30/05/2015 30/05/2015 30/05/2015
MAINTENANCE RELEASE INSP N/A MAINTENANCE RELEASE INSPECTION 2015-04-22, 4844.70 Hours "2015-04-22
4844.70 Hours" 22/04/2015 4844.70 Hours 4844.7
AD/PT6A/28 req 2 (7 DAY) PN: PT6A-67P SN: PCE-RY0238 AD/PT6A/28 Req 2 (Compressor & Compressor Turbine Desalination wash -coast) 3/12/2014 3/12/2014 3/12/2014 3/12/2014 3/12/2014 3/12/2014
AD/GEN/37R9 N/A AD/GEN/37 AMDT 9 - Emergency Exits. 12/03/2015 12/03/2015 12/03/2015 12/03/2015 12/03/2015 12/03/2015
AD/ENG/5R9 PN: PT6A-67P SN: PCE-RY0238 AD/ENG/5 AMDT 9 - Turbine Engine Continuing Airworthiness Requirements. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
99-5r-1869-eo1 NAV LIGHTS N/A 5R EO 5R-1869-EO1 NAV LIGHTS ALT POWER SOURCE CONT AIRWORTHINESS INSP 2015-02-18, 4887.50 Hours "2015-02-18
4887.50 Hours" 18/02/2015 4887.50 Hours 4887.5
99-16576.001/1-200 N/A SMOKE GOGGLES 200 HR CONT AIRWORTHINESS REQUIREMENTS INSPECTION 5043.60 Hours 5043.60 Hours 5043.60 Hours 5043.60 Hours
99-16375.001/2 N/A CARRY OUT VISUAL INSPECTION OF MOTOROLA XTL5000 WHIP ANTENNA 4844.70 Hours 4844.70 Hours 4844.70 Hours 4844.70 Hours
99-14907.216/1 N/A EO14907.216/1 Issue 4 Mansell NeoNatal Unit Inst. CONT AIRWORTHINESS REQ 24/05/2015 24/05/2015 24/05/2015 24/05/2015 24/05/2015 24/05/2015
99-14907.206/1 N/A PROPAQ INSTALLATION CONTINUED AIRWORTHINESS INSPECTION REQUIREMENTS 1/05/2015 1/05/2015 1/05/2015 1/05/2015 1/05/2015 1/05/2015
99-14907.049/1 N/A 14907.049/1 issue 3: SA Baggage Bay Annual Inspection 2/05/2015 2/05/2015 2/05/2015 2/05/2015 2/05/2015 2/05/2015
99-14907.033/1 N/A CONTINUED AIRWORTHINESS- AFT FACING SEAT PROTECTION PLATE 4844.70 Hours 4844.70 Hours 4844.70 Hours 4844.70 Hours
99-14907.032/1 N/A PERFORM SACRIFICIAL SEAT TRACK CONT AIRWORTHINESS INSP 4944.70 Hours 4944.70 Hours 4944.70 Hours 4944.70 Hours
99-14907.029/1 N/A Perform EO14907.029/1 Issue 6. MEDICAL EQUIPMENT SUPPORTS ANNUAL INSP 1/05/2015 1/05/2015 1/05/2015 1/05/2015 1/05/2015 1/05/2015
99-14907.028/1 N/A EO14907.028/1 Issue 5 Medical Equip Rails annual inspection 1/05/2015 1/05/2015 1/05/2015 1/05/2015 1/05/2015 1/05/2015
99-14907.023/1 N/A Perform EO14907.023/1 Issue 4. AEA Stretcher Loader Installation Inspect 2/05/2015 2/05/2015 2/05/2015 2/05/2015 2/05/2015 2/05/2015
99-14907.022/1 N/A EO14907.022/1 Issue 2. Ferno 2650 Stretcher System installation Insp 2/05/2015 2/05/2015 2/05/2015 2/05/2015 2/05/2015 2/05/2015
99-14907.015/1 N/A EO14907.015/1 Issue 3. MEDICAL CABINET INSTALL CONT AIRWORTHINESS 1/05/2015 1/05/2015 1/05/2015 1/05/2015 1/05/2015 1/05/2015
99-14907.014/1 N/A Perform EO14907.014/1 Issue 2. FUEL DRAIN CUP INSPECTION 4844.70 Hours 4844.70 Hours 4844.70 Hours 4844.70 Hours
99-14907.008/1 N/A Perform EO14907.008/1 Issue 2. LIFE JACKET INSTALL CONT A/WORTHINESS REQ 29/04/2015 29/04/2015 29/04/2015 29/04/2015 29/04/2015 29/04/2015
99-14907.002/1 N/A Oxygen Mask Stowage - Installation inspection 4844.70 Hours 4844.70 Hours 4844.70 Hours 4844.70 Hours
7920-012B PN: PT6A-67P SN: PCE-RY0238 Replace Oil Filter Element. 4887.50 Hours 4887.50 Hours 4887.50 Hours 4887.50 Hours
79-20/43 PN: 968.32.14.102 SN: 1134 Overhaul Oil Cooler. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
7530-100 (O) PN: 3059835-01 SN: AHX016123 Overhaul Compressor Bleed Valve. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
7410-100 (O) PN: 10-381550-4 SN: NNA10080009 Overhaul Ignition Exciter. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
7310-300 (O) PN: 26130-2 SN: 9959525078 Overhaul Flow Divider. 4909.70 Hours 4909.70 Hours 4909.70 Hours 4909.70 Hours
7310-200 (O-02) PN: 825601-5 SN: 010282 Overhaul Engine Driven (HP) Fuel Pump. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
7310-100 (O) PN: 10585K SN: WA39256 Overhaul Oil-to-Fuel Heater. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
7310-022 PN: PT6A-67P SN: PCE-RY0238 Replace Engine P3 Filter. 4887.50 Hours 4887.50 Hours 4887.50 Hours 4887.50 Hours
7250-250 (D) PN: 3056693-01 SN: HWDD2125-HWDH0765 Discard Power Turbine 2nd Stage Blades. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
7250-250 (D) PN: 3037313 SN: YUAA005A562 Discard Power Turbine 2nd Stage Blades. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
7250-000 (O) PN: 3072956 SN: PS-RY0238 Overhaul Power Section Module. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
7230-000 (O) PN: 3072959 SN: PCE-RY0238 Overhaul Gas Generator Module. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
72-06 PN: 3037313 SN: YUAA005A562 Inspection Engine Power Turbine Blades. 4844.70 Hours 4844.70 Hours 4844.70 Hours 4844.70 Hours
72-05 PN: PT6A-67P SN: PCE-RY0238 EXAMINE , FIRST STAGE COMPRESSOR 4844.70 Hours 4844.70 Hours 4844.70 Hours 4844.70 Hours
7200-000 (O) PN: PT6A-67P SN: PCE-RY0238 Overhaul Engine. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5432 Replace Engine Shock Mount. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5162 Replace Engine Shock Mount. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5147 Replace Engine Shock Mount. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5146 Replace Engine Shock Mount. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
71-00/38 PN: 944.81.21.409 SN: 5135 Replace Engine Shock Mount. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
6120-300 (O) PN: 3244882-2 SN: C51108 Overhaul Over Torque Limiter. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
6120-200 (O) PN: 210949 SN: 16890761 Overhaul Overspeed Governor. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
6120-100 (O) PN: 8210-137E SN: 16910258 Overhaul Propeller Governor. 5000.00 Hours 5000.00 Hours 5000.00 Hours 5000.00 Hours
34-08 N/A UPDATE HONEYWELL DATA BASE (PURPLE) 3/12/2014 3/12/2014 3/12/2014 3/12/2014 3/12/2014 3/12/2014
34-07 N/A UPDATE HONEYWELL DATA BASE (GREEN) 19/07/2014 19/07/2014 19/07/2014 19/07/2014 19/07/2014 19/07/2014
34-06 N/A UPDATE HONEYWELL DATA BASE (BLUE) 3/12/2014 3/12/2014 3/12/2014 3/12/2014 3/12/2014 3/12/2014
32-10/315 PN: 532.10.12.054 SN: VLG453 Main landing gear axles and bushes. 2015-09-02, 6460.30 Hours "2015-09-02
6460.30 Hours" 2/09/2015 6460.30 Hours 6460.3
32-10/315 PN: 532.10.12.053 SN: VLG453 Main landing gear axles and bushes. 2015-09-01, 6460.30 Hours "2015-09-01
6460.30 Hours" 1/09/2015 6460.30 Hours 6460.3
32-01 PN: 3-1501 SN: 0037 LUBRICATE WHEEL BEARINGS 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015
28-10/306 N/A Fuel cross vent and outward check valve. 4898.30 Hours 4898.30 Hours 4898.30 Hours 4898.30 Hours
27-50/437 N/A 27-50/437:INBOARD FLAP DRIVE ARMS INSITU INSP/CHECK 2015-11-12, 4889.40 Hours "2015-11-12
4889.40 Hours" 12/11/2015 4889.40 Hours 4889.4
27-50/30 PN: 978.73.20.309 SN: 3900 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings "5000.00 Hours
7000.00 Landings" 5000.00 Hours 7000.00 Landings 7000
27-50/30 PN: 978.73.20.309 SN: 3891 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings "5000.00 Hours
7000.00 Landings" 5000.00 Hours 7000.00 Landings 7000
27-50/30 PN: 978.73.20.309 SN: 3874 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings "5000.00 Hours
7000.00 Landings" 5000.00 Hours 7000.00 Landings 7000
27-50/30 PN: 978.73.20.309 SN: 3873 Overhaul Flap Actuator. 5000.00 Hours, 7000.00 Landings "5000.00 Hours
7000.00 Landings" 5000.00 Hours 7000.00 Landings 7000
27-40/1 N/A Horizontal runaway trim aural warning check 2015-01-23, 6815.20 Hours "2015-01-23
6815.20 Hours" 23/01/2015 6815.20 Hours 6815.2
25/06/2005 N/A Bucher EMS Wall Panels. 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015
25/06/2004 N/A Bucher EMS Overhead Track Inspection 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015
25-06-03B N/A EMS Lighting System. 2/09/2015 2/09/2015 2/09/2015 2/09/2015 2/09/2015 2/09/2015
25/06/2003 N/A Carry out Bucher EMS Electrical Inspection test 2/09/2015 2/09/2015 2/09/2015 2/09/2015 2/09/2015 2/09/2015
25-06-02B N/A EMS Suction System. 9/09/2015 9/09/2015 9/09/2015 9/09/2015 9/09/2015 9/09/2015
25/06/2002 N/A Bucher EMS Oxygen Wall Outlets. 3/09/2015 3/09/2015 3/09/2015 3/09/2015 3/09/2015 3/09/2015
25/06/2001 N/A Bucher EMS Oxygen System Pipelines. 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015
2500-302 PN: AV6479-004D0201/2 SN: PC-006 EMS Stretcher Loader. 4839.40 Hours 4839.40 Hours 4839.40 Hours 4839.40 Hours
2431-012C PN: RG-380E/44LS SN: 40649547 CONCORDE BATTERY CAPACITY TEST (PC12-47E = 24-30/340; PC12-45/47 = 24-30/69 2015-09-15, 5466.30 Hours "2015-09-15
5466.30 Hours" 15/09/2015 5466.30 Hours 5466.3
2431-012C PN: RG-380E/44 SN: 40605586 CONCORDE BATTERY CAPACITY TEST (PC12-47E = 24-30/340; PC12-45/47 = 24-30/69 2015-07-22, 5322.90 Hours "2015-07-22
5322.90 Hours" 22/07/2015 5322.90 Hours 5322.9
24-30/311 N/A Generator Control Unit (GCU) 1 and GCU 2. 2015-09-02, 7460.30 Hours "2015-09-02
7460.30 Hours" 2/09/2015 7460.30 Hours 7460.3
21-40/52 N/A Duct over temperature switch. 2/08/2015 2/08/2015 2/08/2015 2/08/2015 2/08/2015 2/08/2015
21-40/51 N/A Overtemperature switch. 2/08/2015 2/08/2015 2/08/2015 2/08/2015 2/08/2015 2/08/2015
21-30/318 N/A Pressurization Dump switch. 2015-05-02, 7085.90 Hours "2015-05-02
7085.90 Hours" 2/05/2015 7085.90 Hours 7085.9
21-20/317 N/A ECS emergency shut-off system. 2015-09-03, 7460.30 Hours "2015-09-03
7460.30 Hours" 3/09/2015 7460.30 Hours 7460.3
21-17 PN: 959.90.22.102 SN: 1119 CARRY OUT VCCS SYSTEM ANNUAL INSPECTION 9/09/2015 9/09/2015 9/09/2015 9/09/2015 9/09/2015 9/09/2015
5-Mar N/A OPS 54 IFR Radio Inspection 10/03/2015 10/03/2015 10/03/2015 10/03/2015 10/03/2015 10/03/2015
0500-550 PHASE 6 RESET N/A PHASE 6 RESET 2015-09-15, 5660.30 Hours "2015-09-15
5660.30 Hours" 15/09/2015 5660.30 Hours 5660.3
0500-550 [2] N/A Airframe - 6 Phase Progressive Inspection. 4844.70 Hours 4844.70 Hours 4844.70 Hours 4844.70 Hours
0500-500 N/A Airframe - Progressive Mini Inspection. 4839.40 Hours 4839.40 Hours 4839.40 Hours 4839.40 Hours
00-00/45 (INTERNAL) N/A Airframe - Corrosion Protection Compound Inspection - Internal Areas. 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015 11/09/2015
00-00/45 (EXT) MODERATE N/A Airframe - Corrosion Protection Compound Inspection - External Areas. 13/05/2015 13/05/2015 13/05/2015 13/05/2015 13/05/2015 13/05/2015
This doesn't seem very efficient though - any ideas on how I can process the 'Next Due' field in a better way - maybe a regex - that will:
look for a date in the format dd/mm/YYYY and if found put that date in a new field 'Next_Due_Date' with ISO format YYYY-mm-dd
look for a decimal number before the word 'Hours' and if exists put just the decimal number in a new field 'Next_Due_Hours'
look for a decimal number before the word 'Landings and if exists put just the decimal number in a new field 'Next_Due_Landings'
Be able to handle all of these for a single event
Any ideas welcomed and appreciated!
Thanks!
... View more
12-08-2014
04:52 AM
Thanks for the tip about using single quotes on the right hand side of an eval statement when a field name has a space in it - I had the same issue and this fixed it for me.
... View more
Nice work! Thanks for the tip.
... View more
Hi,
I've got some saved searches scheduled to output CSV files using the outputcsv command which works well. From there I run a script to upload the CSV file to an SFTP server.
I'd like to do something similar with the PDF output from a Dashboard. I have Scheduled PDF Delivery via email but I'm wondering if there is a way to get the PDF output to a file rather than sent via email?
Thanks!
... View more
- Tags:
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
04-13-2021
07:28 AM
|
