Hi @claudiaG , probably my hint will not cover your requisite, but using a search with three joins, you'll wait for hours. Did you tried to correlate events using stats? see my approach and try to...
See more...
Hi @claudiaG , probably my hint will not cover your requisite, but using a search with three joins, you'll wait for hours. Did you tried to correlate events using stats? see my approach and try to adapt it to your Use Case, remembering that Splunk isn't a DB. something like this: index=A
| rename Name as TargetName
| bin span=1w@w0 _time
| stats
values(Status) AS Status
dc(Status) AS Status_count
values(SourceID) AS SourceID
values(type) AS type
BY TargetID _time
| eval state=case(
Status_count=1, Status,
match(status,"Done") OR match(status,"Pending"), "Link + State is there",
NOT match(status,"Done") OR NOT match(status,"Pending"), "State is missing",
1=1, "No Lynk")
| timechart span=1w@w0 count by state Ciao. Giuseppe