Solved

SharePoint 2010 Powershell question - What are all the items in the Select option?

Posted on 2013-12-02
3
522 Views
Last Modified: 2013-12-02
I am building a list of all the SharePoint sites in SharePoint 2010.  I have got a script that can accomplish most of this.  I do not know how to see what all the options I can list with the Select option highlighted below.   I'd like to find out when a site was last modified and when it was created.

Get-SPWebApplication http://sharepointsite | Get-SPSite -Limit All | Get-SPWeb -Limit All | Select Title, URL, ID, ParentWebID | Export-CSV C:\new\InfoArch1.csv

Any and all help is greatly appreciated.
0
Comment
Question by:cknoderer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 40

Assisted Solution

by:Subsun
Subsun earned 250 total points
ID: 39690264
You can use Get-Member or Format-List command to list all available properties.. For example..

Get-SPWebApplication http://sharepointsite | Get-SPSite -Limit All | Get-SPWeb -Limit All | Get-Member -MemberType Property | Select Name

Open in new window


or

Get-SPWebApplication http://sharepointsite | Get-SPSite -Limit All | Get-SPWeb -Limit All | FL *

Open in new window


Or even Select * will give you all properties..

Created and LastItemModifiedDate are the two properties you might be looking for..
0
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 250 total points
ID: 39690277
Hi,
you can get all the properties mentioned here in the SPWeb object properties:
http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spweb_properties.aspx

There is also one special property called "Properties" which is of type "SPPropertyBag" and which contains also all properties as hash table.

HTH
Rainer
0
 
LVL 1

Author Comment

by:cknoderer
ID: 39690340
Thanks! They both are correct.  I tried using the * after Select and it returned all the results.  Which didnt' occur to me. (Typical)  

Get-SPWebApplication http://sharepointsite| Get-SPSite -Limit All | Get-SPWeb -Limit All | Select * | Export-CSV C:\new\listauthor.csv
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scannerā€¦
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the adminiā€¦

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question