Requirement Query AD [Active Directory] computers and insert into SQL Express. Considerations Requirement is just an one liner. We need to consider a lot before we deliver this to production. Do we need all computers from AD or just enabled? Yeah! We need only enabled computers. If Admin disables / enables a computer or remove […]
Exploring LYNC Contact folders using PowerShell. Get-MailboxFolderStatistics will display all the folders information in users mailbox. So using this we can explore LYNC Contacts with the folder type ‘Quick Contacts’. Get-MailboxFolderStatistics -Identity <MailboxID> | ? {$_.FolderType -eq ‘QuickContacts’} Lync Contact Folders with 0 Entries If we delete lync contacts programmatically it may appear as GUID […]
Summary Regular Expression is very Powerful and best way to play with strings. Using REGEX in PowerShell is best way to query log files, pattern matching etc.., however we should use it as applicable. Example Code #Given Name : Chendrayan Venkatesan #Required Output: Venkatesan , Chendrayan “Chendrayan Venkatesan” -replace “([a-z]+)\s([a-z]+)” ,’$2, $1′ #Given Name : […]
Summary This TechNet Wiki is to share PowerShell Snippet which retrieves Included OU in SharePoint 2010 User Profile Synchronization. Ensure you are farm admin while executing the script. Please do read the code and execute in acceptance and then in Production. Background This morning we received some email alerts “Your Mysite is marked for deletion”. […]
One of our clients reported an issue while editing the home page of SharePoint portal. Error: “An Unexpected Error Occurred” Impact: Unable to save the changes made. Reason Provided by the customer: Power User tried to deactivate and activate the publishing feature. Team tried reactivating the publishing feature which caused more pain. The Navigation bar […]
PowerShell code to remove LYNC Contacts entries in Exchange Online. Code #Target MailboxID’s $MailboxNames = “TargetMailBoxID1” , “TargetMailBoxID1” #Any Exchange Admin ID with appropriate permissions $AdminID = “AdminID” #Fetch password as secure string $AdminPwd = Read-Host “Enter Password” -AsSecureString #Load the Exchange Web Service DLL $dllpath = “C:\Microsoft.Exchange.WebServices.dll” [Reflection.Assembly]::LoadFile($dllpath) #Create a Exchange Web Service $Service […]
We tried modifying the view in SharePoint 2010 using Designer 2010 and it’s corrupted! No option to delete the view ! Spin up your SharePoint Shell Management and execute the below code Start-SPAssignment -Global $SPWeb = Get-SPWeb $WebUrl $List = $SPWeb.Lists[$ListName] $View = $List.Views[$ViewName] #$view.ID $List.Views.Delete($View.ID) $List.Update() $SPWeb.Update() $SPWeb.Dispose() Stop-SPAssignment -Global Note: Ensure […]
On March 18, 2015 Metalogix organized and conducted a Road Show at Microsoft – Amsterdam. Title: SharePoint and Office 365 Road Map to the Cloud with the partnership of K2 , Wipro and Wortell. Contents How to drive adoption for Office 365 5 Things you need to know before migrating to SharePoint 2013, Onedrive for […]
One of my client requested for validating the list fields. The list is deployed as part of custom solutions. There is no big challenge doing it by inserting validation formula. However I took a quick look of PowerShell property to achieve the same. List Available in SharePoint 2010 Where Title is set to 255 and […]
One of my client requested a settings in SharePoint 2010 to avoid accidental deletion of Lists. Indeed we can recover it from Recycle Bin within 30 days, but they need to avoid deletion. Alternatively we can make a permission settings to avoid deletion. Let’s see how to do this using PowerShell. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue […]