GEGetDocConfig – SharePoint tool to Enumerate Document Libraries
What is GEGETDOCCONFIG?
This utility will allow you to get information concerning your document libraries from your SharePoint installation without having to manually trawl through them.
A nifty SharePoint utility to list information concerning document libraries in one or more sites, Displays Size, Validity, Folder, Parent, Author, Minor and Major Version, Modified / Created By, Modified / Created Date, Title, URL, ID Checked Out information, Email Address Setting….
List information concerning one or more document libraries in one or more sites – Incoming email address, who created it and when.
You can also get it to enumerate all documents showing Size, Validity, Folder, Parent, Author, Minor and Major Version, Modified / Created By, Modified / Created Date, Title, URL, ID. Plus check out data like, Checked Out By, When Checked In, Comments, Checked Out, Expires, Status.
You want to know how many files are in your document libraries over a site collection
- You want to find out the email addresses set against your document libraries
- You want to know who created document libraries and when
- You want to see the sizes of files in the document library and other audit information
- You want to get the size of your sites and document libraries
- You want to get information concerning site creation and document library management in one place
So – this is a Free Tool right?
Yes, its definately free, however, please donate !
Why write it?
Absolutely loads of reasons – key ones surrounding audit trail for document libraries, so much data to gather and in numerous places – it needs automation!
Ok, so how do you use it?
List information concerning one or more document libraries in one or more sites
GEGetDocConfig [-u URL of site to check] [-d Document Library Title] [-a] [–e] [-[f] NameOFOutPutTextFile]
Example 1
GEGetDocConfig
This will display information from all document libraries and from all sites in all web apps on the farm showing those who have full control on those sites.
Example 2
GEGetDocConfig -u http://mysharepoint
This will display information concerning all document libraries from the mysharepoint site.
Example 3
GEGetDocConfig -u http://mysharepoint -d MySharedDocs
This will display information concerning MySharedDocs document library in the mysharepoint site.
Example 4
GEGetDocConfig -u http://mysharepoint -d MySharedDocs -a
This will display information INCLUDING all the files in the MySharedDocs document library in the mysharepoint site.
Example 5
GEGetDocConfig -u http://mysharepoint -e
This will display information from document libraries in site http://mysharepoint which have Incoming emails set against them.
Example 6
GEGetDocConfig -f AllSites.txt
This will display information about all document libraries in all sites to the text file GEGetDocConfig.TXT
Where can I get it?
You can download it from here:
http://www.stationcomputing.com/Shared%20Documents/Forms/DispForm.aspx?ID=13
Or from Codeplex Here:
http://gegetdocconfig.codeplex.com/
How do you install it?
Simply unzip the file and put the executable into its own folder on your front end server. Make sure that the person who is a site collection admin / domain admins runs this tool.
Whats the catch Geoff – how much does it cost?
Nothing – Nada – Zip – Nowt.
In short, this tool is free, but like all of my SharePoint tools please donate if you find the tool useful – many thanks in advance!
What does the output look like?
Well, here’s a run against my SharePoint 2010 environment.
GEGetDocConfig by Geoff Evelyn, Version 1.0, April 2009, geoff@geoffevelyn.com, http://geoffevelyn.com
All Document Libraries will be checked
Capture Started at:20/02/2010 at 14:35 (UTC)
START WEB APPLICATION REPORT
=================================================================================
START WEB APP REPORT
Web Application Name: SharePoint – 10109
Storage Usage: 5237kb (5mb or 0gb)
Storage Quota: NO QUOTA LIMIT SET
Content Database: HuggyWeb_Content
Creator: Mymachine\sharepoint2010admin
Bandwidth: 0
Hits: 0
Visits: 0
Content Last Updated: 08/03/2010 at 00/43 (UTC)
Security Last Modified: 02/01/2010 at 09/19 (UTC)
Number of Subsites: 2
Doc Libary: IWConvertedForms, Parent: , ID: b0c07800-c727-402d-9d3c-0aed603d49da, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:3
Doc Libary: AnalyticsReports, Parent: , ID: a612892d-85fa-4b7e-8eb9-3a7a997e017e, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: Documents, Parent: , ID: 43882fd3-68f8-41b1-9375-549cd879a2d2, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: FormServerTemplates, Parent: , ID: 404728d1-dce7-4b07-ab50-87a6ff3cf38a, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: PublishingImages, Parent: , ID: 6ee529f5-525a-4cb3-93c4-7892babed456, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: MainDocs, Parent: , ID: bac9bbdf-fce1-42e2-8333-b732a13d2f12, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:1
Doc Libary: Pages, Parent: , ID: e85d776c-9e7f-45f1-9dfa-253f97b6da4a, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:1
Doc Libary: SiteCollectionDocuments, Parent: , ID: fa2d22cf-9d25-425f-b801-f8c0fd68cdf4, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: SiteCollectionImages, Parent: , ID: a3fc5746-b133-4c47-8f09-f9bbb7a5ac5f, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:2
Doc Libary: Style Library, Parent: , ID: 1072aa98-f1e2-422c-87ba-ce8c3e2497d1, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
SubSite 1 of 2, http://user-pc:10109/pressreleases, Created 24/12/2009 by SHAREPOINT\system, Site Last Updated on 24/12/2009
Doc Libary: Documents, Parent: , ID: b0be2303-7be8-4ee1-876f-a945dbd823e2, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: PublishingImages, Parent: , ID: de26a2bb-6d98-4edd-966a-ed04cd756409, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: Pages, Parent: , ID: 6e845a88-9ba5-4489-887b-a063ea17e358, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:1
SubSite 2 of 2, http://user-pc:10109/search, Created 24/12/2009 by SHAREPOINT\system, Site Last Updated on 24/12/2009
Total Number of Subsites in http://user-pc:10109 is 2
Storage Usage: 3441kb (3mb or 0gb)
Storage Quota: NO QUOTA LIMIT SET
Content Database: HuggyWeb_Content
Creator: Mymachine\sharepoint2010admin
Bandwidth: 0
Hits: 0
Visits: 0
Content Last Updated: 08/03/2010 at 00/43 (UTC)
Security Last Modified: 24/01/2010 at 22/21 (UTC)
Number of Subsites: 0
Doc Libary: IWConvertedForms, Parent: , ID: 9db99425-28de-4649-886a-70fd266f9cfb, Email Address: NOT SET Author: SHAREPOINT\system, Created: 21/01/2010, Total File Count:3
Doc Libary: AnalyticsReports, Parent: , ID: 20d7d516-51f7-49c1-b4e4-c295ac3f7315, Email Address: NOT SET Author: SHAREPOINT\system, Created: 21/01/2010, Total File Count:0
Doc Libary: FormServerTemplates, Parent: , ID: a71452ae-2d9c-4904-af5b-4b08c055a5f1, Email Address: NOT SET Author: SHAREPOINT\system, Created: 21/01/2010, Total File Count:0
Doc Libary: Reporting Templates, Parent: , ID: 42211388-45c1-4b39-b4cf-1cd37734b0f8, Email Address: NOT SET Author: SHAREPOINT\system, Created: 21/01/2010, Total File Count:2
Doc Libary: Shared Documents, Parent: , ID: 6e995a59-bbce-4089-bb99-4f7e62ffee64, Email Address: NOT SET Author: SHAREPOINT\system, Created: 21/01/2010, Total File Count:0
Doc Libary: SiteAssets, Parent: , ID: e13e499f-be4c-4473-ab30-53f8d849dbc3, Email Address: NOT SET Author: SHAREPOINT\system, Created: 21/01/2010, Total File Count:0
Doc Libary: SitePages, Parent: , ID: bb514b8c-3e50-4b22-a4b7-ac5e82406eeb, Email Address: NOT SET Author: SHAREPOINT\system, Created: 21/01/2010, Total File Count:2
Doc Libary: Style Library, Parent: , ID: 735387b5-02e5-4dbf-b902-54ea46534433, Email Address: NOT SET Author: SHAREPOINT\system, Created: 21/01/2010, Total File Count:0
There are NO subsites in http://user-pc:10109/sites/home2
Total Sites in Web App SharePoint – 10109 is 3
END WEB APP REPORT
=================================================================================
=================================================================================
START WEB APP REPORT
Web Application Name: SharePoint – 80
Storage Usage: 11759kb (11mb or 0gb)
Storage Quota: NO QUOTA LIMIT SET
Content Database: WSS_Content
Creator: Mymachine\sharepoint2010admin
Bandwidth: 0
Hits: 0
Visits: 0
Content Last Updated: 25/03/2010 at 07/16 (UTC)
Security Last Modified: 04/01/2010 at 16/22 (UTC)
Number of Subsites: 8
Doc Libary: IWConvertedForms, Parent: , ID: ad87ba18-6dee-4195-9316-bd0e050e8ab4, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:3
Doc Libary: AnalyticsReports, Parent: , ID: 92abff67-8334-4948-82ff-619c9dd0f692, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:1
Doc Libary: Documents, Parent: , ID: a70be5c5-17cb-4cd8-a78c-4d53202b50a1, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:3
Doc Libary: FormServerTemplates, Parent: , ID: 018361fd-4f3c-4ba0-ad68-8add6799ef61, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
Doc Libary: PublishingImages, Parent: , ID: 2d401dbb-8ee6-4a1d-a31e-7959740758e2, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
Doc Libary: Pages, Parent: , ID: 39ea796a-dab7-43d4-80ca-deea960bd426, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:2
Doc Libary: SiteCollectionDocuments, Parent: , ID: 8c3eb4eb-2b16-4586-b1dc-ad048b69e263, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
Doc Libary: SiteCollectionImages, Parent: , ID: 7fe674a1-ca90-4700-a4c8-f35fdba5a98e, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:2
Doc Libary: Style Library, Parent: , ID: 3ec0b7e5-ae2e-45b5-8f7f-22a80ae16039, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
SubSite 1 of 8, http://user-pc/pressreleases, Created 24/12/2009 by Mymachine\sharepoint2010admin, Site Last Updated on 24/12/2009
Doc Libary: Documents, Parent: , ID: bf057f37-8ded-47de-ac78-496114e2a103, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
Doc Libary: PublishingImages, Parent: , ID: dc13427f-12ee-4425-867f-3d10f81b8910, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
Doc Libary: Pages, Parent: , ID: 2271bb97-6f2c-4a5c-94dc-44c846a6b581, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:1
SubSite 2 of 8, http://user-pc/publishingportal, Created 08/03/2010 by Mymachine\sharepoint2010admin, Site Last Updated on 08/03/2010
Doc Libary: Asset Library, Parent: , ID: 20daca57-4612-4806-bfda-4da9c8a18899, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:0
Doc Libary: Documents, Parent: , ID: 7c827f66-bd58-4726-b68d-39738642dad5, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:0
Doc Libary: PublishingImages, Parent: , ID: d7d39888-ed9e-4c6f-b817-f8face6be81a, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:0
Doc Libary: Pages, Parent: , ID: 9296a3c2-c0ef-49a9-bf64-c5d308ec1c07, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:1
SubSite 3 of 8, http://user-pc/publishingportal/assetweb, Created 08/03/2010 by Mymachine\sharepoint2010admin, Site Last Updated on 08/03/2010
Doc Libary: AppImages, Parent: , ID: dd7c4b59-b1c3-4424-8008-56c6428113e7, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:8
Doc Libary: Macros, Parent: , ID: b7246fc4-edaf-43cc-bafc-438cc5ea1b89, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:0
Doc Libary: Report Definitions, Parent: , ID: 07c05c3a-7475-4f93-b3bf-244b5262c45b, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:4
SubSite 4 of 8, http://user-pc/publishingportal/basicmeetingworkspace, Created 08/03/2010 by Mymachine\sharepoint2010admin, Site Last Updated on 08/03/2010
Doc Libary: Document Library, Parent: , ID: 97e4fd6c-6b82-441f-b0b9-feca1c332c8e, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:0
Doc Libary: pages, Parent: , ID: eb9e3167-d00e-4c6e-b471-139017564337, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:0
SubSite 5 of 8, http://user-pc/publishingportal/basicsearchcentre, Created 08/03/2010 by Mymachine\sharepoint2010admin, Site Last Updated on 08/03/2010
SubSite 6 of 8, http://user-pc/publishingportal/blankmeetingworkspace, Created 08/03/2010 by Mymachine\sharepoint2010admin, Site Last Updated on 08/03/2010
Doc Libary: pages, Parent: , ID: 63522478-6bad-4f12-9efb-596db47f08c5, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 08/03/2010, Total File Count:0
SubSite 7 of 8, http://user-pc/search, Created 24/12/2009 by Mymachine\sharepoint2010admin, Site Last Updated on 24/12/2009
SubSite 8 of 8, http://user-pc/teamsite, Created 15/01/2010 by Mymachine\sharepoint2010admin, Site Last Updated on 15/01/2010
Doc Libary: Shared Documents, Parent: , ID: 2f6a3458-8dd2-4f4b-b5d4-9adda8b6d923, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 15/01/2010, Total File Count:0
Doc Libary: SiteAssets, Parent: , ID: 03a5a74a-f792-4de6-aa5b-2b6dce2c4bcc, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 15/01/2010, Total File Count:0
Doc Libary: SitePages, Parent: , ID: 6a751fa8-3f95-464a-b4ca-71341e25323e, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 15/01/2010, Total File Count:2
Total Number of Subsites in http://user-pc is 8
Storage Usage: 1843kb (2mb or 0gb)
Storage Quota: NO QUOTA LIMIT SET
Content Database: WSS_Content
Creator: Mymachine\sharepoint2010admin
Bandwidth: 0
Hits: 0
Visits: 0
Content Last Updated: 08/03/2010 at 00/20 (UTC)
Security Last Modified: 04/01/2010 at 16/22 (UTC)
Number of Subsites: 0
Doc Libary: IWConvertedForms, Parent: , ID: 5c05bac5-f146-4cc0-bea7-9fb3cd578d54, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:3
Doc Libary: AnalyticsReports, Parent: , ID: 7398cd4c-c9ab-48a8-bd08-45586bc23873, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: FormServerTemplates, Parent: , ID: 62b84e75-e6d1-4b31-8bb1-d865da498f9c, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: Organization Logos, Parent: , ID: 2a2c8b60-42df-4bb5-93f0-d6b86c28c80c, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: Style Library, Parent: , ID: cc44e68e-e535-4a0e-b20d-53b0fcf42c91, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
Doc Libary: User Photos, Parent: , ID: d158c87c-ace6-4711-a244-617f63f7bede, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
There are NO subsites in http://user-pc/my
Total Sites in Web App SharePoint – 80 is 9
END WEB APP REPORT
=================================================================================
Web Service Site Totals:
Total Sites in [NO SERVICE NAME] is 12
Total Storage against [NO SERVICE NAME] is 22280kb (22mb or 0gb)
END WEB SERVICE REPORT [NO SERVICE NAME]
START WEB APPLICATION REPORT
=================================================================================
START WEB APP REPORT
Web Application Name: [EMPTY WEB APP NAME]
Storage Usage: 17938kb (18mb or 0gb)
Storage Quota: NO QUOTA LIMIT SET
Content Database: SharePoint_AdminContent_50fd1d28-a67b-4524-a82c-afb6212bb0ac
Creator: Mymachine\sharepoint2010admin
Bandwidth: 0
Hits: 0
Visits: 0
Content Last Updated: 20/02/2010 at 13/00 (UTC)
Security Last Modified: 24/12/2009 at 10/18 (UTC)
Number of Subsites: 0
Doc Libary: AdminReports, Parent: , ID: 5ed6d709-360a-4b53-8978-42e6cb9f0e3f, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
Doc Libary: Shared Documents, Parent: , ID: d55a08b3-5dfa-4d9d-a79c-0564c60a21b4, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
Doc Libary: Style Library, Parent: , ID: 1f9e8c90-40ff-47df-a7dc-5dee024eb43b, Email Address: NOT SET Author: Mymachine\sharepoint2010admin, Created: 24/12/2009, Total File Count:0
There are NO subsites in http://user-pc:43827
Storage Usage: 9644kb (9mb or 0gb)
Storage Quota: NO QUOTA LIMIT SET
Content Database: SharePoint_AdminContent_50fd1d28-a67b-4524-a82c-afb6212bb0ac
Creator: Mymachine\sharepoint2010admin
Bandwidth: 0
Hits: 0
Visits: 0
Content Last Updated: 24/12/2009 at 17/22 (UTC)
Security Last Modified: 24/12/2009 at 17/22 (UTC)
Number of Subsites: 0
Doc Libary: IWConvertedForms, Parent: , ID: a6ae7807-369f-4803-a63e-8d08c956f9c4, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:3
Doc Libary: AnalyticsReports, Parent: , ID: f64bfd9f-0d66-4813-9f60-36bee391b757, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: FormServerTemplates, Parent: , ID: 0dc28406-80b0-4e2e-8cb2-ed126e20377a, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Cannnot Read Document Libary: http://user-pc:43827/sites/help/Lists/Product Help at http://user-pc:43827/sites/help
Doc Libary: Reporting Templates, Parent: , ID: 00d30453-84c9-467d-a67a-9521cfc460c5, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:2
Doc Libary: Shared Documents, Parent: , ID: 913b1186-cbe1-4e8a-9c0f-7a7950fc6af0, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: SiteAssets, Parent: , ID: 52d3b135-5d35-40e0-8244-cc55253be594, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
Doc Libary: SitePages, Parent: , ID: fed6f590-a5d4-41be-94d5-4d5dd306015c, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:2
Doc Libary: Style Library, Parent: , ID: 2e0583af-8910-4242-8d4a-6f50fb06f2e2, Email Address: NOT SET Author: SHAREPOINT\system, Created: 24/12/2009, Total File Count:0
There are NO subsites in http://user-pc:43827/sites/Help
Total Sites in Web App [EMPTY WEB APP NAME] is 1
END WEB APP REPORT
=================================================================================
Web Service Site Totals:
Total Sites in WSS_Administration is 13
Total Storage against WSS_Administration is 27582kb (27mb or 0gb)
END WEB SERVICE REPORT WSS_Administration
Total Sites across all Web Services (checked): 25
Total Storage across all Web Services (checked): 49862kb (49mb or 0gb)
GELISTALLSITES Capture Completed at:20/02/2010 at 02:35
= END REPORT =
