0
votes
1answer
23 views

Outputting full name in query powershell

I am querying a sharepoint site. At the moment its returning Our future comm... how would I be able to make it print out the full name Here is my code Get-SPSite mysite | Select -ExpandProperty Lists ...
0
votes
0answers
26 views

searching all documents with a content type

How can I search all documents with a particular content type of 'EC Docs' and then query a site column in that content type where column -eq 'Res' Get-SPSite mysite | select -ExpandProperty AllWebs ...
1
vote
0answers
27 views

searching all documents in sharepoint

If I want to search all through my sharepoint site for all documents any place in the site. Would it just be Get-SPSite mysite | Select -ExpandProperty allwebs | Select -ExpandProperty Lists | ...
0
votes
1answer
46 views

query xml powershell sharepoint

Get-SPSite mysite | Select -ExpandProperty AllWebs | Select -ExpandProperty Lists | Select -ExpandProperty Items | Out-File outputpm.txt I have this code, which produces the items, one of the items ...
0
votes
0answers
38 views

Finding items using content types

Get-SPSite http://skynet | Select -ExpandProperty AllWebs | Select -ExpandProperty Lists | Select -ExpandProperty Items | ForEach { ForEach($ct in $ContentTypes){ if($ct.PM -eq "Res" -or "Con"){$_}}} ...
0
votes
0answers
10 views

Where query with a metadata field applied to the base content type

I want to create a query for all document library tagged with the terms ‘r’ or ‘c’ under their pm metadata field? the pm field is a ‘choice’ term type, applied to the base content type, so all of our ...
0
votes
1answer
55 views

List.GetItems is running slow for certain sites

I'm running a pretty simple query to get back items using List.GetItems and it seems to be performing horribly on some of my sites (differing site collections). The lists being queried are essentially ...
1
vote
2answers
1k views

How can I query all of the items which are inside a folder, which is in turn inside a document library?

I am trying to use Powershell to query my Sharepoint site so I can get a list of items to use as input in my migration script. I have a document library (Site Assets), which has a folder (Calendar ...
3
votes
4answers
1k views

What is the recommended way to query data on a Sharepoint site?

Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?