DumpOctoVariables.cs

void Main()
{
	var server = "";  
	var apiKey = "";
	var endpoint = new OctopusServerEndpoint(server, apiKey);
	var repository = new OctopusRepository(endpoint);
	
	var projectList = repository.Projects.GetAll();
	
	var dumpedVariables = new List<DumpedVariable>();
	
	foreach (var project in projectList)
	{
		var projectDetails = repository.Projects.Get(project.Id);
		
		var localVariables = repository.VariableSets.Get(projectDetails.VariableSetId);
		
		foreach (var variable in localVariables.Variables)
		{
			dumpedVariables.Add(new UserQuery.DumpedVariable{ProjectName = project.Name, VariableName = variable.Name, Value = variable.Value});
		}
	}
	
	dumpedVariables.Where (v => v.Value != null && v.Value.Contains("Data Source")).Dump();
}

// Define other methods and classes here

class DumpedVariable
{
	public string ProjectName {get;set;}
	public string VariableName {get;set;}
	public string Value {get;set;}
}