Im trying to substract the total number i have of alerts that send and email from the total amount of alerts that are bookmarked in SSE. The only examples I found on the community used either the same index, or sub-searches (neither worked in my scenario) My query for the alerts is :
| rest /services/saved/searches | search alert_type!="always" AND action.email.to="
[email protected]" AND title!="*test*"
| stats count(action.email.to) AS "Count"
My query for bookmarks is:
| sseanalytics 'bookmark'
| where bookmark_status="successfullyImplemented"
| stats count(bookmark_status_display) AS "Bookmark Status" by bookmark_status_display
... View more