Hello,
Nice use case, you can achieve this by defining a CSV lookup.
The CSV file will have 2 columns, the first one is member name and the second one is Membership status, something like that:
user, membership_status
User1,Yes
User2,Yes
User3,Yes
User4,Yes
Your events should include the user filed (first coulmn header).
Define the lookup in in transforms.conf
[Team_Members_lookup]
filename = team_members.csv
default_match = No
CSV file location:
/lookups/team_members.csv
You search query can be like this:
sourcetype=winlogs | lookup Team_Members_lookup user OUTPUT membership_status | search dest_machine=Serv123 membership_status=No
This lookup enriches the logs with a new field membership_status, its value will be "Yes" if the user is on the csv file otherwise it will be "No"
You can add the lookup to props.conf to be applied automatically on a certain sourcetype, and in this case you don't need to put "lookup Team_Members_lookup user OUTPUT membership_status" in your query, but it may have some performance impact as the lookup is applied in all searches.
Regards
... View more