List sharepoint sites

List sharepoint sites DEFAULT

A list is a collection of data that you can share with your team members and people who you've provided access to. You'll find a number of ready-to-use list templates to provide a good starting point for organizing list items. Learn more at List templates in Microsoft 365.

This article explains the concepts behind creating and using lists. You can create lists in Microsoft SharePoint, the Lists app in Microsoft 365, or Teams. Learn to get started with Lists in Microsoft Teams.

See the following articles for information about lists:

Note: Note that the information here and the types of lists available to you depend on the version of SharePoint you are using. If you don’t know the version contact your administrator, help desk, or manager, or see Which version of SharePoint am I using?

Select a heading below to open it and see the detailed information.

Organizations typically use many types of lists, including links, announcements, contacts, issue tracking, and surveys, to name a few.

Lists can also include tasks that you can use as a focal point for team collaboration or in a business solution. In many cases, lists can provide quick, effective solutions with little or no modifications.

For example, you can use:

  • Tasks Include tracking of ownership and progress as well as an in-page timeline for an attractive visual presentation the list content.

  • Issue tracking Includes versioning and version-history storage, for deeper analysis of workgroup projects and common work tasks.

Lists are rich and flexible and have many built-in features that provide a robust way to store, share, and work with data.

For example, you can:

  • Create a list with a variety of columns, including Text, Number, Choice, Currency, Date and Time, Lookup, Yes/No, and Calculated. You can also attach one or more files to a list item to provide additional details, such as a spreadsheet containing supporting numbers or a document containing background information.

  • Create list views to organize, sort, and filter data in different and specific ways; change the metadata, such as adding and deleting columns, and modifying validation rules; and use lists consistently across sites with content types, site columns, and templates. For example, you can view just the current events from a calendar on a home page and create a visual view — similar to a wall calendar — on another page.

  • Create relationships between lists by using a combination of unique columns, lookup columns, and relationship enforcement (cascade and restrict delete), all of which enhance your ability to create more sophisticated business solutions and help preserve the integrity of your data.

  • Create custom lists, display the data in Web Parts and Web Part Pages, and import, export, and link to data from other programs, such as Excel and Access.

  • Track versions and detailed history, require approval to modify data, use item-level and folder security, check-in and check-out, and automatically stay informed about changes by using alerts and RSS feeds.

  • Organize content in a single list into folders for added convenience and better performance, and improve performance in general with large lists by using indexing.

The following are some ways you can work with lists to help you to manage information for your group.

Track versions and detailed historyTrack versions of list items, so that you can see which items have changed from version to version, as well as who changed the list items. If mistakes are made in a newer version, you can restore a previous version of an item. Tracking the history of a list is especially important if your organization needs to monitor a list as it evolves.

Require approvalSpecify that approval for a list item is required before it can be viewed by everyone. Items remain in a pending state until they are approved or rejected by someone who has permission to approve them. You can control which groups of users can view a list item before it is approved.

Customize permissions    Specify whether participants for your list can read and edit only the items they created or all items in the list. People who have permission to manage lists can read and edit all list items. You can also apply specific permission levels to a single list item, for example, if the item contains confidential information.

Create and manage viewsCreate different views of the same list. The contents of the actual list don't change, but the items are organized or filtered so that people can find the most important or interesting information, depending on their needs.

Update lists    Regardless of the type of list you are updating the process is similar for adding, editing, and deleting list items.

There are two ways to add or edit list items:

  • By using a form, which is the default method.

  • Inline, which means you add the item directly on the list page.

If the list is set up to track versions, a new version of the list item is created each time you edit a list item. You can view a history of how the list item has changed and restore a previous version if you make a mistake in a newer version.

Use formulas and calculated values    Use formulas and calculated values to dynamically generate information in the columns of a list. The operations can include information other columns in a list as well as system functions such as [today] to indicate the current date. For example, you can specify a default due date that is seven days from the current date.

Keep informed about changes    Lists and views can use RSS, so that members of your workgroup can automatically receive updates. RSS is a technology that enables people to receive and view updates or RSS feeds of news and information in a consolidated location. You can also create email alerts to notify you when the lists are changed or when new items are added. Alerts are a convenient way to keep track of the changes that are important to you.

Create list relationships    Create a relationship between two lists, in the source list, you create a lookup column that retrieves (or "looks up") one or more values from a target list if those values match the value in the lookup column in the source list. If you want, you can continue to add additional columns from the target list to the source list. When you create a lookup column, you can also decide to enforce relationship behavior by setting a cascade delete or restrict delete option that helps keep your data valid and helps prevent inconsistencies that might cause problems down the road.

Share list information with a database program    If you have a database program installed, such as Access, you can export and import data to and from your site, as well as link a table from the database to a list. When you work with your list data in an Access database, you can also create queries, forms, and reports. See Import data into an Access database.

Use lists consistently across sites    If your group works with several types of lists, you can add consistency across multiple lists with content types, site columns, and templates. These features enable you to reuse the settings and list structure in an efficient way. For example, you can create a content type for a customer service issue that specifies certain columns (such as customer contact) and business processes for the content type. Another example is creating a site column for department names that has a drop-down list of departments. You can reuse the column in multiple lists to ensure that the names always appear the same way in each list.

Work on list items from an email program    Use an email program that is compatible with Microsoft technologies, you can take important list information with you. For example, with Outlook, you can view and update tasks, contacts, and discussion boards on your site from Outlook. See Connect an external list to Outlook.

