I have been given this query to get data into dbconnect, it works perfectly fine for batch, but i want to run and get results for rising column by using EVENT_TIME from January 1st 2020. what should be added to the below query, i tried adding AND EVENT_TIME > ? ORDER BY EVENT_TIME DESC and it gives java.sql.SQLDataException: ORA-01861: literal does not match format string. If i change EVENT_TIME to EVENT_NAME it works but i want rising column value for event time . Please help  SELECT sa.main_location AS main_location, sa.sub_location AS sub_location, sa.event_name AS event_name, sa.event_type AS event_type, to_char (sa.event_time, 'mm/dd/yyyy hh24:mi:ss') AS event_time, sa.entity_type AS entity_type, su.sys_user_id AS rac FROM jiva.security_audit_info sa LEFT JOIN jiva.sys_user su ON su.user_idn = sa.user_idn LEFT JOIN jiva.entity e ON e.entity_idn = su.entity_idn WHERE sa.event_name IN ( 'user_login', 'user_logout' ) ... View more

I want to edit server.conf for around 600 servers, is there anyway we can edit them all at a time. ... View more

I am getting these errors in my internal logs: ERROR SearchOperator:kv - Cannot compile RE \"(?:\s*'[^']*'|\s*"[^"]*"|\s*[^,]*)\s*(?[^,']*'[^']*'|[^,"]*"[^"]*"|[^,]*)\s*(?[^,']*'[^']*'|[^,"]*"[^"]*"|[^,]*),\s*(?[^,']*'[^']*'|[^,"]*"[^"]*"|[^,]*),\s*(?[^,']*'[^']*'|[^,"]*"[^"]*"|[^,]*)\" for transform 'field_extraction_for_scm_system': Regex: two named subpatterns have the same name (PCRE2_DUPNAMES not set). Couldn't figure out how to fix it. ... View more

Hi, I can see the license usage of hosts in my environment by using this query: index=_internal source=*license_usage.log type=Usage | stats sum(b) AS Bytes by h | eval GB = Bytes/1024/1024/1024 | rename h as host | table host GB | sort -GB | addcoltotals but i have to calculate only the license usage of dev environment hosts, i have created a lookup as dev.csv, but i am not sure how to get only the license usage of hosts in that lookup file. ... View more