Tuesday, 18 December 2012

How to get SP Users list with Groups by using script

1. First copy the below code and paste in notepad and save the file ext as ps1( Ex: Allusers.ps1)


$site = Get-SPSite http://abc1:8080/
$groups = $site.RootWeb.sitegroups
foreach ($grp in $groups) {$grp.name ; foreach ($user in $grp.users) {" " +$user.name} }
$site.Dispose()


2. Copy in c drive and open SharePoint 2010 Management shell as administrator and run the below command.

PS C:\Users\Administrator> C:\Allusers.ps1 > C:\Userlist.txt


Then the script will run and you will get Site Users list with Groups in Userlist txt file.

For Ref  i am keeping screen shots below.



Wednesday, 17 October 2012

Creating PST in Outlook 2010

In the top left of Outlook, click on “File”.
image
Click on the Account Settings drop down, and then click “Account Settings…”
image

In the window that pops up, click the second tab “Data Files”
image
Click on the “Add…” icon, and then give your PST file a name (they call it “Outlook Data File, which makes much more sense to end users), choose where it goes, and then hit “OK”.  By default in Windows 7, it goes into your My Documents folder into a folder called “Outlook Files”. 
I’m not sure what Outlook 2010 does on earlier versions of Windows, but Outlook 2007 and earlier defaulted to C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Outlook.  I know that because I used to have a job upgrading PC’s in a large enterprise to Windows XP, and I had to manually move over the PST files that people forgot to back up.  That path is burned into my brain :)
image
Close the Account Settings window, and you will be back to the main Outlook window.  Your new PST (Outlook Data File) will be over on the left, and you can create new folders and drag mail into them (or setup rules).

image

Friday, 5 October 2012

Create, edit, or delete a content source


To get to the Manage Content Sources page

  1. Verify that the user account that is performing this procedure is a service application administrator for the Search service application.
  2. On the Home page of the SharePoint Central Administration Web site, in the Application Management section, click Manage service applications.
  3. On the Manage Service Applications page, click Search Service Application.
  4. On the Search Administration Page, in the Crawling section, click Content Sources.

 

To create a content source

  1. On the Manage Content Sources page, click New Content Source.
  2. On the Add Content Source page, in the Name section, in the Name box, type a name for the new content source.
  3. In the Content Source Type section, select the type of content that you want to crawl.
  4. In the Start Addresses section, in the Type start addresses below (one per line) box, type the URLs from which the crawler should begin crawling.
  5. In the Crawl Settings section, select the crawling behavior that you want.
  6. In the Crawl Schedules section, to specify a schedule for full crawls, select a defined schedule from the Full Crawl list. A full crawl crawls all content that is specified by the content source, regardless of whether the content has changed. To define a full crawl schedule, click Create schedule.
  7. To specify a schedule for incremental crawls, select a defined schedule from the Incremental Crawl list. An incremental crawl crawls content that is specified by the content source that has changed since the last crawl. To define a schedule, click Create schedule.You can change a defined schedule by clicking Edit schedule.
  8. To prioritize this content source, in the Content Source Priority section, on the Priority list, select Normal or High.
  9. To immediately begin a full crawl, in the Start Full Crawl section, select the Start full crawl of this content source check box, and then click OK.

 

To edit a content source

  1. You can edit a content source to change the schedule on which the content is crawled, the crawl start addresses, the content source priority, or the name of the crawl. Crawl settings and content type cannot be changed when editing a content source.
  2. On the Manage Content Sources page, in the list of content sources, point to the name of the content source that you want to edit, click the arrow that appears, and then click Edit.
  3. After you have made the changes that you want, select the Start full crawl of this content source check box, and then click OK.

 

Delete a content source

  1. On the Manage Content Sources page, in the list of content sources, point to the name of the content source that you want to delete, click the arrow that appears, and then click Delete.
  2. Click OK to confirm that you want to delete this content source.

