O365 Export user profile data to a CSV file

Published on

If you need to export all your o365 user profile data to a CSV file you can use the following command: Get-MsolUser | Select-Object DisplayName,UserPrincipalName,Title,Department,StreetAddress,City,Country,Office,PhoneNumber,MobilePhone,PreferredLanguage | Export-Csv c:\userinfo.csv

O365: Restore ODfB from recycle bin

Published on

To restore a ODfB from the recycle bin use the following powershell command:   Restore-SPODeletedSite [-Identity] <SpoSitePipeBind> [-NoWait <SwitchParameter>]   Eg.   Get-SPODeletedSite -IncludePersonalSite or Get-SPODeletedSite – IncludeOnlyPersonalSite to return all the ODfB sites in the recycle bin.   Then to restore:   Restore-SPODeletedSite -Identity https://ABC-Corp-my.sharepoint.com/personal/fred_bloggs/          

List all SPNs in your Domain using Powershell

Published on

The below script lists all SPNs in your domain using Powershell (The service type is specified on the 1st line, in this case it is returning all HTTP SPNs): This & other useful powershell scripts can be found here Useful Powershell Scripts

Sharepoint: Removing illegal characters from filenames prior to bulk uploading

Published on

If you are doing a migration from a filesystem to Sharepoint you will more than likely come across problems uploading documents to Sharepoint that contain illegal characters in their filenames. In Sharepoint the following characters are classed as illegal characters – & ” : * ? # {} % ~ / Tab The + character … Continue reading Sharepoint: Removing illegal characters from filenames prior to bulk uploading

Sharepoint 2010 One Way Trust users on the trusted domain do not return any search results

Published on

If you have you Sharepoint 2010 Farm setup in one domain & your users are in a seperate domain using a one way trust, when they perform a search they will not return any search results. This is because the account running the app pool for the search query service is running using a domain … Continue reading Sharepoint 2010 One Way Trust users on the trusted domain do not return any search results

Sharepoint 2010: Create site from site template where alternate CSS url is set – unexpected error occured accessing site settings

Published on

When you create a site template in Sharepoint 2010 where the template is taken from a site that has an alternate CSS url set, you find on the newly created site that when you try & access ‘Site Settings’ or ‘View all site content’ you get the ‘An unexpected error occured’. In your logs you … Continue reading Sharepoint 2010: Create site from site template where alternate CSS url is set – unexpected error occured accessing site settings

Sharepoint 2010: Adding a new managed account from different domain errors with access denied

Published on

For example you are running Sharepoint 2010 in the a 1 way trust environment & you want to add a new managed account to your Sharepoint farm from your internal domain. This should be fairly simple by going Central Admin –> Security –> Configure Managed Account –> Register Managed Account User name: domainaccountname Password: ********* … Continue reading Sharepoint 2010: Adding a new managed account from different domain errors with access denied

Sharepoint 2010 – Cannot delete service application from Central Admin

Published on

When trying to delete a service application in Sharepoint 2010 from the central admin, sometimes you will find it just stays on the ‘processing’ window for hours (if you wait that long). If it does you can try & delete the service application using Powershell: If that command doesnt work you can force the deletion … Continue reading Sharepoint 2010 – Cannot delete service application from Central Admin

SharePoint 2010 CU upgrade error – keyword not supported failoverpartner

Published on

When applying updates to your Sharepoint 2010 farm you may get the following error in the Sharepoint Configuration Wizard: An exception of type System.ArgumentException was thrown. Additional exception information: Keyword not supported ‘failoverpartner’. This means youve got mirroring enabled on your Sharepoint databases and Sharepoint CU updates dont install on mirrored databases. To find out … Continue reading SharePoint 2010 CU upgrade error – keyword not supported failoverpartner

Sharepoint 2010 Service Application Database Trying To Connect To Different Database ID – Cannot complete this action as the Secure Store Shared Service is not responding

Published on

Had a strange problem when creating a new Secure Store Service Application, the wizard would complete but when you click ‘manage’ you would get an error saying – ‘Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator’ After looking at the event logs it was failing with … Continue reading Sharepoint 2010 Service Application Database Trying To Connect To Different Database ID – Cannot complete this action as the Secure Store Shared Service is not responding

Sharepoint 2010: The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service

Published on

When trying to publish a page or start a workflow you may get the following error: “The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service” To configure the State Service by using the Farm Configuration Wizard 1) On the Central Administration Web site, click Configuration … Continue reading Sharepoint 2010: The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service