Set content targeting Enable audience targeting to filter items by groups.

The type of list that you use depends on the kind of information that you are sharing.

Announcements    Share news and status and to provide reminders. Announcements support enhanced formatting with images, hyperlinks, and formatted text.

Contacts    Store information about people or groups that you work with. If you are using an email or contact management program that is compatible with Microsoft technologies, you can view and update your contacts from your site in the other program. For example, you can update a list of all your organization's suppliers from an email program compatible with Microsoft technologies, such as Outlook. A contacts list doesn't actually manage the members of your site, but it can be used to store and share contacts for your organization, such as a list of external vendors.

Discussion boards    Provide a central place to record and store team discussions that is similar to the format of newsgroups. If your administrator has enabled lists on your site to receive email messages, discussion boards can store email discussions from most common email programs. For example, you can create a discussion board for your organization's new product release.

Links    Provide a central location for links to the Internet, your company's intranet, and other resources. For example, you might create a list of links to your customers' Web sites.

Promoted Links    Display a set of link actions in a visual layout.

Calendar    Store of your team's events or for specific situations, such as company holidays. A calendar provides visual views, similar to a desk or wall calendar, of your team events, including meetings, social events, and all-day events. You can also track team milestones, such as deadlines or product release dates that are not related to a specific time interval. See Create a calendar view from a list.

Tasks    Track information about projects and other to-do events for your group. You can assign tasks to people, as well as track the status and percentage complete as the task moves toward completion. If you are using an email or task management program that is compatible with Microsoft technologies, you can view and update your tasks from your site in your other program. For example, you can create a task list for your organization's budget process and then view and update it in Outlook along with your other tasks. See Create a list.

Project tasks    Store task information with a Gantt view and progress bars. You can track the status and percentage complete as the task moves toward completion. If you are using an email or task management program that is compatible with Microsoft technologies, you can view and update your project tasks from your site in your other program. For example, you can create a project task list on your site to identify and assign the work to create a training manual, and then you can track your organization's progress from Project. See Create a list.

Issue tracking    Store information about specific issues, such as support issues, and track their progress. You can assign issues, categorize them, and relate issues to each other. For example, you can create an issue-tracking list to manage customer service problems and solutions. You can also comment on issues each time you edit them, creating a history of comments without altering the original description of the issue. For example, a customer service representative can record each step taken to resolve a problem and the results. You can also use an Issue Tracking list with a Three-state workflow to help your organization manage issue or project tracking. See Create a list.

Survey    Collect and compile feedback, such as an employee satisfaction survey or a quiz. You can design your questions and answers in several different ways and see an overview of your feedback. If you have a spreadsheet or database program installed that is compatible with Microsoft technologies, you can export your results to further analyze them. See Create a survey.

Custom    Start a list from scratch. You can also create a custom list that is based on a spreadsheet, if you have a spreadsheet program that is compatible with Microsoft technologies. For example, you can import a list from Excel that you created to store and manage contracts with vendors. See Create a list based on a spreadsheet.

External lists    Work with data that is stored outside of a list, but that you can read and write within Microsoft 365. The data source for an external list is called an External content type. Unlike a native Microsoft 365 list, an external list uses Business Connectivity Services to access data directly from an external system (such as SAP, Siebel, and Microsoft SQL Server), whether that system is a database, Web service, or line-of-business system.

Custom list in Datasheet View Create a blank list similar to a custom list but to display the list by default in datasheet view. Datasheet view provides a data grid for viewing and editing data as rows and columns. You can add and edit rows and columns, apply filters and sort orders, display calculated values and totals, and conveniently edit data in the grid cells. Datasheet view requires Office installed on a 32-bit client computer and a browser that supports ActiveX controls.

Status list    Display and track the goals of your project. The list includes a set of colored icons to communicate the degree to which goals are met.

Circulations    Send information, including confirmation stamps, to your team members.

Microsoft IME Dictionary list    Use data in the list as a Microsoft IME dictionary. You can convert the Reading column items to Display using Microsoft IME and view the content in Comment in the IME Comment window. The data can be linked to a specific URL.

PerformancePoint Content List    Store dashboard items, such as scorecards, reports, filters, dashboard pages, and other dashboard items that you create by using PerformancePoint Dashboard Designer.

Languages and Translators    Use with a Translation Management workflow in a Translation Management Library. The workflow uses the list to assign translation tasks to the translator specified in the list for each language. You can create this list manually, or you can choose to have this list automatically created when you add a Translation Management Workflow to a Translation Management library.

KPI List    Track Key Performance Indicators which allow you to quickly evaluate the progress made against measurable goals. You can set up KPI lists to track performance by using one of four data sources: manually entered data, data in a Microsoft 365 list, data in Excel workbooks, or data from Analysis Services — a component of Microsoft SQL Server. After the KPI list is created, you can use it to display the status of the indicator on a dashboard page.

Import Spreadsheet     Use columns and data from an existing spreadsheet. Importing a spreadsheet requires Microsoft Excel or another compatible program.

To add a list to a SharePoint modern page:

  1. If the page is not already in edit mode, click Edit at the top right of the page. 

  2. Hover your mouse above or below an existing web part and you'll see a line with a circled +, like this:

    Plus sign for adding web parts to a page

  3. Click + and you'll see a list of web parts to choose from. Scroll down to the Documents, Libraries, and Lists section.

  4. Select List.

    The names of all the available lists are shown.

  5. Select the list that you want to insert on your page. 

  6. If you're satisfied, select Save as draft near the top left. Then, to make the updated page available to others, select Publish near the top right. 