Sunday, 16 September 2012

Configure State Service

  1. On the Start menu, click All Programs.
  2. Click Microsoft SharePoint 2010 Products.
  3. Click SharePoint 2010 Management Shell.
  4. To create a service application, type the following command:
    $serviceApp = New-SPStateServiceApplication -Name "<StateServiceName>"
    (Where <StateServiceName> is the name for the service application)
  5. To create a State Service database and associate it with a service application, type the following command:
    New-SPStateServiceDatabase -Name "<StateServiceDatabase>" -ServiceApplication $serviceApp
    (Where <StateServiceDatabase> is the name of the State Service database to create and associate with the service application.)
  6. To create a State Service application proxy, associate it with the service application, add it to the farm's default proxy group, and type the following command:
    New-SPStateServiceApplicationProxy -Name "<ApplicationProxyName>" -ServiceApplication $serviceApp -DefaultProxyGroup
    (Where <ApplicationProxyName> is the name of the application proxy.)

Monitoring the State Service

Administrators can monitor the State Service by using the SharePoint Monitoring and Event reporting service. Monitoring the service can help confirm the service was properly configured and can also identify any configuration or setup issues associated with the service.
For more information about how to monitor performance of the State Service, see Health monitoring (SharePoint Server 2010).

Tuesday, 11 September 2012

Installation steps for PowerPivot

Infrastructure

Firstly my SharePoint 2010 farm consists of 3 SP Servers and 2 SQL Servers in the following configuration
1 x SP2010 App Server
2 x SP Web Front End Servers
2 x SQL 2008 R2 Server in a failover cluster

Installation

You need to have SQL Server 2008 R2 to install PowerPivot and this process assumes you already have SharePoint 2010 setup and therefore a functioning installation of SQL 2008 R2
Log into the SharePoint 2010 central admin server as a farm administrator
Insert the SQL setup disk and run the setup.exe file
Click the Installation option on the left had side and then select New installation or add features to an existing installation
image
Let the install run through setting up any product key, licence acceptance and support files screens
At the Setup Role screen select SQL Server PowerPivot for SharePoint and select your existing farm installation and click Next
image
Click Next on the Feature Selection screen (this is read only and for information only)
Setup will now run a rule check, if you get any errors you need to resolve these before you can continue
image
Name the instance of SQL and select a location to install to and click Next
image
Check the installation locations and click Next
image
Select an account to run the Analysis Services and click Next
image
At the next screen select users who you want to have administrative privileges to analysis services and also check the locations for the data directories and click Next
image
Click Next on the Error Reporting screen
Setup will run another rule check, correct any errors and click Next
On the summary screen click Install
image
You may need to restart the computer after the installation but apart from that its all done

Deploy SharePoint PowerPivot Solutions

There are 2 solutions associated with PowerPivot
In central admin navigate to System settings | Manage Farm Solutions
image
The powerpivotfarm.wsp file is automatically deployed to the farm and doesn’t need to be touched
The powerpivotwebapp.wsp is deployed to the central admin server but you will need to deploy this to any web application that you want to use PowerPivot

Required Services

For PowerPivot to work you need to have the following services running
  • Excel Calculation Services
  • Secure Store Service
  • Claims to Windows token Service
To start these services navigate to System Settings | Manage Services on Server
image
Check the services are started and if not click on Start

PowerPivot Service Application

You now need to create a PowerPivot service application to do this navigate to Application Management | Manage Service Applications and click New from the ribbon
image
Select the SQL Server PowerPivot Service Application
image
In the window enter the details required for name etc and click OK
After a while you should see this
image

Excel Services

Firstly check to see if you have Excel Services enabled by seeing if it is listed in the Service Applications section of central admin
If not then you will need to enable it
To enable Excel Services follow the steps above but select Excel Service Application
image
From this window enter the details for the application and click OK
Once the setup has completed it should be listed as below
image

Secure Store

