Hi Amit, I'm not sure about the issue, but I suggest trying to reinstall with the latest agent version. Also, check the connectivity and SSL certification if required. Make sure that the hostname is correctly set in the server section to ensure all metrics are present.

Hi Rohit, Could you please perform the following checks: 1) Verify the connection between the database agent and the controller, as well as between the database agent and the database server. 2) Ensure that the user has the correct permissions as specified in the AppDynamics document. https://docs.appdynamics.com/appd/onprem/23.x/23.2/ja/database-visibility/add-database-collectors/configure-mysql-collectors  3) Check if you have created a user for the db collector setting. Try logging in with the same user on the MySQL server to confirm that the user ID and password are correct. Thank you.

Hello @vishenps , First, upgrade the add-on builder version. Then, move all configurations to the default directory within the custom app from the local directory, and then remove the local directory. Finally, proceed with the vetting process. Let me know how it goes Please accept the solution and hit Karma, if this helps!

Yes, i released that its not "timestamp " and its changes to "eventTimestamp" in raw data  However  modified query but still its not working. ====================================================================== index=* namespace="dk1017-j" sourcetype="kube:container:kafka-clickhouse-snapshot-writer" message="*Snapshot event published*" AND message="*dbI-LDN*" AND message="*2024-04-03*" AND message="*" |fields message |rex field=_raw "\s+date=(?<BusDate>\d{4}-\d{2}-\d{2})" |rex field=_raw "sourceSystem=(?<Source>[^,]*)" |rex field=_raw "entityType=(?<Entity>\w+)" |rex field=_raw "\"eventTimestamp\":\"(?<Time>\d{4}-\d{2}-\d{2}[T]\d{2}:\d{2})"  --> Please suggest here  |sort Time desc |dedup Entity |table Source, BusDate, Entity, Time ====================================================================== attaching sample raw screenshot for your reference    

Hi Rich,   I am sorry for the poorly worded question. "You have alert, which the cron schedule says to fire at 1 PM (13:00) in CDT.  That's 11:30 PM (23:30) IST. " The issue is instead of receiving the mail at 11:30 PM (23:30) IST, I receive it on 11:30 am IST.     If you check the mail screenshot, you can see the inline query result returned wed Apr 3 13:00, but trigger time is April 4, 01:19 am CST, and the mail reached my inbox on April 4, 11:49 am IST. Shouldn't it be actually April 3 13:19 CST and 23:49 IST?

The thread you're responding to is relatively old and is not directly related to your question. To keep the Answers tidy and focused and to ensure visibility of your issue please submit your question(s) as a new thread.  

Your command says "\"timestamp\":\"(?<Time>\d{4}-\d{2}-\d{2}[T]\d{2}:\d{2})"  So it will match only if you have a part of your event containing (of course the timestamp is just an example) "timestamp":"2023-01-12T14:54 Since your event is formatted differently (most significantly, the "field" you're extracting from is not named "timestamp"), you need to adjust this regex. Use https://regex101.com for checking/verifying your ideas. As a side note - manipulating structured data (in your case - json) with regexes might not be the best idea.

Also please check below query which is working , however it does not giving me required output , i need only time. in Last column =============================================================== index=* namespace="dk1017-j" sourcetype="kube:container:kafka-clickhouse-snapshot-writer" message="*Snapshot event published*" AND message="*dbI-LDN*" AND message="*2024-04-03*" AND message="*" |fields message |rex field=_raw "\s+date=(?<BusDate>\d{4}-\d{2}-\d{2})" |rex field=_raw "sourceSystem=(?<Source>[^,]*)" |rex field=_raw "entityType=(?<Entity>\w+)" |rex field=_raw "eventTimestamp=(?<Time>\d{4}-\d{2}-\d{2}[T]\d{2}:\d{2})"   --> Need only time  |sort Time desc |dedup Entity |table Source, BusDate, Entity, Time ================================================================   please check screenshot for more clear understanding    

Ahhh... This is a Splunk-specific class. I thought this was supposed to be some generic HTTP POST based mechanism. OK, in this case it might indeed be inserting the proper REST endpoint on its own. Anyway, I'd try debugging by just launching tcpdump/wireshark and verifying if there is any connectivity between your app and your HEC input (and if there is - what is going on there). You use unencrypted HTTP so you should see the traffic

Can anyone explain if the following issues could be interconnected? Storage Limit: Splunk’s storage is nearing its limit. Could this be affecting the performance or functionality of other components? Permission Error: An error message indicates that the “Splunk_SA_CIM” app either does not exist or lacks sufficient permissions. Could this be causing issues with data access or processing? Transparent Huge Pages (THP) Status: THP is not disabled. It’s known that THP can interfere with Splunk’s memory management. Could this be contributing to the problems? Memory and Ulimit: Could memory constraints or ulimit settings be causing errors? Remote Search Process Failure: There was a failure in the remote search process on a peer, leading to potentially incomplete search results. The search process on the peer (Affected indexer) ended prematurely. The error message suggests that the application “Splunk_SA_CIM” does not exist. Could this be related to the aforementioned “Splunk_SA_CIM” error? Could these issues be interconnected, and if so, how? Could resolving one issue potentially alleviate the others?

Hi @bhaskar5428, Your rex command seems trying to extract Time field from @timestamp field. Can you please show the raw data by clicking "Show as raw text" selection under the raw event? Splunk shows JSON events as formatted but rex works on real text itself.  We cannot compare your regex and raw data using this  screen capture.