Hi, I am trying to run dbxquery command but it keeps throwing the below error.  I have configured the database connection on a heavy forwarder on the DB Connect add-on and I am running the query on a search head. I have verified that the username and password are working fine. Can someone help me understand what I am missing? error: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: ORA-02002: error while writing to audit trail ORA-55917: Table flush I/O failed for log ID: 3 bucket ID: 0 ORA-55917: Table flush I/O failed for log ID: 3 bucket ID: 0 ORA-01918: user 'ORA-01918: user '' does not exist ORA-28001: the password has expired ' does not exist ORA-28001: the password has expired   query: | dbxquery maxrows=200000 query="SELECT SERVER_NAME, HOST_NAME, MEMORY, OS, SERVER_ENV, TCPIPADDRESS, PROJECT, LOCATION, BUILDING_CODE, COUNTRY, MAKE, MODEL, BOX, GRID, AC_ASSET_TAG, STATUS, OS_SG, DB_SG, SUPPORTCONTRACTS, MC_CS_IP, MC_TS_IP, SERVER_CONTACT, SERVER_CATEGORY FROM \"ASSETMANAGER\".\"AMASSET_SUPPORT_VIEW\"" connection="FCAMS" Thanks   ... View more

Hi, I have over 150 alerts to which I have to add new lines of code like below example. I am updating each alert manually and it is getting tedious. Is there a way to update all the alerts in bulk? I also want to add additional alert action (send Webex teams notification) along with the existing send email action. Can anyone please suggest a way to do it? eg: old alert search |makeresults | eval message="Hi How are you" New alert search |makeresults| eval message="Hi How are you"| eval message2= "this is message2" |eval message3="this is message3" ... View more

Hi guys, I am trying to change the color of a single value panel based on the timestamp. Eg: if the count is > 5 from 12 am - 8 am - the panel should be green, and if the count is > 5 from 8 am - 6 pm - the panel should be red. I am trying to dynamically change the colors based on the timerange Please help. ... View more

Hi, I am trying to generate a report of all the data models that I have in my environment along with the last time it has been accessed to do a cleanup. Can anyone help with the search query? ... View more

Hi, How can I generate a random number between 1 to 20. I random() function doesn't allow to specify a range. please help ... View more

Hi, In my data, I have API calls with several extensions like (.html, .com, .php and many more). I am trying to exclude the logs that have these extensions. I tried the below. index=abc NOT (api_call=".html." OR api_call=".php") But, I don't want to use NOT since there are many extensions that will come in the future. Can anyone help? ... View more

Hi, one of my db input in DB connect gets auto disabled multiple time even after manually enabling the input. When I check the connection everything seems to be good. Is there a way I can check from the internal logs for any errors or issue ? ... View more

Hi I want to have a feature where I click a radio button on a dashboard and it sends an alert. Also can anyone help me how to use the sendalert command with an example. thank you ... View more

hi I am trying to extract the email id from the text eg: PUT /api/users/usernames/eejuy.alves92%40gmail.com/ PUT /api/users/usernames/acvf.bbss%40xyz123.com.br/ POST /api/users/jabcd%40xyz.edu.br/passwords ... View more

Hi I have a CSV file with the list of latitudes and longitudes to display on the map. I want to get the count of events and the name of the cities for each latitude and longitude. the iplocation command works only when you have a field which has ipaddress. but my dataset doesn't give me the ipaddress. I want to display the name of the city using the latitude and longitude values. Please help. ... View more