how to monitor a file for content and send email if content available...

[CommunityUser]

Hi,

As an AppD beginner, loads of time, I get stuck with the easiest problems..   😞    right now I am trying to create a search that extracts content from a file.

SELECT * FROM logs WHERE source = "%*SAP*%" and messages like "%,cn%" but do not get a search result.    *sap*  is part of the filename.     ,cn is part of the content...      any good ideas out there ??    

thanks.

helmut. 

[Mohammed_Rayan · Accepted solution]

Helmut,

can you let us know what's the error you are facing while running that query. Maybe, you can share a screenshot if possible.

Also, I would suggest you to try something like below and let me know if it works and also try once without any wildcard charcters and share its result.

SELECT * FROM logs WHERE source = "%*SAP*%" and message ="%,cn%"

Regards,

Mohammed Rayan