Blog Categories

Subscribe to RSS feed


Follow Microsoft Technologies on Pinterest

Upcoming Webinar: Integrate Lync with Your Avaya Environment

As Webinar_1part of the Lync 2013 integrated communications platform, Enterprise Voice, an enterprise class VoIP solution, includes various new features to enhance deployment, operational and user experience capabilities.

If you currently have an Avaya environment, and you are struggling with the question of how to make Lync work with your existing investments in telephony, you are not alone. Our Lync team works closely with many customers to integrate Lync with both Avaya and Cisco technologies (if you are interested in learning more about Lync/Cisco integrations, I highly recommend this on demand webinar). 

In this particular session, which will take place on Wednesday, December 3 at 1 p.m. CT, Best Practices for Integrating Lync with Your Avaya Environment, two of our Microsoft Certified Masters (MCM) on the Lync platform will help you understand how to build a strong telephony platform leveraging the power of Lync and backed by Avaya.

Keenan Crockett, a senior solutions architect and Lync team lead, and Jason Sloan, a lead technical consultant, will be covering a variety of topics, including:

  •  How to plan for audio conferencing
  • Click-to-call functionality
  • Lync softphone/hard phone options
  • Simultaneous ringing endpoints
  • Importance of voicemail
  • High-level understanding of Lync call admission control planning

We hope to “see” you there!

To register for the webinar, click here.
Best Practices for Integrating Lync with Your Avaya Environment
Wednesday, December 3, 2014
1:00 p.m. CT

Mac Solution for OneDrive For Business

I was recently involved in a discussion about the capabilities of OneDrive for Business for Mac, with my co-worker, Michael Toole. One of his customers was in the process of migrating network shares over to SharePoint. Majority of their user base was on Mac, and had very little experience with the web UI’s, so OneDrive sounded like a default choice for syncing their files to local machine.

In this post, I share our experience and findings for a quick and easy way to address the sync problems on Mac (I’ll share the credit for this post with Michael).

Currently OneDrive for Business does not have a sync client for Mac. It’s on the roadmap for later this year or early 2015 although expect it to be released with limited functionality such as only personal site sync (no team site). In the meantime there are few third party apps which does the same. There is an app currently available in the iTunes app store but only works if you have a SharePoint Online or qualifying Office 365 business subscription. Else, look at using Microsoft Document Connection for Mac.


This allows you to connect the libraries to your Mac in a very similar way as the windows explorer view on Windows. Although document connection does not support offline access.


To get around that limitation, download files to the local device. When the Mac OS is offline, you’ll be able to make any changes using the local Office applications. Once the Mac has a network connection, saving the updated documents to the Document Connection is available. It’ll also respect your check in and check out (read as exclusive check out). So, check out your document while you are online. Make changes while offline, and then check in back to the library when connected. Items also cannot be saved directly to OneDrive for Business through Document Connection. Newly created files on the Mac need to be stored locally and then uploaded to the system.

Spread out your files across multiple document libraries instead of folders in the same location. OneDrive for Business does not allow specific folder sync, but do allow sync across multiple libraries. In short try to go for flat structure across multiple libraries rather than the traditional folder structure.

It’s not the most convenient way when compared to windows, but might be the best way until the public beta for OneDrive for Mac releases next year.

Office 365 – Assign Licensing “User Location” via Active Directory

The first time you assigned an Office 365 license to a user, you likely used the portal as opposed to PowerShell. There’s also a good chance you saw the error message below:

Organizations populate Active Directory user objects with varied amounts of data. In many organizations, especially global organizations, the “Country” field is populated in Active Directory. It would seem logical if I’m using DirSync / AADSync and I have “Country” populated on-premises, then Office 365 should know “Country” as well.

So why are we getting this error?
Read the rest of this post »

The Top 5 Reasons Why Content Strategy Matters

