Disclaimer: Sorry guys, I hate being the new guy who's probably asking a dumb question, but I'm new to PowerShell and what I've used of it so far has been vastly useful, so I'm trying to expand my knowledge of it.
Right now, our agency's intranet runs on SharePoint 2007 (we're moving to SP2010 in a few months, but I guess that's irrelevant here). We have several minor projects that I think PowerShell would really help us expediate. For example:
1) Someone accidentally changed the default "Title" field into "Ticket," which rippled down and changed EVERY instance of the Title field. We've gone through and manually reverted the change on most of our high-usage sites and lists, but there's just no telling where else this inadvertant change was made. Is there a way to use PowerShell to search our SharePoint 2007 site collections to find all instances of the "Ticket" field? I'm not a SharePoint admin, and don't have access to the server. I realize that this would be a task better suited for the admins, but in our agency, it will get done faster if I could hand the admins a list of all further instances that need to be changed. Keep in mind, I don't want to actually change the fields myself: I only want to find them.
2) I have a project in which I want to get all the metadata off of a SharePoint list and turn it into an XML file. I already have all the code to do this from prior projects, EXCEPT that I don't know how to read SharePoint list data with PowerShell. I know that I can export the list to an Excel spreadsheet and work with it from there, but I'd much rather skip that step and pull the data directly off the list. How do I read SharePoint 2007 list data with PowerShell without having SP server access?
I have several other similar projects, but they all revolve around that one simple question: How do I read SharePoint 2007 data with PowerShell without having SP server access?
It may not be possible, but I'd like the input of those more experienced than I before I give up and take another, possibly less effective route. Thanks!