This programming task describes how to create a console application in Microsoft Visual Studio 2005. The example displays the number of lists within a site collection.
Users must be administrators on the computer where the script is executed in order to run a console application in the context of Windows SharePoint Services.
On the File menu in Visual Studio 2005, point to New and then click Project.
In the New Project dialog box, select a language, and then select Windows in the Project Types box.
In the Templates box, select Console Application.
In the Location box, type the path to where to create the application, and then click OK.
In Solution Explorer, right-click the References node, and then click Add Reference on the shortcut menu.
On the .NET tab of the Add Reference dialog box, select Windows SharePoint Services in the list of components, and then click OK.
In the .vb or .cs file, add a using directive for the Microsoft.SharePoint namespace, as follows.
Imports Microsoft.SharePoint
using Microsoft.SharePoint;
Add the following code to the Main method in the .vb or .cs file.
Overloads Sub Main(args() As String) Dim siteCollection As New SPSite("http://Server_Name") Dim sites As SPWebCollection = siteCollection.AllWebs Dim site As SPWeb For Each site In sites Dim lists As SPListCollection = site.Lists Console.WriteLine("Site: " + site.Name + " Lists: " + lists.Count.ToString()) Next site Console.WriteLine("Press ENTER to continue") Console.ReadLine() End Sub 'Main
static void Main(string[] args) { SPSite siteCollection = new SPSite("http://Server_Name"); SPWebCollection sites = siteCollection.AllWebs; foreach (SPWeb site in sites) { SPListCollection lists = site.Lists; Console.WriteLine("Site: " + site.Name + " Lists: " + lists.Count.ToString()); } Console.WriteLine("Press ENTER to continue"); Console.ReadLine(); }
Click Start on the Debug menu or press F5 to run the code.
First, didn't realize I can't run this code on my workstation. It has to run on the server that has WSS installed.
Second, when I tried to run it from the server, I was initially trying to run it directly from a fileshare on my workstation. That doesn't run the program with high enough permissions. It worked fine once I copied the EXE and DLLs to a local folder on the server.