Something happened while we were all madly getting websites up and running. They evolved. At the same time sites evolved, users expectations evolved as they wanted more than just a simple site. Users recognized the value of sites that provide content. They began to visit sites that were less about mass marketing and more about giving you something in return for their time.

Top 5 Reasons Why Content Strategy MattersSmart marketing and site administrators understood this and changed the way their sites worked.  Start-ups with limited budgets focused on their passion as a replacement for marketing dollars. Larger organizations realized that their ROI in digital marketing was directly related to the quality and the message. All of that drives the top 5 reasons why a content strategy matters:

  1. Users base their buying decisions on research
  2. They trust those who bring value over those who bring a pretty picture
  3. Engaged users result in repeat customers
  4. Good content drives better search results
  5. You can achieve more return on your marketing investment with a good content strategy (regardless of how many ads you guy on Google, Facebook, or elsewhere.)

All that said, what makes a great content strategy? Well, it comes down to a number of things. I’ll give you a short list with a promise to let you see them in a larger context in our 10 Content Strategy Steps to Drive an Effective Personalized Digital Experience guide.

  1. Take a holistic approach. Look at your entire universe of content and tools
  2. Use segmentation to drive personalization
  3. Understand your content and their content types. They matter
  4. Create the right content
  5. Support multiple channels including mobile (but not just limited to this buzzword of the day)
  6. Know what your customers are doing on your properties
  7. Test early and test often for best results
  8. Understand the best authoring model for your company
  9. Use communities for content
  10. Think Strategically  (Last but not least)

Yammer Sign-in Now Tied with Office 365

Keeping up with the roll out momentum, Microsoft released a significant feature last week which allows you to use your existing Office 365 credentials to access Yammer. It essentially provides the same experience as when using OneDrive for Business, Outlook, and SharePoint.

yammer signin


Here are some facts which will help you understand what’s covered in this release:

  • The easiest way to know when this is coming to your tenant is to check the announcement in the Office 365 message center (if your tenant fulfills the requirements). Expected rollout is slated to start in December. The global menu will change and Yammer will be included and styled as the other Office 365 services. e.g. Outlook or SharePoint.
  • This feature will support many of the scenarios previously covered with Yammer SSO, but it doesn’t cover DirSync. Yammer DirSync will still be required. Microsoft is continuing to invest in Azure AD integration and have plans that cover Dirsync in the future. Note that some of the Yammer SSO scenarios are not yet covered with Office 365 login. These scenarios are covered in the documentation here.
  • When you connect to Yammer, you’ll be routed to the Microsoft login screen, enter your credentials there and then you would be redirected to your company’s ADFS server for authentication. You will be then redirected back to Yammer after ADFS authentication.
  • If the email address used to create a Yammer account is not part of your Office 365/AAD account, then the account won’t be mapped and you will continue to login using Yammer login.
  • Longer term as Microsoft continue to deepen the Yammer, Office 365, and Azure Active Directory integration, expect Office 365 active directory sync, Yammer DirSync and O365 DirSync be combined in the future.
  • A new option to synchronize from Azure AD (rather than on-premises AD) is on the backlog.


Hopefully you are as excited as I am with this announcement; Happy Yammering!!


Troubleshooting Search in SharePoint Online (O365)

SharePoint-logoSharePoint makes great use of its Search engine and it is pervasive throughout most SharePoint solutions today. Whether you are building Content Search WebParts leveraging Display Templates or creating a custom Search center you will be making use of SharePoint’s powerful and mature Search engine. However, what happens when things behave unexpectedly? How can you troubleshoot Search? This article will focus mainly on SharePoint Online (O365) but could also be applied to Search on premises.

Search is not magic!

When supporting others in their troubleshooting of Search issues I usually start by explaining that Search is not a black art. I would agree there are nuances but, for the most part, figuring out issues can follow simple scientific process. After all, SharePoint Search is just a collection of properties stored for query and retrieval by the Search engine.

The perception that Search is a black art often extends to users and their expectations. When search does not yield the results a user expects we should always investigate what they expect and why they expect it. Work directly with end users and try to help them understand why they are not getting what they expect.

