Export SQL query to CSV

1. Execute your Query with "Results to Grid" option selected (You can select this option with its icon or by menu "Query - Results To - Results to grid"). 2. Once your Query has finished, right-click on the results grid and select the option "Save results As...". 3. Save as Type: CSV.

Retrieve User Profile Properties using Client Object Model in SharePoint 2013

I've found an interesting link about how to retrieve some properties of user profiles in SharePoint 2013 by using its client object model, like this: const string serverUrl = "http://serverName/"; const string targetUser = "domainName\userName"; ClientContext clientContext = new ClientContext(serverUrl); PeopleManager peopleManager = new PeopleManager(clientContext); string[] profilePropertyNames = new string[] { "PreferredName", "Department", "Title" }; …

Sigue leyendo Retrieve User Profile Properties using Client Object Model in SharePoint 2013