http://www.u2u.net/res/Tools/CamlQueryBuilder.aspx
Camel Query tool to build queries or check field names.
http://www.u2u.net/res/Tools/CamlQueryBuilder.aspx
Camel Query tool to build queries or check field names.
Error when trying to send an email from PowerShell on Windows Server 2008 R2.
Client does not have permissions to send as this sender
At …………….
FullyQualifiedErrorId : SmtpException,Microsoft.PowerShell.Commands.SendMailMessage
Make sure your IP address is added to the SMTP relay service. My overly friendly Exchange Admin was able to add this to the box.
To validate an Attachment control in InfoPath 2010 you can do one of the following.
Using the controls properties:
Right click on the Attachment control.
Select File Attachment Properties.
In the Validation section, select Cannot be blank.
Click Ok
Test it.
Using a Rule:
(Assume you have a Submit button)
Click on your Submit button.
In the Ribbon, click on Manage Rules.
In the Rules window, click on New.
For the Condition, select your Attachment control, then select is blank or is not blank.
is blank = no attachment
is not blank = a file is attached
Ian Hayse
(this applies to MOSS / WSS 2007) Scroll to the bottom for a script that will work with SharePoint 2010.
How do you move all the fires from library A to library B?
Easy answer is to open both libraries in Explorer View and copy them over.
Doing this is quick and easy, but your metadata will be lost (if you care).
In my case I had to maintain the metadata when moving a bunch of files to a library in another site.
[System.Reflection.Assembly]::LoadWithPartialName(”Microsoft.SharePoint”) $siteUrl = "http://sharepoint" $webName = "" $spSite = new-object Microsoft.SharePoint.SPSite($siteurl) $spWeb = $spSite.OpenWeb($webName) $spList = $spWeb.Lists["Documents"] $listItems = $spList.Items $listTotal = $listItems.Count for ($x=$listTotal-1;$x -ge 0; $x--) { try { $listItems[$x].CopyTo("http://sharepoint/Docs/Documents/"+ $listItems[$x].name) Write-Host("DELETED: " + $listItems[$x].name) $listItems[$x].Recycle() } Catch { Write-Host $_.Exception.ToString() } } $spSite.Dispose $spWeb.Dispose$listItems[$x].Recycle() can be replaced with $listItems[$x].Delete()
I wanted to move the items to the Recycle Bin for safe keeping.If the file already exists in the destination library, the file will not be moved or deleted.
*if you wanted to deal with this scenario, you could simply create a new file name in the Catch event, and copy the file over.*Foreach does not work if are wanting to loop through the library and delete items.
UPDATE
In this example, I’m using a CAML query to find all documents created before 01/01/2014. This example will also process the items in batches, cutting down on server load. When working with CAML queries, be mindful of the ‘ and ” characters.
$web = Get-SPWeb "http://sharepointed.com/" $list = $web.Lists["Shared Documents"] $spQuery = New-Object Microsoft.SharePoint.SPQuery $spQuery.ViewAttributes = "Scope='Recursive'"; $spQuery.RowLimit = 2000 $caml = '<Where><Lt><FieldRef Name="Created" /><Value IncludeTimeValue="TRUE" Type="DateTime">2014-01-01T04:06:45Z</Value></Lt></Where> ' $spQuery.Query = $caml do { $listItems = $list.GetItems($spQuery) $spQuery.ListItemCollectionPosition = $listItems.ListItemCollectionPosition $listTotal = $listItems.Count for ($x=$listTotal-1;$x -ge 0; $x--) { try { $listItems[$x].CopyTo("http://sharepoint/Docs/Documents/"+ $listItems[$x].name) Write-Host("DELETED: " + $listItems[$x].name) $listItems[$x].Recycle() } catch { Write-Host $_.Exception.ToString() } } } while ($spQuery.ListItemCollectionPosition -ne $null)
In SharePoint 2010 I noticed I wasn’t receiving updates when people posted stuff on my MySite.
Turns out, my Active Directory Sync is not working, and my email account was not being populated in my User Profile.
Fix it!
Central Administration –> Manage User Profiles
Find the person having the issue.
Update the email address.
Cruise over to the mysite, post a note, look in your inbox for an email.
When trying to install SharePoint Designer 2010 on my PC, I ran into an error saying Designer 2007 was installed on the box.
The problem was, I had SharePoint Designer 2007 installed, and it’s a 32-bit install. When I tried to uninstalled Designer 2007 I was getting this error:
The language of this installation package is not supported by your system
No matter what google-related-fix I tried, I couldn’t uninstall it.
What I did to fix things:
Installed Office 2007
Installed Designer 2007
Uninstalled Desinger 2007
Uninstalled Office 2007
Then I was able to install SharePoint Designer 2010.
In SharePoint 2010 or 2007 I wasn’t able to find the size of the Content Databases. For some reason I thought it was displayed in Central Administration, wrong.
Log into one of your SharePoint servers.
Open PowerShell and paste the below code into the PowerShell window.
Run.
[Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") | out-null
$prop_Name = [Microsoft.SharePoint.Administration.SPContentDatabase].GetProperty("Name")
$prop_DiskSizeRequired = [Microsoft.SharePoint.Administration.SPContentDatabase].GetProperty("DiskSizeRequired")
$prop_Sites = [Microsoft.SharePoint.Administration.SPContentDatabase].GetProperty("Sites")
[Microsoft.SharePoint.Administration.SPFarm]::Local.Services |? {
$_.GetType().FullName -eq "Microsoft.SharePoint.Administration.SPWebService"
} |% {
$_.WebApplications |% {
$_.Name
$_.ContentDatabases |% {
$prop_Name.GetValue($_, $null)
$prop_DiskSizeRequired.GetValue($_, $null) / 1GB
}
}
}
The output will be:
Web App
Content Database Name
Content Database Size in Gigs.
You can change the output displayed size to MB by updating:
$prop_DiskSizeRequired.GetValue($_, $null) / 1GB
$prop_DiskSizeRequired.GetValue($_, $null) / 1MB
From one day to the next my Crawl Log went to all *%&%&$.
On every item that was being crawled, a message of The parameter is incorrect was being returned.
I was shocked that this fixed it, but it did!
Central Administration > Operations > Services on Server > Office SharePoint Server
Search Service Settings
I updated the Contact E-mail Address with a new email address, entered the Farm Search Service Account password, and clicked OK.
Fired off a Crawl, and everything was back to normal.
Recently had the Office SharePoint Server Search service get stuck in a Stopping status.
Central Administration > Operations > Services on Server
Things I tried that DID NOT work:
1. Rebooting the server.
2. taskkill.exe /F /IM mssearch.exe /T
3. Disable the Office SharePoint Server Search Service
Reboot
Start the Office SharePoint Server Search Service
What DID WORK:
Logged into the server using one of the Farm Admin accounts.
Ran this command: stsadm.exe -o osearch -action start
This stuck on Stopping issue appears to be a common problem. Some people can resolve the issue by rebooting the server, while others have to run the SharePoint config wizard. Hope my quick fix helps.