PowerShellを使って、指定のコンテンツDBに属するサイトコレクションの一覧を取得する方法です。
1 | <span class="lnum"> 1: </span><span class="rem">#サイトコレクションの一覧を表示したいコンテンツDBのIDを取得</span> |
1 | <span class="lnum"> 2: </span><span class="rem">#赤太字が対象コンテンツDBのID</span> |
1 | <span class="lnum"> 3: </span>PS C:UsersAdministrator.SP2010RCENT> get-spcontentdatabase |
1 | <span class="lnum"> 4: </span> |
1 | <span class="lnum"> 5: </span>Id : 5e26bcb9-680d-4292-bb45-07474e848348 |
1 | <span class="lnum"> 6: </span>Name : WSS_Content |
1 | <span class="lnum"> 7: </span>WebApplication : SPWebApplication Name=SharePoint - 80 |
1 | <span class="lnum"> 8: </span>Server : sp2010rcent |
1 | <span class="lnum"> 9: </span>CurrentSiteCount : 2 |
1 | <span class="lnum"> 10: </span> |
1 | <span class="lnum"> 11: </span>Id : 1879f902-66a2-4147-92ef-6d61d05cf77d |
1 | <span class="lnum"> 12: </span>Name : WSS_Content_Docs |
1 | <span class="lnum"> 13: </span>WebApplication : SPWebApplication Name=SharePoint - 80 |
1 | <span class="lnum"> 14: </span>Server : sp2010rcent |
1 | <span class="lnum"> 15: </span>CurrentSiteCount : 1 |
1 | <span class="lnum"> 16: </span> |
1 | <span class="lnum"> 17: </span>Id : 1ead42e7-856c-4b68-b75e-675c387130f5 |
1 | <span class="lnum"> 18: </span>Name : WSS_Content_Workspaces |
1 | <span class="lnum"> 19: </span>WebApplication : SPWebApplication Name=SharePoint - 80 |
1 | <span class="lnum"> 20: </span>Server : sp2010rcent |
1 | <span class="lnum"> 21: </span>CurrentSiteCount : 1 |
1 | <span class="lnum"> 22: </span> |
1 | <span class="lnum"> 23: </span>Id : 1fb9798e-c5bd-485d-8ff3-87d95a84c5cf |
1 | <span class="lnum"> 24: </span>Name : WSS_Content_Media |
1 | <span class="lnum"> 25: </span>WebApplication : SPWebApplication Name=SharePoint - 80 |
1 | <span class="lnum"> 26: </span>Server : sp2010rcent |
1 | <span class="lnum"> 27: </span>CurrentSiteCount : 1 |
1 | <span class="lnum"> 28: </span> |
1 | <span class="lnum"> 29: </span><span class="rem">#先ほど取得したIDをパラメータに指定</span> |
1 | <span class="lnum"> 30: </span><span class="rem">#サイトコレクションの一覧を取得する</span> |
1 | <span class="lnum"> 31: </span>PS C:UsersAdministrator.SP2010RCENT> get-spsite -contentdatabase 5e26bcb9-680d-4292-bb45-07474e848348 |
1 | <span class="lnum"> 32: </span> |
1 | <span class="lnum"> 33: </span>Url |
1 | <span class="lnum"> 34: </span>--- |
1 | <span class="lnum"> 35: </span>http://sp2010rcent |
1 | <span class="lnum"> 36: </span>http://sp2010rcent/my |