Windows PowerShell is Microsoft's task automation framework, consisting of a command-line shell and associated scripting language built on top of, and integrated with the .NET Framework. PowerShell provides full access to COM and WMI, enabling administrators to perform administrative tasks on both ...
10
votes
3answers
3k views
How to automate entry of external column data in BCS?
I have a document library, Resumes, that has a large number of resumes in it. There is a regular column on that library, called EmployeeID, that is already populated. I have an external content type ...
8
votes
2answers
1k views
SPWeb being closed when getting list by powershell. What's wrong?
When I run this little piece of powershell code:
$w = Get-SPWeb http://localhost
$l = $w.List["some list"]
I get Unexpected error message to my Sharepoint ULS log
Detected use of SPRequest for ...
8
votes
2answers
7k views
Suddenly getting “The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.”
This morning all the development machines at the company I work at, couldn't manage SharePoint through Powershell. We were all getting the annoying "The local farm is not accessible. Cmdlets with ...
7
votes
4answers
3k views
How to log off user from SharePoint site, if the user has been inactive for 20 minutes
How to log off the SharePoint site, if the user is has been inactive for for 20 minutes? Do I need to redirect user to logout page? How would I count the idle time?
7
votes
3answers
11k views
PowerShell: Script to check feature status (enabled/disabled) before activating
I am developing a script to refresh my custom features. Earlier i was just looping through the features and calling Disable-SPFeature and Enable-SPFeature on each items.
The issue is when the ...
7
votes
3answers
5k views
Restore-SPSite to the same content database
I ran Restore-SPSite on my server from a backup. I then deleted the site collection and did it again but got the following error:
Restore-SPSite : The operation that you are attempting to perform ...
7
votes
3answers
3k views
Problem with HTTP Handler deployed on Sharepoint 2010
I've developed a Visual Web Part for Sharepoint 2010. I've used VS2010 to do that and tested the Webpart in a testing server using VS to do the deployment.
But to deploy it on the production server I ...
6
votes
2answers
6k views
How do I check if a site already exists from PowerShell?
I have a script that exports a site and restores it in another web application. I want to check if the target site already exists. Is there an easy way to tell if www.example.org/sites/asite/ is ...
6
votes
4answers
2k views
How can I schedule the User Profile Service to run a full sync weekly?
We are running SharePoint Server 2010 and have not yet applied SP1. User profile incremental sync is not picking up all of the group membership from AD. Starting a full sync seems to rectify the ...
6
votes
1answer
2k views
Problem installing web part using Powershell
We've developed a custom Visual Web Part using Visual Studio 2010 for Sharepoint 2010 Server.
The webpart gets deployed when executed from VS (F5), so we can add it wherever we want using Sharepoint ...
6
votes
2answers
158 views
What is a good way to build/install/provision a full web application?
I have a fairly simple SharePoint web application, with a publishing front end, an extranet for customers and an intranet portal.
I want this web app to be easily redeployable -- pretty much a ...
5
votes
4answers
7k views
Powershell: cannot access the local farm
Yes, I am logged into the machine as an administrator, and my domain account id a farm admin as well. The site is running properly, and nothing seems wrong in SP Central Administration.
But when I ...
5
votes
2answers
660 views
How to reproduce Visual Studio “Deploy” action?
It seems like whenever I am developing a web part and I "Deploy" it from Visual Studio, everything gets deployed and works exactly as I would expect.
When I take my WSP and try to install it to a ...
5
votes
3answers
5k views
Sharepoint 2010 powershell add-spsolution access denied
I'm trying to do a test deployment to a client server.
The site collection backup completed without error.
When trying to add a spsolution I get an 'Access Denied' error. I'm adding it with the ...
5
votes
1answer
429 views
Obtain Default Content Access Account via PowerShell
As part of farm configuration audit, I need to obtain the current content access account. While I've found several resources for setting the default content access account for search using PowerShell, ...
5
votes
2answers
4k views
How to fix credential issue?
I tried both default credential and user/pass but keep getting 401 unauthorized error. What's the fix?
Here is the error I am getting ....
New-WebServiceProxy : The request failed with HTTP status ...
5
votes
3answers
374 views
Powershell, why did the development team decide to only support async executions?
I've been getting into power shell recently. I am beyond impressed with it, and I think its perhaps the most exciting SharePoint tool yet. It is extremely versatile and it really does live up to its ...
5
votes
1answer
312 views
SharePoint 2010 Documentor
Is there already existing a tool , I think "documentor" can be his name for Sharepoint 2010 that can output a form of documentation with a description of all db, web application , sites, sub sites , ...
5
votes
1answer
804 views
Script to find all items that do not inherit permissions
I would like a SP 2010 Powershell script which searches all folders in a library and finds the ones that do not inherit permissions from their parent.
Does anyone have one handy? I'm new to the ...
5
votes
2answers
998 views
Automate SharePoint Site build with NAnt
As part of a new SharePoint 2010 project I am trying to automate the build of the SharePoint site on our staging system using NAnt, something we use a lot with our C# builds.
I have created a ...
5
votes
2answers
223 views
I dont have permissions to use SharePoint PowerShell, what to do?
I am a developer and would like to deploy a wsp to a server (win2k8r2) from my customer. I log in with some user created special for me. When I start SharePoint PowerShell I got this error:
The local ...
5
votes
1answer
1k views
Get total size of attached files on all list items in SharePoint 2007with PowerShell v2.0
Using Powershell, I have to get the total size of all attached files on all list items for a generic list. I tried using the function below but this displays the total length of names for the attached ...
5
votes
1answer
93 views
What update I have to install in Foundation 2010 to run a backup that asks for version 4.1.13.0?
I'm trying to run a backup from a Sharepoint Server 2010 that runs a version 14.0.6101.5008:
The version of my local Sharepoint Foundation 2010 server is 14.0.6114.5000:
When I run the backup ...
5
votes
1answer
513 views
Extracting Comments from Version History in Powershell
So I am trying to extract version history from a document library in Powershell. I have found the commands/scripts to do this. However I cannot seem to get the comments.
From my script I can get ...
5
votes
1answer
634 views
Adding a list item with PowerShell doesn't trigger event receiver
I have a simple list with an event receiver for the following events:
ItemAdded
ItemUpdating
ItemDeleting
I confirmed that the event receiver fires when adding/updating/deleting an item from the ...
4
votes
4answers
2k views
Update-SPSolution does not Deploy Solution
I am trying to deploy or update a WSP solution to SharePoint in a script using Update-SPSolution. The problem I have is that if this is the initial install I need to use Add-SPSolution and then ...
4
votes
3answers
6k views
Download and delete documents using Powershell
I'm looking to build a Powershell script that does the following to all documents in a SharePoint 2010 document library:
Downloads the document to a network file share
Deletes the original document ...
4
votes
3answers
8k views
How to activate feature using powershell script?
I need to activate specific feature to all site collection which is inside the particular web application using powershell script?
4
votes
2answers
3k views
Powershell and checking for Site existence
I am an nube to Powershell, so I think I have a pretty basic question here....
How do I determine if a SPWeb exists? I want to perform some operations on a site based on a URL passed in as a ...
4
votes
3answers
894 views
How can I modify a file stored in SharePoint via PowerShell?
I have some files in SP 2010 that are simply HTML, and I need to modify the contents of those files in a systematic manner.
Is there a good way to do this using powershell? Imagine that I want to ...
4
votes
3answers
1k views
Deploying a site template and instantiate it in the same PowerShell script?
I want to create a PowerShell script that :
add a farm solution that only contains a site template
deploy the solution globally
wait for the deploy job to finish
create a site collection based on ...
4
votes
3answers
3k views
Use Powershell to iterate through all UserProfile properties
The following script spits out all UserProfile properties for users on Sharepoint 2007:
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Server")
...
4
votes
2answers
1k views
Move files between document libraries in the same Site Collection (#2)
Quick note: First and foremost - this is somewhat in line with a previous post of mine found here: Move files between document libraries in the same Site Collection however I've opened a new question ...
4
votes
1answer
2k views
Remove a single user from all site collections in a web application using powershell
Is there a way I can choose to remove a single user from all site collections within a single web application using powershell. There are number of user profiles whose domain account has been blocked ...
4
votes
1answer
435 views
powershell not finding shared document library?
There is a document library called "shared documents" in the site I type at the prompt when running this script. The script returns the titles of several document libraries, but not "shared ...
4
votes
1answer
385 views
How to import term sets to Managed Metadata Service using PowerShell and CSV file
How do I import a CSV file to metadata service using PowerShell? The CSV file has 500 rows and seven levels in it (Importing of term store).
4
votes
2answers
221 views
Uninstalling PowerShell 1.0 before installing SharePoint 2010
While going through the book "Beginning SharePoint 2010 Administration", the author was discussing how to prepare for a SharePoint 2010 server installation on a Windows 2008 R2 server. In that one of ...
4
votes
1answer
2k views
Traverse through List of Documents using PowerShell
I am new to PowerShell and would like to achieve the following tasks on a SharePoint 2010 Document library:
1) Using PowerShell, how can I display the List of Documents in a simple Document Library. ...
4
votes
1answer
2k views
All Authenticated Users claim
I'm adding items to my list by powershell script. I need to fine-grain user permissions to added items.
Code I'm using now:
$claim = New-SPClaimsPrincipal -ClaimValue $role -ClaimType $ROLE_CLAIM ...
4
votes
1answer
97 views
Is VS 2010 needed to build a SharePoint 2010 project in Powershell?
Can you build a SharePoint Project without Visual Studio 2010/2012 being installed on the machine you are trying build it on using PowerShell?
I have a PowerShell script the is working great. It ...
4
votes
1answer
474 views
Schedule the copy of a document to a network location
I'm looking to copy a document to a network location on a scheduled basis. Anyone have a best practice on how to do that? I thought I could write a work flow, but since I want to copy to a ...
4
votes
1answer
4k views
PowerShell - create list from list template in list template gallery
Using PowerShell on a SharePoint 2010 site, how can you create a new list from a list template found in the list template gallery?. I want to be able to add several lists at once (just in numerically ...
4
votes
2answers
1k views
Removing Orphaned WebParts via PowerShell - CheckIn/CheckOut Requirement Loop
A client migrated from 2007 to 2010 doing a database detach/reattach without checking the database for orphaned objects first. I whipped up a PowerShell script to programmatically remove orphaned ...
4
votes
1answer
496 views
Set default value for SharePoint Calendar description field
How can you set the default value for the 'Description' field for a SharePoint 2010 calendar list? There is nothing in the web interface for doing this, so I have tried it with PowerShell.
$w = ...
4
votes
1answer
184 views
Powershell scripts: Create user profile synchronization service using sharepoint active directory
In sharepoint 2013 I have to create user profile synchronization connection using sharepoint active directory through scripts. I have created the user profile service using powershell after that is ...
3
votes
4answers
710 views
What is the recommended way to query data on a Sharepoint site?
Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?
3
votes
3answers
355 views
How to create a site collection
I need to create a site collection so that url looks like http://hr.mycompany.com instead of http://portal.mycompany.com/hr. How do I do that?
3
votes
2answers
2k views
Powershell: Update People Picker Field with domain\Username
I'm trying to get this to work in powershell:
$spListItem[$ppField] = "domain\username"
$spListItem.Update()
This gives me the following error:
Exception calling "Update" with "0" argument(s): ...
3
votes
2answers
2k views
What's wrong with Uninstall-SPSolution and AllWebApplications parameter?
When I try to uninstall WSP with following line, everything is ok:
Uninstall-SPSolution project.wsp # no error - OK
When I try to add switch parameter -AllWebApplications, I get error (something ...
3
votes
4answers
1k views
Remote Access to SharePoint Lists with PowerShell
I have a PowerShell script that pulls data from a database. I need to push this data to a SharePoint list on a different server.
Would you have tutorial or examples that show how to do this ...
