How to update watchlist dynamically as opposed to manually updating csv and importing it again

%3CLINGO-SUB%20id%3D%22lingo-sub-2543232%22%20slang%3D%22en-US%22%3EHow%20to%20update%20watchlist%20dynamically%20as%20opposed%20to%20manually%20updating%20csv%20and%20importing%20it%20again%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2543232%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20I%20have%20a%20watch%20list%20that%20works%20fine%20but%20the%20problem%20I%20have%20is%20that%20each%20time%20I%20want%20to%20add%20another%20component%20to%20the%20watchlist%2C%20I%20have%20to%20manually%20update%20the%20csv%20file%2C%20delete%20the%20existing%20Watchlist%20from%20Sentinel%20and%20reimport%20the%20Watchlist%20into%20Sentinel%20again.%26nbsp%3B%20I%20would%20like%20to%20find%20a%20way%20of%20updating%20the%20Watchlist%20dynamically%20but%20I%20am%20told%20that%20the%20feature%20is%20currently%20not%20available%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20anyone%20please%20confirm%20this%20with%20me.%3C%2FP%3E%3CP%3EThanks%20Caitlin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2543308%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20update%20watchlist%20dynamically%20as%20opposed%20to%20manually%20updating%20csv%20and%20importing%20it%20again%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2543308%22%20slang%3D%22en-US%22%3EYou%20can%20edit%20since%20last%20month.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sentinel%2Fwhat-s-new-azure-sentinel-update-watchlist-ui-enhancements%2Fba-p%2F2451476%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sentinel%2Fwhat-s-new-azure-sentinel-update-watchlist-ui-enhancements%2Fba-p%2F2451476%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2543400%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20update%20watchlist%20dynamically%20as%20opposed%20to%20manually%20updating%20csv%20and%20importing%20it%20again%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2543400%22%20slang%3D%22en-US%22%3EUse%20the%20Playbook...%20%3CA%20href%3D%22https%3A%2F%2Fazurecloudai.blog%2F2021%2F06%2F30%2Fhow-to-use-the-watchlists-logic-app-connector-for-azure-sentinel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fazurecloudai.blog%2F2021%2F06%2F30%2Fhow-to-use-the-watchlists-logic-app-connector-for-azure-sentinel%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2551421%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20update%20watchlist%20dynamically%20as%20opposed%20to%20manually%20updating%20csv%20and%20importing%20it%20again%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2551421%22%20slang%3D%22en-US%22%3Ethank%20you%20very%20much%20Clive%20for%20all%20your%20help.%20I%20know%20from%20the%20code%20you%20provided%20me%20I%20am%20able%20to%20pull%20information%20from%20different%20departments%20using%20a%20Watch%20but%20I%20am%20now%20looking%20for%20how%20to%20achieve%20that%20in%20a%20cross%20workspace%20environment.%20Would%20that%20be%20possible%3F%3CBR%20%2F%3ELook%20forward%20to%20hearing%20from%20you%20soon%3CBR%20%2F%3ECaitlin%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2561755%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20update%20watchlist%20dynamically%20as%20opposed%20to%20manually%20updating%20csv%20and%20importing%20it%20again%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2561755%22%20slang%3D%22en-US%22%3EHi%20Clive%20just%20wanted%20to%20check%20if%20is%20it%20possible%20to%20use%20a%20domain%20for%20a%20watchlist%20column%20instead%20of%20FQDN.%20I%20am%20able%20to%20use%20the%20FQDN%20successfully%20but%20using%20the%20domain%20yields%20not%20results.%20Will%20appreciate%20if%20you%20could%20please%20confirm%20with%20me.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3CBR%20%2F%3ECaitlin%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2562784%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20update%20watchlist%20dynamically%20as%20opposed%20to%20manually%20updating%20csv%20and%20importing%20it%20again%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2562784%22%20slang%3D%22en-US%22%3EDomain%20works%20fine%20for%20our%20use.%20We%20have%20a%20ARM%20template%20to%20deploy%20the%20watchlist%20as%20well%20as%20a%20playbook%20that%20works.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello I have a watch list that works fine but the problem I have is that each time I want to add another component to the watchlist, I have to manually update the csv file, delete the existing Watchlist from Sentinel and reimport the Watchlist into Sentinel again.  I would like to find a way of updating the Watchlist dynamically but I am told that the feature is currently not available

 

Could anyone please confirm this with me.

Thanks Caitlin

8 Replies
thank you very much Clive for all your help. I know from the code you provided me I am able to pull information from different departments using a Watch but I am now looking for how to achieve that in a cross workspace environment. Would that be possible?
Look forward to hearing from you soon
Caitlin
Thank you very much for the pointers Rodtrent
Much appreciated
Hi Clive just wanted to check if is it possible to use a domain for a watchlist column instead of FQDN. I am able to use the FQDN successfully but using the domain yields not results. Will appreciate if you could please confirm with me.

Thank you
Caitlin
You create the watchlist, so you can have a column called whatever you like with whatever data you like. Ideally you'd match the column names from the Table to ones in the watchlist to make any join() easier. The two sides just need to match, and be case sensitive.

i.e if your Watchlist has a column called Domain that contains "microsoft.com" you'd be able to match to "microsoft.com" in a query.
Domain works fine for our use. We have a ARM template to deploy the watchlist as well as a playbook that works.