Start the Secure Store Service from the Manage Services screen
Navigate to Application Management | Manage Service Applications
If there is no listing for a secure store then click on New and select Secure Store Service
Complete all the details and click OK
After a while you will get a confirmation screen, click OK
Scroll down the screen and click on the Secure Store Service Application and click on Manage
image
Click on Generate New Key and complete the details
You now have a Secure Store Service setup

Enable PowerPivot For Site

Navigate to the site you want to enable PowerPivot for and go to Site Settings
In site settings open Site Collection Features and active the feature
image
You can check that the feature is enabled by going to Site Actions | More Options
image
In the libraries section there should be some PowerPivot items

 

 

 

 

How to Create Personal View

How to Create Personal View

1- Go to the List or Library that you want to create a view in.
2- In the ribbon at the top pick "Library" or "List"
3- Click the "Create View" button
4- Now you can pick what type of view you'd like. You can copy an existing view that you just want to tweak without changing the original view, or you can create one of these formats:
  • Standard View
  • Calendar View
  • Access View
  • Datasheet View
  • Gantt View
  • Custom View in SharePoint Designer

Let's say for example, that you just want a standard view, so you click on Standard view.  Now you need to think about some things:

  1. I'd Create a View, which I'll call "My Personal View"
  1. Need to select Personal view. 
  1. I'll choose the following columns to display: Task, Contact Person (Lookup), Contact Number, Due Date, Amount Due.....
  1. I'll specify that the view should group by 'Client Name'
  1. I'll specify that the view should include a total on Amount Due
  2. I'll add a filter for "Assigned To = [Me]"

  1. I don't have folders, so doesn't matter if I set folders to show up or not.
  1. I'll sort by Due Date, ascending.
  1. I'll set Item Limit to 50, and disable paging. I just want to see the top 50.
  1. I want to be able to see this view on the go, so I'll leave Mobile enabled
  1. Click on Ok.

Saturday, 16 June 2012

How to configure PDF iFilter for SharePoint Server 2010 or Search Server 2010

Follow the steps below to install and configure PDF iFilter on SharePoint Server 2010 or Search Server Express 2010.
  1. Install PDF iFilter 9.0 (64 bit) from here.
  2. Download PDF icon file from pdf16.gif and copy at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES\.
  3. Add the following entry in docIcon.xml file, which can be found at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML.
    <Mapping Key="pdf" Value="pdf16.gif" /> 
  4. Add PDF file type on the Manage File Type page under Search Service Application.
  5. Open registry by executing regedit on the Start --> Run.
  6. Navigate to the following location:
    \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\
    14.0\Search\Setup\ContentIndexCommon\Filters\Extension 
  7. Right-click Extension, a menu will appear.
  8. Click New--> Key to create a new key for .pdf. See screen shot below:
  9. Enter .pdf and save key.
  10. Now add the following GUID in the default value as shown in the figure below.
    {E8978DA6-047F-4E3D-9C78-CDBE46041603} 
  11. If you are configuring SharePoint Server 2010, then restart Search service by executing the following command on the command line:
    net stop osearch 
    net start osearch 
  12. If you are configuring PDF iFilter on Search Server 2010, then restart the SharePoint Server Search 14 service as shown in the figure below:
  13. Perform incremental to include PDF files.
  14. PDF iFilter is successfully configured. Now you can search for the content of PDF file. See screen shot below:
Note: SharePoint Server 2010 or Search Server 2010 Express provides out of the box search support for .ZIP files, so you download and have to install Microsoft Filter pack as you used to do with MOSS 2007.

Wednesday, 28 March 2012

If Alternate access mapping not worked properly

CMD -> Regedit -> Hkeylocal -> System -> Ctrl -> LSA(Right Click on it) -> New Dward 32 bit -> Create name like (Disable loop backcheck) -> Right click on it and modify -> Valuedata =1 and click on ok.

Then try again