Approach to Troubleshooting

Generally speaking it is advisable to try and make small but smart moves when changing configuration. It can sometimes take days or weeks to test the results of your configuration changes if long re-crawls are required. Above all, be scientific! Use the same test cases before and after changes and measure your results by tracking search results before and after.

The two sides of Search

There are two sides to Search, Crawl and Query. Potentially either side could be failing or not working as expected so it is important to investigate both.

SharePoint Online in O365 does not currently offer too much control nor insight into the Crawl side (this may change in future). SharePoint 2013 on premises offers lots of opportunity to troubleshoot the crawl. On premises we can:

  • Inspect the crawl log
  • Turn on verbose logging during crawls
  • Attach crawls to Fiddler

The Query side can be inspected almost equally online as it can be on premises. It’s important to understand that Search queries are transformed as they are passed to the search engine. The user can type a query into a search box but there are number of places the query could be transformed or results influenced by search configuration:

  • Search Results WebPart e.g. in a Search Center
  • Content by Search WebPart
  • Results Source
  • Query Rules
  • Synonyms

Inspect the Query using the Query Builder

There are at least two great ways to inspect the Query side of Search.

One, use the OOTB Query Builder to help you. From a Content by Search or Search Results WebPart you can open the Query Builder. Switch to Advanced Mode (you are most definitely Advanced now!) and then head over to the TEST tab. Once on the TEST tab click ‘Show more’ to see the full transformation of the query in the bottom text box (highlighted).


Seeing the full transformation of the query is important because there may well be transformations impacting results you had not thought of. In addition if any part of the query is using dynamic property values based upon the Page or User (e.g. {User.ProfileProperty}) these values will be expanded and displayed for inspection.

Inspect the Query using the 2013 Search Tool

The SharePoint 2013 Search Query Tool is now an essential part of my day-to-day work with SharePoint Search. It uses the REST API to retrieve results from SharePoint Search and can be used with SharePoint Online (O365) and On Premises SharePoint 2013.

The tool provides a fast, convenient and repeatable way to inspect Search results. A few tips for using this tool most effectively:

  • Be scientific! Use fixed queries, analyze results before and after configuration changes.
  • Turn off Trim Duplicates, it will be ON by default. Trimming duplicates can be really confusing when analyzing results, especially when you have repetitive test data in a system.
  • Ensure you are using the correct Results Source. By default this will be set to Local SharePoint Results. However, if custom Result Sources are in play be sure to set them in the tool. You will need the GUID identifying the Results Source, this can be obtained easily by browsing to the Results Source in SharePoint and grabbing the ID from the querystring.
  • Inspect the Rank values returned. The rank values will determine which results appear first. If any parts of the transformation use XRANK to boost results then this should be evident in the Rank value.

Check the basics

Are you writing valid Keyword Query Language (KQL)? SharePoint Search can only understand KQL and not syntax from other search engines such as Google, Solr, Westlaw, Lexis etc.

If the user is expecting a specific document to be returned has that document actually been indexed? This can be verified by performing a Path search e.g.:


On Premises you could also check the crawl log to see if the item hit an error during indexing.

If the search query is expecting to hit document body content you should also check that the source text is readable by the search engine. In the case of PDF documents, they will need to be OCR’d.

Managed Properties

It’s likely that Search is not behaving the way users expect due to Managed Property configuration. Managed Properties are really the backbone of the search engine and our greatest opportunity for customization. They are also our greatest opportunity to make mistakes in configuration. We need to check the Managed Property settings. This article does not fully explore Managed Property configuration but here are the basic settings we should consider when troubleshooting:

  • Searchable – Enables us to query against the content of the property, the content is stored in the full-text index. On premises we can also set the ‘Context’ of the property which will allow different weighting to be applied.
  • Queryable – Enables us to query directly against the property e.g. Title:Hines . Note that this is different to simply being included in the full text index.
  • Retrieveable – Enables us to retrieve the value of the property in search results. If a property is not retrievable it can sometimes be confusing when trying to inspect it using the search tool. The value may be Queryable and used in queries but not retrieveable so that we can inspect it.
  • Refinable – Means that it can be used in a search by refinement. Note that this is different to querying properties.
  • Sortable – Means that results could be sorted by this property.
  • Mappings – Managed Properties will be mapped to one or more Crawled Properties. This relationship is worth reading more about and the necessity to re-crawl after changing these values in important to consider. When more than one Crawled Property is selected be sure that the configuration is resulting

