Buongiorno Giuseppe, I see what you are saying, but I don't think that will work. Here is what is in an event. {"timestamp": "2024-08-20 15:30:00.837000", "data_type": "finding_export", "domain...
See more...
Buongiorno Giuseppe, I see what you are saying, but I don't think that will work. Here is what is in an event. {"timestamp": "2024-08-20 15:30:00.837000", "data_type": "finding_export", "domain_id": "my_domain_id", "domain_name": "my_domain_name", "path_id": "T0MarkSensitive", "path_title": "My Path Title", "user": "my_user"} Every 15 minutes the binary goes to the API and pulls events. Most of the events are duplicates except for the timestamp. There may or may not be a new event which needs to be alerted on. The monitoring team doesn't want to see any duplication, thus the lookup to save what has already come through. Now the issue is that not all the fields have values all the time. When a field has no value the SHA256 command doesn't work. Which is why I asked is there a better way than doing isnull on each field. Ciao, Joe