Eventsource | LM Exchange | LogicMonitor Community

manthena2020 · 2023-05-26T13:41:21Z

hi iam using te following code for event script. The output iam getting is There would be no script events for the selected device. IF iam running in datasource the script is working both in jason formatimport groovy.sql.Sqlimport groovy.json.JsonBuilderimport org.json.JSONObjectdef hostname = hostProps.get("system.hostname")def user = hostProps.get("sybase.user")def pass = hostProps.get("sybase.pass")def port = 21000def url = "jdbc:sybase:Tds:" + hostname + ":21000"def driver = "com.sybase.jdbc4.jdbc.SybDriver"def sql = Sql.newInstance(url, user, pass, driver)if (sql.connection) {// println("Connected to Sybase server on ${hostname}")def filePath = "/tmp/BTS01DEV_WNL_DS.log" // Replace with the actual file path on the Linux machinedef file = new File(filePath)if (file.exists() && file.isFile()) {def lines = file.readLines()// Define the keywords to search fordef keywords = ["warning","error","fail",// Add more keywords as needed]// Find the lines that contain the keywords along with their indicesdef matchedLines = lines.findAll { line -> keywords.any { keyword -> line.toLowerCase().contains(keyword) } }.collect { line -> [line: lines.indexOf(line) + 1, message: line] }// Construct the final JSON objectdef json = new JsonBuilder()json {events matchedLines}// Convert the JSON object to a stringdef jsonString = json.toString()// Remove leading characters until the first '{' characterdef startIndex = jsonString.indexOf('{')def trimmedJsonString = jsonString.substring(startIndex)// Create the JSONObject from the trimmed JSON stringdef jsonObject = new JSONObject(trimmedJsonString)println(jsonObject.toString())} else {println("File not found or is not a regular file")}} else {println("Failed to connect to Sybase server on ${hostname}")}out put in datasource:{"events":[{"line":41,"message":"00:0000:00000:00000:2021/04/21 14:54:02.58 kernel Warning: Operating System stack size is greater than 2MB. If it is too large, ASE may run out of memory during thread creation. You can reconfigure it using 'limit' (csh) or 'ulimit' (bash)"},{"line":177,"message":"00:0006:00000:00002:2021/04/21 14:54:03.46 kernel Warning: Cannot set console to nonblocking mode, switching to blocking mode."},{"line":313,"message":"00:0000:00000:00000:2021/04/21 16:42:08.18 kernel Warning: Operating System stack size is greater than 2MB. If it is too large, ASE may run out of memory during thread creation. You can reconfigure it using 'limit' (csh) or 'ulimit' (bash)"},{"line":636,"message":"00:0002:00000:00002:2021/04/21 16:41:26.28 kernel Warning: Cannot set console to nonblocking mode, switching to blocking mode."}

MoreDiscussions