It’s really important during any Search project to have consistent and well-understood Managed Property configuration. At Perficient we often build a Managed Properties Specification which allows us to collaborate on how properties will be configured. In addition it is highly recommended to script Managed Property configuration so that Development, QA and Production environments are the same. It’s very easy to let this slip and have misconfigurations confuse you when testing across multiple environments. More on script deployment to O365:

OOTB Title Managed Property

The ‘Title’ Managed Property is probably the single greatest point of confusion I see in SharePoint Search projects. Looking at the Mapping configuration it is already apparent that it’s complicated.


Unfortunately the MetadataExtractorTitle has, in my opinion, only added to this confusion. If your users are relaxed about seeing an interpreted Title in search results then you will most likely not get feedback. However, it appears most users get confused about this and require us to troubleshoot exactly why their Title is not displaying as expected in Search results. In response to this, you can of course look at the Crawled Property ordering and try to determine exactly why the Title Managed Property is populated as such. However, if it transpires this is a major problem for users I would look into creating your own separate Managed Property for handling Title.

Low level Debugging

Detailed debugging during a crawl or query is reserved for SharePoint on premises. During a crawl we can turn on VerboseEx logging and analyze the detail of what’s happening during acquisition. This could point to a number of problems including communication with the source during a crawl or an issue with security trimming when querying.

If you need to pursue a Search support incidents with Microsoft it is most likely Microsoft will ask for VerboseEx log. The only caution with this is that VerboseEx will grow the logs very quickly so it’s recommended you ensure it is only enabled for a short period of time.

Good luck!

SharePoint Search does have its challenges but it is also extremely powerful and offers great patterns for surfacing content. We see it making its way into new areas and services in Office 365 all the time. Embrace it! I think it’s here to stay.

Video Comes to Office 365 and SharePoint Online

This week, Microsoft announced the release of an Office 365 Video Portal (see Office 365 Video ).

This is an exciting first step into an area of great demand and large potential. In the past, many larger enterprises purchased dedicated 3rd party solutions for the management of video content. Smaller organizations typically leverage You Tube.  SharePoint deployments at small and mid-size companies sometimes use native Video content types and/or custom solutions.

The Office 365 Video portal goes above and beyond SharePoint video content type in many important ways:

  • The Video Portal is somewhat akin to the “old school” SharePoint Document Center.  The Video Portal is a dedicated “home” Site Collection with support for securable “channels”.  Each channel can have completely independent permissions and administrators and is mapped to a unique site collection.
  • Uploaded videos are converted for playback on a variety of formats/media/qualities.  At playback time, the video portal dynamically adjusts the playback (every 2 seconds) to use the most appropriate format for the device/bandwidth conditions.
  • The original upload is managed in a SharePoint site collection (and incurs storage cost); the converted files are managed via Azure Media Services and do NOT result in additional storage charges
  • Videos will appear in Enterprise Search results and views are tracked in analytic reports.

Its important to note that this is a v1 product with the following areas for future improvement:

  • Playback is via Flash, not HTML 5.  This represents a large roadblock for Mobile device use.  Microsoft acknowledges this and HTML 5 support is clearly on the roadmap
  • Uploaded videos are limited to 2GB with larger limits (aka OneDrive consumer version) undoubtedly in the works
  • Videos live in their “host” site collection and are not  integrated across all tenant site collections via apps; simpler link sharing/embedding is possible
  • Extranet and/or Intranet use cases are not currently supported