To add a list to a SharePoint classic page:

  1. In Sites, click SettingsSettings: update your profile, install software and connect it to the cloud, and then click Site contents.

  2. Click the Add an app icon.

    The Add an app icon in the Site Contents dialog.
  3. Scroll through and click the app you want to use. There may be more than one page.

  4. Give the app a unique name so you can recall it later for a page, and click Create.

  5. When you get back to the Site contents screen, you can do three things:

    • Close the window and go back to the page. Add the new app on your page using Insert Web Parts.

    • Click the app and start entering data.

    • Click the ellipses ... and then click change Settings. You can add columns, change names, and do other tasks here.

Although you can use the features of lists in a variety of ways, how you use them depends on the size and number of lists you have and the needs of your organization.

Storing many items in one list

You may want one large list to serve diverse needs. For example, you might have a large number of technical issues to track across your organization, and the issues may apply to multiple projects and groups.

Use a single list when:

  • Your group needs to see summary information about the list items or different views of the same set of items. For example, a manager may want to see the progress on all technical issues for an organization or see all the issues that were filed within the same time period.

  • People want to browse or search for the issues in the same location on a site.

  • You want to apply the same settings to the list items, such as tracking versions or requiring approval.

  • The groups working on the list share similar characteristics, such as the same levels of permission. Unique permission can be applied to specific list items, but if the levels of permission vary greatly, consider multiple lists.

  • You want to analyze information about the list or receive consolidated updates for the list. You can receive alerts when the list items are changed or see the changes to a list by using RSS technology. RSS feeds enable members of your workgroup to see a consolidated list of information that has changed.

You may want multiple lists when there are distinct differences between the items that you want to manage or between the groups of people who work with them.

Use multiple lists when:

  • You don't expect people to need summaries of the items together.

  • The groups of people working with the information are distinct and have different permission levels.

  • You need to apply different settings, such as versioning or approval, to multiple sets of items.

  • You do not need to analyze the items together or receive consolidated updates about the list.

The following are some of the ways that you can organize lists and list items:

Add columns    Help your group pinpoint the items that are most important, you can add columns to your list. For example, you might add the Project column to a list to help people working on specific projects more easily view and work with their items. You may also want to add more columns if you want to collect additional information for each list item, such as the name of the department or the name of an employee.

If you have multiple items in a list, you may consider indexing certain columns to improve the performance when viewing several items or switching views. This feature doesn't change the way the items are organized, but it may enable organizations to more easily store a large number of items in a list. However, indexing can take up more database space. See Create, change, or delete a view of a list or library.

Create views    Use if people in your group frequently need to see data in a certain way. Views use columns to sort, group, filter, and display the data. You can also select how many items are displayed at one time in each view. For example, people can browse a list in sets of 25 or 100 list items per page, depending on their preferences and the speed of their connection.

Views give you the flexibility to store a large number of items in a list, but to see only the subsets that you want at a particular time, such as only the issues that were posted this year, or only the current events in a calendar. You can create personal views that are available only to you, and if you have permission to modify a list, you can create public views that are available to everyone. See Create, change, or delete a view of a list or library.

Create folders    Add folders to most types of lists, if your list owner has allowed folders to be created. This is especially helpful if your list items can be divided in a particular way, such as by project or by group. Folders help people to more easily scan and manage the list items. Microsoft technologies provide a tree view that enables people to navigate their sites and folders similar to the way that they work with the folders on their hard disk. For example, each department can have its own folder. See Create a folder in a list.

See Also

Add, edit, or delete list items

Enable and configure versioning for a list or library

Create a folder in a list

Delete a folder in a list

Sours: https://support.microsoft.com/en-us/office/introduction-to-lists-0a1c3ace-def0-44af-b225-cfa8d92c52d7

Manage sites in the new SharePoint admin center

The Active sites page of the new SharePoint admin center lets you view the SharePoint sites in your organization (including communication sites and sites that belong to Microsoft 365 groups). It also lets you sort and filter sites, search for a site, and create new sites.

Active sites page

Note

