Solved

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

Posted on 2013-12-02
3
503 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
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

The article will show you how you can maintain a simple logfile of all Startup and Shutdown events on Windows servers and desktops with PowerShell. The script can be easily adapted into doing more like gracefully silencing/updating your monitoring s…
Microsoft Windows Server Update Service (WSUS) is free for everyone, but it lacks of some desirable features like send an e-mail to the administrator with the status of all computers on the WSUS server. This article is based on my PowerShell script …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now