Hi,
I was wondering if anyone has a script / query / other way to search for a certain value among all variables of currently deployed releases? Say you need to check if a AWS access key you’re rotating out is still in use and you know you’d have that key in a OD variables. I tried writing a Raven query for this myself but it was a bit too complicated for a first time Raven user. 
Thanks!
I would just use the Octopus REST APIs - you can find the latest deployment to a given environment for a given project.
I wouldn’t query the DB as that could change whereas the APIs should be reasonably stable.
Hi,
Eric’s suggestion of using the API would be the only way to do this currently.
This is probably the closest suggestion we have on UserVoice so I suggest you vote and comment!
Vanessa