Even with the v1 caveats, this will be a great value added for many Office 365 customers.  The feature can be enabled/disabled at the tenant level, so organizations will have time to evaluate the ROI and launch when appropriate.



Office 365 – How to Handle “Large Messages” During Migration

Exchange Online provides for a fair amount of flexibility; that said, there are a few aspects of the service that cannot be changed. These service restrictions are documented in the Exchange Online Limits for each of the subscription types.

One limitation that you may encounter when migrating to Exchange Online is the “Message Size Limit” of 25 MB. Depending on your current on-premises limit, mailboxes may contain messages that exceed 25 MB; these “large messages” will cause issues during your migration. Your first encounter with large message may be a result of the error “This mailbox exceeded the maximum number of large items that were specified for this request” during a mailbox move.

There are a number of methods to address large messages with each method causing a varied level of impact to your users. After determining that there are large messages in your environment, one of the first questions to answer is what do you want to do with them?
Read the rest of this post »

Hybrid Analytics in Healthcare with O365 & Power BI Webinar Recap

Last week, we had our Microsoft last business intelligence focused webinar of the year, “Hybrid Analytics in Healthcare: Leveraging Power BI and Office 365 to Make Smarter Business Decisions.”  Heidi Rozmiarek, Assistant Director of IT Development for UnityPoint Health, spoke, along with our Microsoft BI team, on implementing an analytics platform in a hybrid environment. WebinarReplay

First, the Perficient team covered architectural components and functions, architecture options including on premises, hybrid, cloud,  and delivery considerations. Next, Steven Gregor, a technical consultant on our Microsoft BI team, reviewed Power BI and its features, including the security model and client side Data Management Gateway, and then walked through a live demo.

Last, Heidi shared how her organization is architecting a successful analytics infrastructure using Microsoft technologies. She explained how UnityPoint Health is leveraging Microsoft’s BI stack to provide simple solutions for complex questions. Heidi shared how they built the solution, collected and cleansed the data, modeled the data, and visualize and report the answer. She wrapped up by sharing her organization’s plans to move further to a hybrid on-premises/cloud solution in the next few months. Read the rest of this post »

All About ‘Clutter’ – Home Run for Microsoft Office Graph

We all receive email that we may have signed up for (such as a blog posts, newsletter) and that isn’t exactly junk, but is less probable to get our attention. Clutter uses the intelligence of Office Graph to see how important (or unimportant) this email is to you. It learns over time your levels of importance, then uses that analysis to separate the clutter from other inbox items.  You can quickly scan the clutter, mark individual items as “not clutter,” and take action on the rest of it, such as deleting it all. And if you don’t like the feature, you can turn it off.

Statement from office team – “Clutter learns from your actions to determine the messages you are likely to ignore,” . The underlying idea is quite simple: Microsoft wants to leverage the knowledge it gains about your daily work activities to automatically filter out emails that don’t immediately need your attention.

The flow works something like this : First emails considered as SPAM are rejected before its delivered to your mailbox. Then if a message lands in the inbox, it gets routed through the rules, and eventually Clutter does its magic. As a result, Clutter will get smarter over time, by learning your prior actions with similar messages, and determining the type of content and even how you are addressed in the message. This means the Clutter experience is personalized to each individual, based on their actions and their preferences.

Here is a two step process to turn ON Clutter for your Office 365 inbox. Remember it’s a individual user setting, and currently no way to automate the process for multiple users.



After turning ON Clutter, you should receive a welcome email similar to this


