I am trying to come up with a script to do the following in my SharePoint 2013 environment, and have not had much luck.
I need a script that will generate a report/csv that will list all items in lists where a site column has a specific value.
For example, say I have a site collection at http://test/site, and a site column named "State." That column is used in multiple lists throughout my site collection. I need to generate a report which shows all instances of items where State Column = Texas.
Thanks for any help you can provide.