Is there a way to find if a column name is in more then one SharePoint list?

Question

This is specific to SharePoint 2007, though I am sure it could cross over into 2010.

My situation is I am a site curator that inherited a site with 30+ lists. Several of these lists are using a drop down list with a hard coded list of names. Each time someone leaves the team or company I have to update all these drop down lists. Now I am aware of 3 lists but I am sure there is more.

I do not have access to SharePoint Designer so need a solution that is non code. But if this is something I can pass along to the SharePoint Admins to do I will be more then happy.

Once I narrow down all the lists using a particular column name I plan on changing them to a filtered lookup pulling off one list. Until then I have to update the drop drowns manually.

Thanks ahead of time.

Answer 1

There's no no-code way to do this.

Also, SPD != code access.

You could write a PowerShell script pretty quickly to do this. Or use the Client Object Model if you don't want to run code on the server.

Seeing as how you said it's SP 2007 though, the CSOM is unavailable to you. You always have SP 2007 web services though :)