Find all ContentByQueryWebPart from both (Site & Publishing ) pages using PowerShell

#Add-PSSnapin Microsoft.SharePoint.PowerShell

function Get-AllCQWPFromPage($WebAppName)
{
  $webapp = Get-SPWebApplication $WebAppName
  foreach ($site in $webapp.Sites)
  {
  foreach ($web in $site.AllWebs)        
  {
   #$web.URL
   if ([Microsoft.SharePoint.Publishing.PublishingWeb]::IsPublishingWeb($web))
    { 
     $pubWeb = [Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb($web)
     $pages = $pubWeb.PagesList
     $pubPages = $pubWeb.GetPublishingPages()                    
    foreach ($item in $pages.Items)
    {
      $fileUrl=$Web.Url+”/Pages/”+$item.File.Name
                 $pubPage = $pubPages.get_Item($Web.Url+”/Pages/”+$item.File.Name)
     
                     $spFile = $web.GetFile($fileUrl)
     if($spFile.Exists)
     {
      $wpmanager = $spFile.GetLimitedWebPartManager([System.Web.UI.WebControls.Webparts.PersonalizationScope]::Shared);
      $wpcolleactions = $wpmanager.webparts
      foreach ($wp in $wpcolleactions)
      {                            
       $type = $wp.GetType()                           
        if ($type.FullName  -eq “Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart”)
       {                           
        Write-Host “Webpart Name : ” $wp.Title              
       }
      }
     }                 
            $web.Update()        
                                                  }      
   }
      elseif ($web.WebTemplate -eq “STS”) #TEAM Site
   {
    $pages = $web.Lists["Site Pages"]             
     if ($pages)
    {               
     foreach ($item in $pages.Items)
     {                   
      $fileUrl = $pWeb.Url + $webUrl + “/” + $item.File.Url                                         
           $spFile = $web.GetFile($fileUrl)                    
           if($spFile.Exists)
       {
       $manager = $spFile.GetLimitedWebPartManager([System.Web.UI.WebControls.Webparts.PersonalizationScope]::Shared);
       $wpcolleactions = $manager.webparts
       foreach ($wp in $wpcolleactions)
       {                                                  
        $type = $wp.GetType()                          
        if ($type.FullName  -eq “Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart”) #-and ($wpcolleactions.Count -gt 0))
        {                           
         Write-Host “Webpart Name : ” $wp.Title
        }
       }
      }
     }
    }
       }    
  } 
   }
}

Get-AllCQWPFromPage “http://ServerName:999“

Setting Up the Development Environment for SharePoint 2010 on Windows Vista, Windows 7, and Windows Server 2008

Just follow 5 steps given in the below url, to setting up SharePoint 2010 Installation & Development enviroment.

http://msdn.microsoft.com/en-us/library/ee554869.aspx

 

Various kinds of user’s roles in SharePoint

A user can be play one of the following roles in SharePoint

1.Reader – Has read-only access to the Web site.
2.Contributor – Can add content to existing document libraries and lists.
3.Web Designer – Can create lists and document libraries and customize pages in the Web site.
4.Administrator – Has full control of the Web site.

User Control vs Custom Control in .NET

User Control:

• User Controls (.ascx) derived from System.Web.UI.UserControl
• Designed for single-application
• Deployed as .ASCX and source code of the application
• If the same control needs to be used in more than one application, it introduces redundancy and maintenance problems
• We have to use within the application and it rests in the application directory.

Eg:A much better choice when you need static content within a fixed layout, for example, when you make headers and footers

Custom Control:

• Custom controls derived from System.Web.UI.WebControls.WebControl or System.Web.UI.Controls
• Designed so that it can be used by more than one application
• Deployed either in the application’s Bin directory or in the global assembly cache
• Distributed easily and without problems associated with redundancy and maintenance
• we can keep it in the Toolbox and use it whenever we want

 More suited for when an application requires dynamic content to be displayed; can be reused across an application, for example, for a data bound table control with dynamic rows

InfoPath Forms vs. ASPX Pages in SharePoint Designer

Please look into below url for more info;

http://office12.blogspot.com/2007/06/infopath-web-forms-vs-aspx.html

SharePoint/MOSS 2007 Out of the Box Web Parts

SharePoint/MOSS 2007 provides several Out of the Box Web Parts that are ready to use with your site. You can use these built-in Web Parts, customize them to suit your needs, or create new Web Parts and upload them for use throughout your site.

1. Miscellaneous Web Parts
2. Publishing Web Parts
3. Outlook Web Access Web Parts
4. Search Web Parts
5. Content Rollup Web Parts
6. Site Directory Web Parts
7. Business Data Web Parts
8. Dashboard Web Parts
9. Filters Web Parts

Web Part	Description	Availability
		WSS 3.0		MOSS 2007 (Standard)				MOSS 2007 (Enterprise)
Miscellaneous Web Parts
Content Editor Web Part	Content Editor Web Part is used to add formatted text, tables, hyperlinks, and images to a web page in SharePoint site.	Yes		Yes				Yes
Page Viewer Web Part	Page Viewer Web Part is used to display a web page, file, or folder on a web page in SharePoint site. You enter either a hyperlink, file path, or folder name to link to the content.	Yes		Yes				Yes
Form Web Part	Form Web Part is used to connect to and filter a column of data in another Web Part. Both Web Parts must run on the site server.	Yes		Yes				Yes
Image Web Part	Image Web Part is used to add a picture or graphic to a web part page in SharePoint site.	Yes		Yes				Yes
List View Web Part	List View Web Part is used to display and edit list data in your site, and to connect to other Web Parts, including other List View Web Parts.	Yes		Yes				Yes
XML Web Part	XML Web Part is used to display Extensible Markup Language (XML) and apply Extensible Stylesheet Language Transformations (XSLT) to the XML before the content is displayed.	Yes		Yes				Yes
Data View Web Part	This web part is configured with SharePoint Designer. It can use a wide range of data sources including XML files, web services, SQL and Oracle databases and SharePoint list/library content. The rendering is XSLT driven with SharePoint Designer providing a drag-and-drop interface to generate the XSL.	Yes		Yes				Yes
Site Users Web Part	Use this Web Part to display or add a list of users and groups who have permission to use a site. The Site Users Web Part automatically appears on the home page of a Document Workspace site.	Yes		Yes				Yes
User Tasks Web Part	Use this Web Part to display tasks that are assigned to the current user of the SharePoint site. The Web Part displays tasks that have been assigned to the user within that particular SharePoint site.	Yes		Yes				Yes
Relevant Documents Web Part	Use this Web Part to display documents that are relevant to the user who is viewing a particular SharePoint site.	Yes		Yes				Yes
Members Web Part	Used to see a list of the site members and their online status.	Yes		Yes				Yes
RSS Viewer	Renders RSS Feed in a web page.	No		Yes				Yes
Summary Links	Displays links and description from site and it is rendered using XSLT.	No		Yes				Yes
Contact Details	Used to display details about a contact for this page or site.	No		Yes				Yes
Excel Web Access	Used to interact with an Excel 2007 workbook as a Web page. (Enterprise Feature)	No		No				Yes
Publishing Web Parts
Content Query Web Part	Displays items from any site in current site collection based on site, list, column criteria.		No		Yes			Yes
Outlook Web Access Web Parts
My Calendar	Use to display Outlook calendar within SharePoint site. This part works with Microsoft Exchange Server 2003 and above.		No			Yes	Yes
My Contacts	Displays your Outlook contacts within SharePoint site and it works with Microsoft Exchange Server 2007.		No			Yes	Yes
My Inbox	Displays your Outlook inbox within SharePoint site and it works with Microsoft Exchange Server 2003 or later.		No			Yes	Yes
My Tasks	Displays your Outlook tasks within SharePoint site and it works with Microsoft Exchange Server 2003 or later.		No			Yes	Yes
Search Web Parts
Search Box	Entry point for search.		No			Yes	Yes
Advanced Search Box	Entry point for advanced search.		No			Yes	Yes
People Search Box	Entry point for people search.		No			Yes	Yes
People Search Core Results	Web part to display the people search results.		No			Yes	Yes
Search Core Results	It displays relevant results for user’s search query.		No			Yes	Yes
Search High Confidence Results	It displays High Confidence results like keyword definitions and best bet links if there are any for the search terms.		No			Yes	Yes
Search Paging	Displays search paging.		No			Yes	Yes
Search Statistics	Displays search statistics.		No			Yes	Yes
Search Summary	Displays search summary.		No			Yes	Yes
Content Rollup Web Parts
Colleague Tracker	Displays your list of colleagues and any recent changes they made have had.		No			Yes	Yes
Memberships	Displays your site and distribution list memberships		No			Yes	Yes
My Links	Use to display your links		No			Yes	Yes
My SharePoint Sites	Use to display documents authored by you on sites where you are a member and sites of your choice.		No			Yes	Yes
My Workspaces	Displays sites created under your My Site.		No			Yes	Yes
Site Aggregator	Use to display sites of your choice.		No			Yes	Yes
Table of Contents	You use the Table of Contents Web Part to automatically generate a site map that point to various parts of your Office SharePoint Server 2007 site collection. You can specify which part of your site collection the Web Part should generate links to, how the links are presented, and how the links are organized.		No			Yes	Yes
Site Directory Web Parts
Categories	Displays categories from the Site Directory		No			Yes	Yes
Sites in Category	Displays sites in the Site Directory		No			Yes	Yes
Top Sites	Display the top sites from Site Directory		No			Yes	Yes
Business Data Web Parts
Business Data Actions Web Part	It is used to display a list of actions associated with an entity as defined in the Business Data Catalog.		No			No	Yes
Business Data Item Web Part	It is used to display the details of an entity instance from a business application.		No			No	Yes
Business Data Item Builder Web Part	It is used to create a Business Data item based on parameters in the query string and provides it to other Web Parts. This Web Part is used only on Business Data profile pages.		No			No	Yes
Business Data List Web Part	It is used to display a list of entity instances from a business application registered in the Business Data Catalog.		No			No	Yes
Business Data Related List Web Part	It is used to display a list of related entity instances from a business application.		No			No	Yes
Dashboard Web Parts
Key Performance Indicators	Shows a list of status indicators. Status indicators display important measures for your organization, and show how your organization is performing with respect to your goals.		No			No	Yes
KPI Details	Displays the details of a single status indicator. Status indicators display an important measure for an organization and may be obtained from other data sources including SharePoint lists, Excel workbooks, and SQL Server 2005 Analysis Services KPIs.		No			No	Yes
Filters Web Parts
Authored List Filter	Filter the contents of web parts using a list of values entered by the page author.		No			No	Yes
Business Data Catalog Filter	Filter the contents of web parts using a list of values from the Business Data Catalog.		No			No	Yes
Current User Filter	Filter the contents of web parts by using properties of the current page.		No			No	Yes
Date Filter	Filter the contents of web parts by allowing users to enter or pick a date.		No			No	Yes
Filter Actions	Filter Actions		No			No	Yes
Page Field Filter	Filter the contents of web parts using information about the current page.		No			No	Yes
Query String (URL) Filter	Filter the contents of web parts using values passed via the query string.		No			No	Yes
SharePoint List Filter	Filter the contents of web parts by using a list of values from a Office SharePoint Server list.		No			No	Yes
SQL Server 2005 Analysis Services Filter	Filter the contents of web parts using a list of values from SQL Server 2005 Analysis Services cubes.		No			No	Yes
Text Filter	Filter the contents of web parts by allowing users to enter a text value.		No			No	Yes

MOSS 2007 Limitations

Few limitations of MOSS 2007

1. 50,000 site collections per content database

2. 150,000 Site collection per Web application

3.250,000 websites  per site collection

4.2,000 subsites  per Web site

5.5 million documents per library

6.Document file size 50MB (2GB max*)

7.2,000 Lists per Web site

8.256 Field types per list

9.50 webparts per page

10.2 million users per Web site

SharePoint Object Model

SharePoint Architecture

Web Parts specific to WSS and MOSS 2007

Web Parts in common with WSSv3
Content Editor Web Part	Use for formatted text, tables, and images.
Form Web Part	Use to connect simple form controls to other Web Parts.
Image Web Part	Use to display pictures and photos.
Members	Use the Members Web Part to see a list of the site members and their online status.
Page Viewer Web Part	Use to display linked content, such as files, folders, or Web pages. The linked content is isolated from other content on the Web Part Page.
Relevant Documents	Use this webpart to display documents that are relevant to the current user.
User Tasks	Use this webpart to display tasks that are assigned to the current user.
XML Web Part	Use for XML, and XSL Transformation of the XML.
List View Web Part	A list view web part is provided for every list created in a site (a list template may include more than one view). The list view renderes the CAML markup defined in the view.
Data View Web Part	This web part is configured with SharePoint Designer. It can use a wide range of data sources including XML files, web services, SQL and Oracle databases and SharePoint list/library content. The rendering is XSLT driven with SharePoint Designer providing a drag-and-drop interface to generate the XSL.
Web Parts specific to MOSS 2007
Business Data (Enterprise CAL)
Business Data Actions	Display a list of actions from the Business Data Catalog.
Business Data Item	Display one item from a data source in the Business Data Catalog.
Business Data Item Builder	Creates a Business Data item from parameters in the query string and provides it to other web parts. This web part is only used on Business Data profile pages.
Business Data List	Display a list of items from a data source in the Business Data Catalog.
Business Data Related List	Display a list of items related to one or more parent items from a data source in the Business Data Catalog.
Content Rollup (Standard CAL)
Colleague Tracker	Displays your list of colleagues and any recent changes they made have had.
Memberships	Displays your site and distribution list memberships.
My Links	Use to display your links
My SharePoint Sites	Use to display documents authored by you on sites where you are a member and sites of your choice.
My Workspaces	Displays sites created under your My Site.
Site Aggregator	Use to display sites of your choice.
Table of Contents	You use the Table of Contents Web Part to automatically generate a site map that point to various parts of your Office SharePoint Server 2007 site collection. You can specify which part of your site collection the Web Part should generate links to, how the links are presented, and how the links are organized.
Dashboard (Enterprise CAL)
Key Performance Indicators	Shows a list of status indicators. Status indicators display important measures for your organization, and show how your organization is performing with respect to your goals.
KPI Details	Displays the details of a single status indicator. Status indicators display an important measure for an organization and may be obtained from other data sources including SharePoint lists, Excel workbooks, and SQL Server 2005 Analysis Services KPIs.
Other
Excel Web Access	Use the Excel Web Access to interact with an Excel 2007 workbook as a Web page. (Enterprise Feature)
I need to…	Displays tasks and tools from a list
IView Web Part	Displays iViews from SAP portal servers. (Enterprise Feature)
RSS Viewer	Renders RSS Feed
This Week in Pictures	Use to display the images library in the News web
WSRP Consumer Web Part	Displays portlets from web sites using WSRP 1.1. (Enterprise Feature)
Filters
Authored List Filter	Filter the contents of web parts using a list of values entered by the page author.
Business Data Catalog Filter	Filter the contents of web parts using a list of values from the Business Data Catalog.
Current User Filter	Filter the contents of web parts by using properties of the current page.
Date Filter	Filter the contents of web parts by allowing users to enter or pick a date.
Filter Actions	Filter Actions
Page Field Filter	Filter the contents of web parts using information about the current page.
Query String (URL) Filter	Filter the contents of web parts using values passed via the query string.
SharePoint List Filter	Filter the contents of web parts by using a list of values from a Office SharePoint Server list.
SQL Server 2005 Analysis Services Filter	Filter the contents of web parts using a list of values from SQL Server 2005 Analysis Services cubes.
Text Filter	Filter the contents of web parts by allowing users to enter a text value.
Misc
Contact Details	Use to display details about a contact for this page or site
Outlook Web Access
My Calendar	Use to display your calendar. This part works with Microsoft Exchange Server 2003 and above.
My Contacts	Displays your contacts using Outlook Web Access for Microsoft Exchange Server 2007.
My Inbox	Displays your inbox using Outlook Web Access for Microsoft Exchange Server 2003 or later.
My Mail Folder	Displays your calendar using Outlook Web Access for Microsoft Exchange Server 2000 or later.
My Tasks	Displays your tasks using Outlook Web Access  for Microsoft Exchange Server 2003 or later.
Search
Advanced Search Box	Entry point for advanced search
People Search Box	Entry point for people search
People Search Core Results	Web part to display the people search results.
Search Box	Entry point for search.
Search Core Results	Web part to display the search results.
Search High Confidence Results	Web part to display the special term and high confidence results.
Search Paging	Displays search paging.
Search Statistics	Displays search statistics.
Search Summary	Displays search summary.
Site Directory
Categories	Displays categories from the Site Directory
Sites in Category	Displays sites in the Site Directory
Top Sites	Display the top sites from Site Directory
Publishing
Content Query	Displays items from any site in current site collection based on site, list, column criteria