We’ve seen how you get this feature for your inbox, now let’s dig a bit deeper to understand the various facts which may help you.


  • Available to all SKU’s

  • Clutter works in all clients (in terms of moving messages to the clutter folder and learning from your behavior), though it currently requires OWA to turn it on.

  • Clutter is only a feature on individuals mailboxes.

  • Not available for Office 365 groups mailbox.

  • In order get the Clutter feature earlier, enable your Office 365 tenant to receive First Release.

  • It is an Exchange feature, not a client feature. That means in mobile or desktop no special client is required. They will see Clutter emails in their Clutter folder. The items will not show up in their Inbox. Clutter is available in all mail clients that can display and sync folders from your mailbox. i.e. Smartphones, tablets, etc.

  • If the user is not reading the Yammer notification emails, then Clutter will see that they are not important to that individual and will move them out of the inbox into the Clutter folder. You will need to drag the Yammer notification email into their Inbox folder, and then Clutter will learn that messages from Yammer are important and will leave them in your Inbox in future.

  • Clutter is a user preference feature, similar to electing to use conversation view. No current plans to add clutter specific admin controls, however Microsoft is looking at how to add broader tenant rollout controls.

  • Clutter is trained approximately once per day. Moving items out of Clutter is learned during the next training cycle.

  • You can train Clutter from your phone.

  • Clutter looks at the folders at the Exchange level, independent of client.

  • Clutter is only available in online version. It is not planned for next version of Exchange Server. Clutter requires rapid feedback to fine-tune the machine learning which isn’t possible in an on-prem deployment and also requires additional server processing resources that would impact the sizing for the on-prem server.

  • Q: What is the processing order between Junk Mail, Clutter and custom rules?
    A. Junk Mail first, then custom rules, then Clutter. (AFAIK)

    Q: Can we have a rule which force something to go to clutter / not go to clutter?
    A. Yes, but if you force a message into Clutter it won’t go through the Inbox and therefore won’t be considered as a signal for learning your preferences

    Q: Can we have a rule which operates on e-mail which does arrive in Inbox/Clutter only?
    A. All rules operate on inbound mail destined for the Inbox unless redirected by a rule. Clutter currently applies after all server-side rules. Clutter is not aware of client-side rules. There is a trick that allows you to force an item to not go through Clutter processing. You can create a rule which moves the item to a folder or your Inbox and Clutter won’t be processed on messages which that rule applies to. You can’t control the order in which rules and Clutter run. Today Clutter will always run after your last rule.

    Q: Can we create a rule and specify when it should be processed (before/after Junk Mail, before/after Clutter)?
    A. No

  • Q: I added clutter yesterday afternoon and now most of my mail goes to clutter?
    A: Check for – If you get a lot of circulars and non-personal email that could be regard as clutter. Possibly most email in your inbox was left marked unread before enabling Clutter

  • Q: Does Clutter learn from the Content / subject of an email to classify?
    A: Yes. Move the Internal communication email into Clutter and leave the Sales email in your Inbox and all will be well.

  • Rules vs Clutter

    If you want to apply that level of precision, use rules. Or turn them off to let Clutter do its stuff… but accept that all of the messages will go into a single folder.
    Clutter only learns from your choices, as everyone prioritizes their inbox differently.

  • Diff between JUNK and CLUTTER

    As an example Clutter can learn which internal distribution lists you read and which ones you don’t and will move the ones that you don’t read to Clutter. Junk Email doesn’t do that. You can think of junk email as being something that is not personalized – junk for one person is junk for others. Clutter on the other hand, is highly personalized – it’s the set that you tend to ignore, but others may not. junk is something that you really do not want to see in the future. Clutter is email that you will probably want to look at, but not as a high priority activity.

  • If you are one of those users who select multiple messages and mark them as read then clutter will not learn from any signal. You need to either leave messages unread or move them to Clutter folder (via drag drop or right click move to clutter) or yet delete them as unread to generate a clutter signal. Microsoft is looking at improvements for the model that will learn from users who mark everything as read.

  • If you are using Clutter nothing has populated the folder then try moving some messages to the Clutter folder and it should get signals.

  • Clutter only works on emails which are going to your Inbox. If a rule moves the email first then Clutter won’t move it or train on it later.


Source: Office 365 Community Network;; Office Blogs