Hai, I have a log file in .txt format and format of the log is given below. From the log i want to pick up some particular words and insert onto a table using SQL. I want the output of the table like
occurred Time pcmcircuit unavailableSec 04/14/12 10:07:33 77 32 04/14/12 10:20:10 15 43291 . . . 04/14/12 10:20:10 15 4329 . 04/14/12 10:07:33 77 32 and so on....
SO please tell me is it possible in SQL, If possible tell the script.
**** Notification : 8020374 ********** SEVERITY : CLEARED **************** occurred on 04/14/12 10:07:33 - received on 04/14/12 10:07:31 Type : communicationsAlarm Instance : bsc 13 | pcmCircuit 77 Description : IMPHAL - Information on fault ------------------------- Probable cause : (29) lossOfSignal Fault number : (2009) PCM FAILURE - Manufacturer Information --------------------- "E1L PCM Fault End Time" - Other information ---------------------------- PCM failure : Hardware Slot Position : shelfNumber : 1 positionInShelf : 12 portNumber : 14 pcmType : pcmAbis thresholdInfo : 10 unavailabSec : 32 Notification at MDlevel : 8643316 - received on 04/14/12 10:07:31 ************************************************************************** **** Notification : 8020723 ********** SEVERITY : CLEARED **************** occurred on 04/14/12 10:20:10 - received on 04/14/12 10:20:18 Type : communicationsAlarm Instance : bsc 13 | pcmCircuit 15 Description : IMPHAL - Information on fault ------------------------- Probable cause : (29) lossOfSignal Fault number : (2009) PCM FAILURE - Manufacturer Information --------------------- "E1L PCM Fault End Time" - Other information ---------------------------- PCM failure : Hardware Slot Position : shelfNumber : 0 positionInShelf : 5 portNumber : 15 pcmType : pcmAbis thresholdInfo : 10 unavailabSec : 43291 Notification at MDlevel : 8643712 - received on 04/14/12 10:20:18 ************************************************************************** **** Notification : 8020828 ********** SEVERITY : CLEARED **************** occurred on 04/14/12 10:22:40 - received on 04/14/12 10:22:38 Type : communicationsAlarm Instance : bsc 13 | pcmCircuit 50 Description : IMPHAL - Information on fault ------------------------- Probable cause : (29) lossOfSignal Fault number : (2009) PCM FAILURE - Manufacturer Information --------------------- "E1L PCM Fault End Time" - Other information ---------------------------- PCM failure : Hardware Slot Position : shelfNumber : 1 positionInShelf : 9 portNumber : 8 pcmType : pcmAbis thresholdInfo : 10 unavailabSec : 13744 Notification at MDlevel : 8643824 - received on 04/14/12 10:22:38 ************************************************************************** **** Notification : 8021678 ********** SEVERITY : CLEARED **************** occurred on 04/14/12 10:45:43 - received on 04/14/12 10:45:42 Type : communicationsAlarm Instance : bsc 13 | pcmCircuit 82 Description : IMPHAL - Information on fault ------------------------- Probable cause : (29) lossOfSignal Fault number : (2009) PCM FAILURE - Manufacturer Information --------------------- "E1L PCM Fault End Time" - Other information ---------------------------- PCM failure : Hardware Slot Position : shelfNumber : 1 positionInShelf : 12 portNumber : 19 pcmType : pcmAbis thresholdInfo : 10 unavailabSec : 11576 Notification at MDlevel : 8644757 - received on 04/14/12 10:45:42 ************************************************************************** **** Notification : 8021804 ********** SEVERITY : CLEARED **************** occurred on 04/14/12 10:49:39 - received on 04/14/12 10:49:37 Type : communicationsAlarm Instance : bsc 13 | pcmCircuit 72 Description : IMPHAL - Information on fault ------------------------- Probable cause : (29) lossOfSignal Fault number : (2009) PCM FAILURE - Manufacturer Information --------------------- "E1L PCM Fault End Time" - Other information ---------------------------- PCM failure : Hardware Slot Position : shelfNumber : 1 positionInShelf : 12 portNumber : 9 pcmType : pcmAbis thresholdInfo : 10 unavailabSec : 4824 Notification at MDlevel : 8644897 - received on 04/14/12 10:49:37 ************************************************************************** **** Notification : 8022129 ********** SEVERITY : CLEARED **************** occurred on 04/14/12 10:56:06 - received on 04/14/12 10:56:04 Type : communicationsAlarm Instance : bsc 13 | pcmCircuit 76 Description : IMPHAL - Information on fault ------------------------- Probable cause : (29) lossOfSignal Fault number : (2009) PCM FAILURE - Manufacturer Information --------------------- "E1L PCM Fault End Time" - Other information ---------------------------- PCM failure : Hardware Slot Position : shelfNumber : 1 positionInShelf : 12 portNumber : 13 pcmType : pcmAbis thresholdInfo : 10 unavailabSec : 53165 Notification at MDlevel : 8645245 - received on 04/14/12 10:56:04 ************************************************************************** **** Notification : 8022215 ********** SEVERITY : CLEARED **************** occurred on 04/14/12 10:58:00 - received on 04/14/12 10:57:59 Type : communicationsAlarm Instance : bsc 13 | pcmCircuit 16 Description : IMPHAL - Information on fault ------------------------- Probable cause : (29) lossOfSignal Fault number : (2009) PCM FAILURE - Manufacturer Information --------------------- "E1L PCM Fault End Time" - Other information ---------------------------- PCM failure : Hardware Slot Position : shelfNumber : 0 positionInShelf : 5 portNumber : 16 pcmType : pcmAbis thresholdInfo : 10 unavailabSec : 12151 Notification at MDlevel : 8645341 - received on 04/14/12 10:57:59 ************************************************************************** **** Notification : 8022641 ********** SEVERITY : major ****************** occurred on 04/14/12 11:16:24 - received on 04/14/12 11:16:22 Type : communicationsAlarm Instance : bsc 13 | pcmCircuit 77 Description : IMPHAL - Information on fault ------------------------- Probable cause : (29) lossOfSignal Fault number : (2009) PCM FAILURE - Manufacturer Information --------------------- "E1L PCM Fault Begin Time" - Other information ---------------------------- PCM failure : Hardware Slot Position : shelfNumber : 1 positionInShelf : 3 portNumber : 15 pcmType : pcmAbis thresholdInfo : 5 ndSecLos : 0 ndSecAis : 5 ndSecLfa : 0 ndSecFe : 0 ndSecCrc : 0 ndSecRai : 0 ndSecEBits : 0 Notification at MDlevel : 8645822 - received on 04/14/12 11:16:22 **************************************************************************
Ads