The Active sites page lists the root website for each site collection. Subsites, redirect sites (REDIRECTSITE#0) created by changing a site address or replacing the root site, and Microsoft Teams private channel sites (TEAMCHANNEL#0) aren't included in the list.
Some functionality is introduced gradually to organizations that have opted in to the Targeted release option in Microsoft 365. This means that you might not yet see some features described in this article, or they might look different.

For more info about tasks on the Active sites page, see:

Add or remove site admins and group owners

  1. In the left column, select a site.

  2. Select Permissions. For a group-connected team site, you can add and remove group owners and additional site admins. For other sites, you can add and remove site admins and change the primary admin. Note that if you remove a person as a primary admin, they will still be listed as an additional admin. For info about each role, see About site permissions.

Change a site's hub association

  1. In the left column, select a site.

  2. Select Hub. The options that appear depend on whether the site you selected is registered as a hub site, or associated with a hub. The Hub menu lets you register a site as a hub site, associate it with a hub, change its hub association, and unregister it as a hub site. More info about hubs

View site details

For more info about a site, select the site name to open the details panel.

The General tab of the details panel

To view site activity including the number of files stored and storage usage, select the Activity tab. Activity information is not available for Office 365 Germany customers and US Government GCC High and DoD customers.

To view site admins, owners, members, and visitors, select the Permissions tab.

The Permissions tab of the details panel

For info about the roles in this panel, see About site permissions.

Sort and filter the site list

Sorting and filtering the site list is just like sorting and filtering other lists in SharePoint.

  1. Select the arrow next to the column header.

  2. Select how you want to arrange the items. The options vary depending on the column. For example, you might have options to sort alphabetically, in numeric order, or chronologically.

    If the column allows filtering, a "Filter by" option appears. Select the value or values that you want to show. Your selections appear with a check mark beside them. To remove a selection, select that value again. To clear all filters on the column, select Clear filters.

    Filter options for the Primary admin column

Customize columns

  1. Select the arrow next to any column header, and then select Customize columns.

  2. To show and hide columns, select and clear check boxes.

  3. To rearrange the columns, point to a column, and select the up or down arrow to move the column up or down.

    The Customize columns panel

    Note

    Data in the following columns is not available for Office 365 Germany customers and US Government GCC High and DoD customers:

    • Last activity
    • File views or edited
    • Page views
    • Page visits
    • Files
    • Storage used

Switch views and create custom views

The new SharePoint admin center comes with a few built-in views: All sites, Sites connected to Teams, Microsoft 365 group sites, Sites without a group, Classic sites, Largest sites, Least active sites, and Most popular shared sites.

To select a different view:

  • On the far right of the command bar, select the Change view arrow next to the name of your current view, and then select a different view.

    The list of views

To create and save a custom view:

  1. Customize columns, sort, and filter your view the way you want. (Views that are filtered through search can't be saved.)

  2. On the far right of the command bar, select the Change view arrow next to the name of your current view.

  3. Select Save view as.

  4. In the Save as dialog box, enter a name for the view.

    Note

    To set the view as default, in the list of views, select Set current view as default.

Track a view

When you select a built-in or custom view, you can add a card to your home page that shows the number of sites in the view and summarizes info about the set of sites.

  1. Select the Change view arrow, and then select the view you want to track.

  2. Select Track view.

  3. Select Add card.

  4. Go to your home page to see the card for the tracked view.

    A tracked view card

Note

If you remove a tracked view card from your home page, you can't add it back from the Add cards panel. You need to open the view on the Active sites page and select Track view.

Search for a site

You can search for a site by name, URL, primary admin, or template. To do this, enter keywords in the Search box, and press Enter.

Note

Search doesn't look in hub site display names for the keywords you enter.
All characters you enter are treated as part of the query. Search doesn't recognize operators or wildcards (*).

Export to CSV

To export the site list you're viewing as a .csv file that you can work with in Excel, select Export.

Note

The .csv file lists the hub as a GUID and the template as an ID (for example, STS#0).

Sours: https://docs.microsoft.com/en-us/sharepoint/manage-sites-in-new-admin-center
  1. Sandusky cabinets parts
  2. Pond yachts plans
  3. Glutamine powder amazon
  4. Cute kawaii stationery
  5. Extreme graphics tattoo

View all site collections in SharePoint Server

APPLIES TO:yes2013 yes2016 yes2019 noSharePoint in Microsoft 365

A site collection is a group of websites that have the same owner and share administrative settings, for example, permissions, and quotas. Site collections are created within a web application. When you create a site collection, a top-level site is automatically created in the site collection. You can then create one or more subsites below the top-level site. The entire structure of the top-level site and all its subsites is called a site collection.

Learn about Managing sites in the new SharePoint admin center in Microsoft 365.

View the site collections in a web application

Use the following procedures to view all the site collections in a web application.

To view all site collections by using Central Administration

Refer to the following table in step 3.

ItemDescription
URLThe URL of the site collection.
TitleThe current title for site collection.
DescriptionThe current description for the site collection.
Primary administratorThe primary administrator for the site collection.
Email addressThe email address for the primary administrator.
Database nameThe content database that is used by the site collection.
  1. Verify that you have the following administrative credentials:

    To view all site collections, you must be a member of the Farm Administrators group on the computer that is running the SharePoint Central Administration website.

  2. Open Central Administration. On the Application Management page, in the Site Collections section, click View all site collections.

    The Site Collection List page lists all the site collections in the web application.

  3. To display more information about a site collection, in the URL column, click the site collection.

    The table just before this procedure appears on the right side of the page.

  4. If you want to change the selected web application, click the Web Application box, and then click Change Web Application. Use the Select Web Application page to select another web application.

To view all site collections by using Microsoft PowerShell

  1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.

  2. Open SharePoint Management Shell.

  3. At the PowerShell command prompt, type the following command, and then press ENTER:

    Note

    This command displays the URLs of all the web applications in a server farm and the site collections in each web application.

For more information, see Get-SPWebApplication and Get-SPSite.

We recommend that you use Microsoft PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.

See also

Other Resources

SharePoint planning guide

Sours: https://docs.microsoft.com/en-us/sharepoint/sites/view-all-site-collections
How to Create a Custom List in SharePoint Online

One thing that has been bugging me recently is being able to get a list of all my Office 365 SharePoint group sites all at once. With the new SharePoint Admin Centre due to be rolled out any time now, this will soon be a solved problem, but i just want a list of all the sites i’ve created now, should be simple right?

An easy way to get a list of all SharePoint Online/ Office 365 group sites

There are ways online to do this using PowerShell, but surely there has to be an easier way…here’s what I did:

  • Navigate to the Office 365 SharePoint group sites landing page
  • Click in the search bar – press enter to start a search
  • In the all results type filter – change to sites

Bingo! All of your SharePoint sites are now showing, you’ll notice that the classic sharepoint sites and Office 365 SharePoint group sites are both included in the results, which is exactly what I wanted.

Hope this is helpful for someone else 🙂

Like this:

LikeLoading...

Related

Sours: https://sharepointstuff.com/2018/04/16/get-a-list-of-all-sharepoint-sites-no-powershell/

Sites list sharepoint

Requirement: Get all site collections using PowerShell in SharePoint Online.

How to Get a List of Site Collections in SharePoint Online?

A site collection is a group of sites, generally organized by department, project, region, function, or business units. How to view all site collections in SharePoint Online? Well, If you want to get a list of SharePoint Online site collections, you can go to the SharePoint admin center >> Expand “Sites” >> Active Sites.

get all sites in sharepoint online

This gets you the list of all site collections in SharePoint Online. Let’s see the SharePoint online PowerShell to get all site collections.

PowerShell to Get All Site Collections in SharePoint Online:

Site collections are the primary objects in SharePoint Online. Use the Get-SPOSite PowerShell cmdlet to get a list of all site collections in the tenant. Here is the PowerShell to list all SharePoint Online sites.

#Load SharePoint Online Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Variables for Processing $AdminUrl = "https://crescent-admin.sharepoint.com/" $UserName= "[email protected]" $Password = "Password goes here" #Setup Credentials to connect $SecurePassword = $Password | ConvertTo-SecureString -AsPlainText -Force $Credentials = New-Object -TypeName System.Management.Automation.PSCredential -argumentlist $UserName, $SecurePassword #connect to the service Connect-SPOService -Url $AdminUrl -Credential $Credentials #sharepoint online get all site collections PowerShell $SiteColl = Get-SPOSite #sharepoint online PowerShell iterate through all site collections ForEach($Site in $SiteColl) { Write-host $Site.Url }

This PowerShell enumerate site collections in SharePoint Online and gets URL for each site.

How to Get All Site Collections in SharePoint Online using PowerShell?

Similar to On-Premises SharePoint Management Shell, You can also use “SharePoint Online Management Shell” to connect to Office 365, SharePoint online sites!

Import-Module Microsoft.Online.Sharepoint.PowerShell -DisableNameChecking $AdminSiteURL="https://crescent-admin.sharepoint.com" $Credential = Get-credential Connect-SPOService -url $AdminSiteURL -Credential $Credential #sharepoint online list all site collections powershell Get-SPOSite -Detailed | Format-Table Url, Template, StorageUsageCurrent, StorageQuota, LastContentModifiedDate -AutoSize

Here is the PowerShell script to get all site collections with detailed info from SharePoint Online and Export All Site Collection inventory to CSV:

Connect-SPOService -url "https://crescent-admin.sharepoint.com" -Credential (Get-credential) Get-SPOSite -Detailed | Export-CSV -LiteralPath C:\Temp\SitesInventory.csv -NoTypeInformation

This PowerShell lists all site collections in SharePoint Online tenant along with all available site collection details.

get all site collections inventory in sharepoint online using powershell

PowerShell to Get All Site Collections including Modern Team sites and Group Sites:

Let’s get the list of Sites in SharePoint Online using PowerShell.

#Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.SharePoint.Client.Runtime.dll" Add-Type -Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.Online.SharePoint.Client.Tenant.dll" #Get All Site collections from the Tenant- Including Modern Team sites and communication sites Function Get-SPOSites($AdminSiteURL, $Cred) { #Setup credentials to connect $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password) #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($AdminSiteURL) $Ctx.Credentials = $Credentials #Get the tenant object $Tenant = New-Object Microsoft.Online.SharePoint.TenantAdministration.Tenant($ctx) #Get All Site Collections $SiteCollections=$Tenant.GetSitePropertiesFromSharePoint(0,$true) $Ctx.Load($SiteCollections) $Ctx.ExecuteQuery() #Iterate through Each site collection ForEach($Site in $SiteCollections) { Write-host $Site.URL } } #Set Parameters $AdminSiteUrl = "https://crescent-admin.sharepoint.com/" $Cred= Get-Credential #sharepoint online powershell list all sites Get-SPOSites -AdminSiteURL $AdminSiteUrl -Cred $Cred

SharePoint Online PowerShell to List All Site Collections

Let’s get all site collections under a specific path:

Import-Module Microsoft.Online.SharePoint.Powershell #Config Parameters $AdminSiteURL="https://crescent-admin.sharepoint.com" #Get Credentials to connect to the SharePoint Admin Center $Cred = Get-Credential #Connect to SharePoint Online Admin Center Connect-SPOService -Url $AdminSiteURL -Credential $Cred #Get All site collections which has /sites in its path Get-SPOSite -Filter { Url -like '*/sites*' } -Limit All #Get All site collections of Group site template #Get-SPOSite -Filter { Template -eq "GROUP#0" } -Limit All

You can filter and get all site collections based on some criteria. E.g. Let’s get all sites that are using > 1GB storage

Get-SPOSite -Limit All | where { $_.StorageUsageCurrent -gt 1024 }

To filter and get collections: E.g. Get all site collections with “Project*” in their URL.

Get-SPOSite -Filter {$_.url -like "https://tenant.sharepoint.com/sites/Project*"}

SharePoint Online PnP PowerShell to Get All Sites

#Set Parameter $TenantSiteURL="https://crescent.sharepoint.com" #Connect to the Tenant site Connect-PnPOnline $TenantSiteURL -Credentials (Get-Credential) #Get all site collections Get-PnPTenantSite

We can extract all site collection details and export to CSV using:

#Config Variables $TenantSiteURL = "https://crescent-admin.sharepoint.com/" $CSVFilePath = "C:\Temp\AllSitesData.csv" #Connect to Tenant Admin Site Connect-PnPOnline -Url $TenantSiteURL -UseWebLogin #Get All Site collections data and export to CSV Get-PnPTenantSite -Detailed | Select Title, URL, Owner, LastContentModifiedDate, WebsCount, Template, StorageUsage | Export-Csv -NoTypeInformation $CSVFilePath

This gets all site collections including modern team sites and communication sites. You can include OneDrive sites as:

#Get all site collections including OneDrive Sites Get-PnPTenantSite -IncludeOneDriveSites

Get Site Collections List in an HTML Report format

Let’s get a list of all site collections in a nice HTML format using PowerShell:

Import-Module Microsoft.Online.SharePoint.Powershell -DisableNameChecking #Config Parameters $AdminSiteURL="https://crescent-admin.sharepoint.com" $ReportOutput="C:\Temp\SitesRpt.html" #CSS Styles $HeadTag = @" <style type="text/css"> table { border-collapse: collapse; font-family: verdana,arial,sans-serif; font-size:11px; color:#333333; border-width: 1px; border-color: #a9c6c9; border: b1a0c7 0.5pt solid; border-spacing: 1px; border-collapse: separate; /*Sal Table format */ } th { border-width: 1px; padding: 5px; background-color:#8064a2; border: #b1a0c7 0.5pt solid; font-family: Calibri; height: 15pt; color: white; font-size: 11pt; font-weight: 700; text-decoration: none; } td { border: #b1a0c7 0.5pt solid; font-family: Calibri; height: 15pt; color: black; font-size: 11pt; font-weight: 400; text-decoration: none; } tr:nth-child(even) { background-color: #e4dfec; } tr:hover { background-color: #694D8C; color:#ffffff } </style> "@ $PreContentTag = "<h3> SharePoint Online: Site Collections Inventory Report </h3>" #Get Credentials to connect to the SharePoint Admin Center $Cred = Get-Credential #Connect to SharePoint Online Admin Center Connect-SPOService -Url $AdminSiteURL -Credential $Cred #Get All site collections $SiteCollections = Get-SPOSite -Limit All Write-Host "Total Number of Site collections Found:"$SiteCollections.count -f Yellow #Get the site collection details, convert to html and output to the report $SiteCollections | ConvertTo-HTML -Title "Site Collection Inventory Report" -Property URL, Title,@{Expression={$_.LastContentModifiedDate }; Label="Last Modified"} -Head $HeadTag -PreContent $PreContentTag | Out-File $ReportOutput

and the report looks like:

sharepoint online site collections html report

Here is my another article on how to use PowerShell with SharePoint Online: How to Use PowerShell with SharePoint Online?

Related Posts

Sours: https://www.sharepointdiary.com/2016/02/get-all-site-collections-in-sharepoint-online-using-powershell.html
How to copy Microsoft SharePoint List to a different Site or Team?

IT Knowledgebase IT Knowledgebase



65 views Less than a minute

Step 1 – Log in to Office 365 and go to Sharepoint Online

Step 2 – In the search box type in contentclass:STS_Site

Step 3 – A list of sites that you have access to will be shown

Other Commands

If you need to see all site collection + subsites , search for ” contentclass:STS_Site OR contentclass:STS_Web”

Office 365Sharepointshow what sharepoint sites I have access to
Trusted IT Support Sydney by 4iT - Your IT Support Department

Related Articles

For more information about our Managed IT Support for your Sydney based business connect with us today!
Find Out More
Sours: https://support.4it.com.au/article/how-to-show-all-sites-you-have-access-to-in-sharepoint-online/

You will also like:

You can create and share lists that help you track issues, assets, routines, contacts, inventory, and more. Start from a template, Excel file, or from scratch. If you're in Microsoft Teams, see Get started with Lists in Teams.

Create a list

Your browser does not support video.
  1. From the Lists app in Microsoft 365, select +New list. (To get to the Lists app, at the top of any page, select the Microsoft 365 app launcher  App launcher button, select All apps, and then select Lists.)

    From your SharePoint site home page or the Site contents page, select + New > ListSharePoint new list

  2. From the Create a list page, select one of the following options:

    Note: Visual updates for lists are gradually rolling out worldwide, which means that your experience may differ from what's described in this article.

    Create a list
    1. Blank list: Choose to start a list from scratch. Add a list NameDescription (optional), and select whether you want the list to appear in the left site navigation. When you're finished selecting options, select Create.

    2. From Excel: Choose this option to create a list based on an Excel spreadsheet.

    3. From existing list: Choose this option to save time and create a new list based on the columns in another list. Your new list will start with all the same columns, but it won't include any of the data from the original list.

    4. Templates: Select a template, for example Issue tracker, to see what columns the template contains and scroll through sample data to see what it looks like. If you find a template you like, select Use template. If you don't see any you want, select Back to get back to the Create a list page. Learn more about how to create a list from a template or about the lists templates in Microsoft 365.

  3. When your list opens, add an item to your list by either selecting + New or Edit in grid view. (Grid view lets you add information freely to different rows or columns.)
    To add different types of information to the list, select + Add column. To learn more, see Create a column in a list or library.

Tip: To change the name of your list, select its title, type a new name, and then select Save. Or from the Lists home page, on your list's tile, select Open actions (...), and then select Customize

To change list properties, delete the list, add permissions, manage columns, and other updates, select SettingsSettings icon, and then select List Settings. For more info, see Edit a list.

Create a list on a classic SharePoint or a SharePoint Server 2019 site

  1. Select SettingsSettings icon, and then select Site contents.

  2. Select + New, and then select List.

  3. Enter a Name for the list, and optionally, a Description.

    The name appears at the top of the list and can appear in site navigation to help others find it.

  4. Select Create.

  5. When your list opens, to add room for more types of information to the list, select + or + Add column.

    For more info about adding columns, see Create a column in a SharePoint list or library.

For info about creating a list based on an existing list, see Create a new SharePoint list based on the columns in another list.

To change properties, delete the list, add permissions, manage columns, and a number of other updates, select SettingsSettings icon, and then select List Settings. For more info, see Edit a list.

Settings menu with List settings highlighted

Create lists from other types of list templates

You can use SharePoint Server 2019 lists for more than a simple list. You can choose from list templates such as Links, Calendar, Survey, Issue Tracking, Announcements, and more. 

Calendar app example

  1. In this example, we used calendar and chose the built-in calendar app for SharePoint. You may see other calendars that have been built within your company or offered by a third party.

  2. Enter a Name for the app you chose, such as Event calendar, July tasks, or Company Contacts.

    The name appears at the top of the list in most views, becomes part of the web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the web address will remain the same.

  3. SharePoint returns you to the Site contents page. Find the app you just created in the Site contents list, and open it. SharePoint creates a default version of the app, calendar, task list, or whatever app you created.

    Example of a calendar list app.
  4. You can start entering data using +new task, edit this list, Add, or whatever way the specific app provides to add data.

Note: Some list-based apps only appear in the classic environment.

Depending on the type of app you choose, to change the app's settings, from the ribbon at the top of the page, select List Settings or the List tab. For more info about settings, see Edit list settings in SharePoint.

  1. Select SettingsSettings icon, and then select Add an app.

    Add an application (list, library)
  2. Enter the type of list template you want (custom, task, calendar, and so on) into the search box, and select SearchSearch box magnifying glass icon.

    Search for a calendar list with build-in calendar highlighted
  3. Select the List template app you want use.

    Apps to add screen
  4. Enter a Name (required).

    The name appears at the top of the list in most views, becomes part of the web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the web address will remain the same.

    To provide an optional Description and additional info, depending on the particular list app, select Advanced Options. Advanced Options.

    New app screen with fields filled in
  5. Select OK.

  1. On the page that you want to add the list or library, select Page, and then select Edit. If you don't see the Page tab, select SettingsOffice 365 Settings button, and then select Edit Page.

    Edit the Page

    Note: If the Edit command is disabled or doesn’t appear, you may not have permission to edit the page.

  2. Select the place on the page where you want the list or library to appear, select Insert,and then select App Part.

  3. For the list or library, select the App Part, and then select Add. In Add apps,any lists you created should appear.

  4. When you’re finished editing the page, select the Page tab, and then select Save. In some cases, you have the option to Save as Draft or Save and Publish.

Important: Some pages can't be edited, such as the Site Contents page.

Using the previous steps, here’s an example of a list that was added to a page.

List on a page

  1. On the page where you want to minimize or restore the list or library, select Page, and then select Edit.

    Edit the Page

  2. Point to the list or library, select the down arrow, and select Minimize or Restore depending on the current position of the list or library, and then select OK.

    Click the settings down arrow, then click Minimize
  3. When you’re finished editing the page, select Save. In some cases, you have the option to Save as Draft or Save and Publish.

  1. On the Lists Home page, tap New.

  2. Under Create New, tap Blank List to start a list from scratch, or select an option under Templates.

    • Blank list starts a list from scratch.

    • Templates are pre-defined, purpose-based options that have columns already defined for you. Select one to see what it has and whether it is right for you. You may change the columns to fit your needs.

Start your blank list

  1. Tap Blank List, then give it a Name and a Description.

  2. Choose a color and an icon.

  3. Choose whether to save it under My Lists or on a specific SharePoint site.

  4. Tap Create.

    A blank list opens with a standard “Title” column on the left.

  5. To add a column, tap More, then tap Add New Column.

  6. Choose the type of column data you want, then define the columns settings. Tap the check mark to save the column settings.

  7. Repeat steps 5 and 6 until you’ve defined all your columns.

  8. To add an item to your list, tap New, then enter the data for each column. Select the check mark to save your item (or tap the X to discard the item data without saving).

Start a template-based list

  1. After you tap one of the templates, it will open so that you can see the columns and sample data it contains.

  2. Scroll through the template to see if it's right for you.  

    As you scroll horizontally, the left-most column data stays in view, helping to keep the related data in context.

  3. When you've found the template you want, tap Use This Template.

    Your new list opens with all the predefined columns from the template.

  4. To add a column, tap More, then tap Add New Column.

  5. Choose the type of column data you want, then define the columns settings. Tap the check mark to save the column settings.

  6. Repeat steps 4 and 5 until you’ve defined any additional columns you want.

  7. To remove an existing column, tap the column heading, scroll to the bottom of the settings, and tap Delete Column.

  8. To add an item to your list, tap New, then enter the data for each column. Select the check mark to save your item (or tap the X to discard the item data without saving).

Create a list in SharePoint Server 2010

You can create a list that you can later use in your pages. SharePoint Server 2010 includes many kinds of list templates, such as calendar, survey, and tasks.

  1. Select Site Actions Site Actions Menu, select View All Site Content, and then select Create Create Button.

    Note: A SharePoint site can be significantly modified. If you cannot locate an option, such as a command, button, or link, contact your administrator.

  2. Select one of the categories, such as Communications or Tracking, and choose from there.

    Click a category and select the list app you want

    You can also enter the type of list template that you want to create in the Search Installed Items box, such as Contacts or Calendar, and then select Search Search box magnifying glass icon.

  3. Enter the Name for the list. Name is required.

    The name appears at the top of the list in most views, becomes part of the web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the web address will remain the same.

  4. Optionally, for the list and set other options, click Advanced Options, and enter the Description.

    The description appears underneath the name in most views. Some kinds of lists can receive content by email. If you plan to enable the list to receive content by email, you can add the email address of the list to its description so that people can easily find the email address. You can change the description for a list.

  5. To add a link to the Quick Launch panel, in the Navigation section, verify that Yes is selected.

  6. If there is an Email section, your administrator has enabled lists on your site to receive content by email. To enable people to add content to this list by sending email, under Enable this list to receive email, select Yes. Then, in the Email address box, enter the first part of the address that you want people to use for the list. This option is not available for all kinds of list.

  7. Complete any other options, such as specifying whether a calendar works as a group calendar in the Calendar app.

  8. Select Create.

With SharePoint Server 2010 you can create lists from the pages that you are editing. This helps you more efficiently and effectively create the pages and the lists that you need.

  1. From a page, select the Edit tab, and then select the Edit command.

    Edit command of the Page tab

    Note: If the edit command is disabled, you may not have the permissions to edit the page, contact your administrator.

  2. Select the page where you want to add a new list, select the Insert tab, and then select New List.

    Insert new list on a page

    Note: If you don't see the Edit tab or New List is disabled, you may not have the permissions that are needed to create a list; contact your administrator.

  3. In the Create List dialog, enter the List Tile, select the type of list that you want to create, and then select OK.

    Type a name and select a template for a list

Creating a custom list resembles creating lists from a template, except that the custom list is created with only three columns: Title, Created By, and Modified By. After you create a custom list, you can add columns and make other changes to the list to meet your needs.

  1. Select Site Actions Site Actions Menu, select View All Site Content, and then select Create Create Button.

    Note: A SharePoint site can be significantly modified. If you cannot locate an option, such as a command, button, or link, contact your administrator.

  2. Under Custom Lists, select Custom List or Custom List in Datasheet View.

    Notes: 

    • Use custom list when you primarily want to use a form to enter and view data in the list.

    • Use custom list in datasheet view when you primarily want to use a grid, similar to a spreadsheet, to enter and view data in the list. This is helpful when you have several items to update at the same time.

    • You can change how you enter and display data in a list after a list is created.

  3. Enter the Name for the list. Name is required.

    The name appears at the top of the list in most views, becomes part of the web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the web address will remain the same.

  4. Enter the Description for the list. (Optional)

    The description appears underneath the name in most views. Some kinds of lists can receive content by email. If you plan to enable the list to receive content by email, you can add the email address of the list to its description so that people can easily find the email address. You can change the description for a list.

  5. To add a link to the Quick Launch, in the Navigation section, verify that Yes is selected.

  6. If there is an Email section, your administrator has enabled lists on your site to receive content by email. To enable people to add content to this list by sending email, under Enable this list to receive e-mail, select Yes. Then, in the Email address box, enter the first part of the address that you want people to use for the list. This option is not available for all kinds of list.

  7. Select Create.

  1. On the page that you want to add the list or library, select Page, and then select Edit. If you don't see the Page tab, select SettingsOffice 365 Settings button, and then select Edit Page.

    Edit the Page

    Note: If the Edit command is disabled or doesn’t appear, you may not have permission to edit the page. Contact your administrator.

  2. Select the place on the page where the list or library will appear, select Insert, and then select App Part.

  3. For the list or library, select the App Part, and then select Add.

  4. When you’re finished editing the page, select Save. In some cases, you have the option to Save as Draft or Save and Publish.

Using the previous steps, here’s an example of a list that was added to a page.

List on a page

Want to do the same with Libraries?

To create a library, see Create a document library.

Next steps with Lists

Columns    Configure what type of info a list holds by adding and deleting columns. For more information, see Create a column in a list or library.

Views    Change how a list is displayed by creating views. For more information, see Create, change, or delete a view of a list or library.

Folders    Add a subfolder to a list. For more information, see Create a folder in a list.

Sours: https://support.microsoft.com/en-us/office/create-a-list-0d397414-d95f-41eb-addd-5e6eff41b083


14012 14013 14014 14015 14016