LogKB.com
Hi guys, a while ago I talked about building some tools to help with managing SharePoint logs. I have a website up and running now: http://www.logkb.com/ You can read the About page to get the overview of how this solution works: http://www.logkb.com/Home/About That page also contains a link to the latest client agent build. Download that latest build - running it is simple, unzip, change a couple of config. value, and run it. Kind Regards, Darren Neimke darren.nei...@live.com mob: 0439 855 046 ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: LogKB.com
Thanks Darren, this is exactly what we needed, not just the tool but also a platform to share solutions to log errors. Thanks again J From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Darren Neimke Sent: Tuesday, 22 December 2009 8:53 AM To: ozmoss@ozmoss.com Subject: RE: LogKB.com Thanks Paul, feel free to ping me offlist if you have any questions. There's obviously a stack of development still to be done - particularly on the website. The stuff that I will be focussing on in the next few days are: * Adding user leaderboards showing contibution for solving log errors * Allow users to provide rich profile information - such as consulting advertisements * Alerts and notifications to let users know when solutions have been added for log messages which they have added Again, any usage and feedback would be greatly appreciated! :-) Kind Regards, Darren Neimke darren.nei...@live.com From: paul.no...@ceosyd.catholic.edu.au To: ozmoss@ozmoss.com Date: Tue, 22 Dec 2009 08:53:36 +1100 Subject: RE: LogKB.com Great stuff Darren. I look forward to testing. Regards, Paul Online Developer, ICT CEO Sydney -Original Message- From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Darren Neimke Sent: Tuesday, 22 December 2009 7:31 AM To: ozMOSS Subject: LogKB.com Hi guys, a while ago I talked about building some tools to help with managing SharePoint logs. I have a website up and running now: http://www.logkb.com/ You can read the About page to get the overview of how this solution works: http://www.logkb.com/Home/About That page also contains a link to the latest client agent build. Download that latest build - running it is simple, unzip, change a couple of config. value, and run it. Kind Regards, Darren Neimke darren.nei...@live.com mob: 0439 855 046 ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss Hotmail: Free, trusted and rich email service. Get it now. http://clk.atdmt.com/GBL/go/171222984/direct/01/ # Confidentiality and Privilege Notice This document is intended solely for the named addressee. The information contained in the pages is confidential and contains legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply email. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. # ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: LogKB.com
No worries, thanks Jeff! I will be using this solution as part of the governance solution at my place of work so I will be very motivated to improve its usability and to ensure that the data is error free. That's my commitment to this. Obviously the more people that use it, the more benefit we can all get from using it though. My thinking is that there must be a relatively limited number of log messages that can be produced (maybe 1500?), so surely we can build a decent repository of remedies fairly quickly. Kind Regards, Darren Neimke darren.nei...@live.com Subject: RE: LogKB.com Date: Tue, 22 Dec 2009 09:08:18 +1100 From: jeffery.t...@datacom.com.au To: ozmoss@ozmoss.com Thanks Darren, this is exactly what we needed, not just the tool but also a platform to share solutions to log errors. Thanks again J From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Darren Neimke Sent: Tuesday, 22 December 2009 8:53 AM To: ozmoss@ozmoss.com Subject: RE: LogKB.com Thanks Paul, feel free to ping me offlist if you have any questions. There's obviously a stack of development still to be done - particularly on the website. The stuff that I will be focussing on in the next few days are: * Adding user leaderboards showing contibution for solving log errors * Allow users to provide rich profile information - such as consulting advertisements * Alerts and notifications to let users know when solutions have been added for log messages which they have added Again, any usage and feedback would be greatly appreciated! :-) Kind Regards, Darren Neimke darren.nei...@live.com From: paul.no...@ceosyd.catholic.edu.au To: ozmoss@ozmoss.com Date: Tue, 22 Dec 2009 08:53:36 +1100 Subject: RE: LogKB.com Great stuff Darren. I look forward to testing. Regards, Paul Online Developer, ICT CEO Sydney -Original Message- From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Darren Neimke Sent: Tuesday, 22 December 2009 7:31 AM To: ozMOSS Subject: LogKB.com Hi guys, a while ago I talked about building some tools to help with managing SharePoint logs. I have a website up and running now: http://www.logkb.com/ You can read the About page to get the overview of how this solution works: http://www.logkb.com/Home/About That page also contains a link to the latest client agent build. Download that latest build - running it is simple, unzip, change a couple of config. value, and run it. Kind Regards, Darren Neimke darren.nei...@live.com mob: 0439 855 046 ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss Hotmail: Free, trusted and rich email service. Get it now. Confidentiality and Privilege Notice This document is intended solely for the named addressee. The information contained in the pages is confidential and contains legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply email. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. _ Hotmail: Powerful Free email with security by Microsoft. http://clk.atdmt.com/GBL/go/171222986/direct/01/___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
[SOLVED] Site provisioning and synching issues
[DarrenM, this might be a good candidate for the new LogKB site.] Hi all, I finally have a resolution to the long-standing site provisioning issue which was preventing the user table from being synched with the SSP. Thought I would share it for anyone else who runs into the problem or is curious about how something so simple can cause so much grief. Problem Correct provisioning fails during site creation. Couldn't nail down the cause but MS seem to think something is failing during site creation, probably due to customisation - provisioning features, pages etc. Symptoms - Site users are not updated with SSP Profiles. - Generic picture placeholder where profile picture should be. - Clicking a site user (in some cases) returns userdisp.aspx with no redirection to Persons.aspx in My Site web app. - My Links-My SharePoint Sites link is not populated with site. - Similarly affected: oMy Site-SharePoint Sites oSave As-My SharePoint Sites - Event log error: OWSTIMER.EXE (0x0770) 0x1084 SharePoint Portal Server User Profiles 792c Unexpected ProfSynch: Exception attempting to enumerate site 74c5d608-de6f-42b7-8911-757088f52b6d for ContentDB 03895022-4025-4c02-b8aa-1aeb2549a1bd: Microsoft.Office.Server.UserProfiles.ProfileSynchronizationInternalException: ProfSynch: The site with ID 74c5d608-de6f-42b7-8911-757088f52b6d cannot be synchronized due to an unprovisioned root web. at Microsoft.Office.Server.UserProfiles.SiteSynchronizerCollection.GetSynchInfoForSite(SqlDataReader dr, SynchInfo info) at Microsoft.Office.Server.UserProfiles.SiteSynchronizerCollection.get_Elementsd__0.MoveNext() Confirm synch failure If you receive some or all of the above symptoms and want to confirm synching issues, open the SiteSynch table in the SSP content database and look for any sites with NULL values in the LastSynch and ChangeToken columns. Similarly, sites with Moving set to TRUE may also experience these symptoms. ContentDB SiteID LastSynch ChangeToken SchemaVersion LastChangeSynchSuccess Moving MovingDeleted Registered 5725ead8-de9a-4f2f-a6b9-05c8efa4abae d4d0ee70-16c2-40a3-bf7a-74b885d0892f 10/11/2009 5:00:07 AM 1;0;5725ead8-de9a-4f2f-a6b9-05c8efa4abae;63394631352643;4552 1 True False False True fa10142d-8629-477e-8315-3227ee9cbb13 b6d3d18d-e612-4d6a-98fa-754c318abe0d 30/11/2009 1:00:14 PM 1;0;fa10142d-8629-477e-8315-3227ee9cbb13;63395182813940;32645 1 True False False True 03895022-4025-4c02-b8aa-1aeb2549a1bd 74c5d608-de6f-42b7-8911-757088f52b6d NULL NULL 0 False False False True 5b6613a2-96c4-4673-8f99-69bd20c4d044 b69d84c3-51bd-4945-a82b-79e44ed0882c 18/11/2009 1:00:03 PM 1;0;5b6613a2-96c4-4673-8f99-69bd20c4d044;63395269203503;1731 1 True False False True Resolution - Backup content DB containing site(s). - Run the following query on the Webs.dbo for the relevant content DB. oRunning this command on a site with no issues will not cause any harm. oAfter running the command the root site's Flags value should be updated to 1059 SELECT Id, SiteId, FullUrl, Title, ProvisionConfig, Flags FROM Webs Table 1 - Sample data showing unprovisioned root site with Flags value 1315 Id SiteID FullUrl Title ProvisionConfig Flags e346c7cc-1d47-48f0-b816-07808f770efb 74c5d608-de6f-42b7-8911-757088f52b6d teams/ict/forum Team Discussion 0 1059 cd5fac14-1fde-445f-9834-3cae8eb8c7b0 74c5d608-de6f-42b7-8911-757088f52b6d teams/ict/moss-imp SharePoint Implementation 2 35 8ba2d0c5-771b-4e5d-b27e-7983a4dbafce 74c5d608-de6f-42b7-8911-757088f52b6d teams/ict/kbw ICT Wiki 0 35 115d5f4a-a630-4a96-b208-8fe488b9a781 74c5d608-de6f-42b7-8911-757088f52b6d teams/ict ICT Team Site 1 1315 00700024-846a-4ea8-8c7e-a0986c588b3f 74c5d608-de6f-42b7-8911-757088f52b6d teams/ict/sop Standard Operating Procedures 0 35 73df594d-6249-4fdc-b0c9-c88b36afb9e9 74c5d608-de6f-42b7-8911-757088f52b6d teams/ict/tlp ICT Team Leader's Meeting Workspace 0 35 df87c869-3392-48f1-9edb-e2656feca237 74c5d608-de6f-42b7-8911-757088f52b6d teams/ict/pt Project Team Meetings 0 35 NULL NULL NULL NULL NULL NULL - Under Flags column check for bad values (291, 1315) which indicate the site was not properly provisioned. oThere are many possible values for good and bad sites but no public list is available. I've asked MS Support if they can supply one to me which contains the most common values and a meaningful description. - Run the proc_markWebAsProvisioned Stored Procedure for each affected site, passing in the relevant WebID. oThe WebID value is a misnomer and actually refers to the SiteID column of the Webs table. oRight-=clicking the stored procedure and clicking execute will return no rows affected. You need to run the query in full by pasting the following into a new query: EXEC proc_markWebAsProvisioned '[SiteID]' - Wait a minute or two
RE: Export / Generate Permission levels
What are you hoping to see? Site Collection - Users/Groups - Permission Level - User Site Collection - Site- Users/Groups - Permission Level - User Site Collection - Site - List - Users/Groups - Permission Level - User Site Collection - Site - List - Item/Document - Users/Groups - Permission Level - User UPSMhttp://www.idevfactory.com/products/uspm2007/ from metalogix has a number of security auditing/analysis features that might be up your alley. Otherwise PowerShell might have to become your new friend. Regards, Paul Online Developer, ICT CEO Sydney From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Marko Salonen Sent: Tuesday, 22 December 2009 2:25 PM To: ozMOSS Subject: Export / Generate Permission levels Hi All Just wondering if there's a smart way to generate a list / report on site hierarchy and permission levels. I need to create a report on the entire site collection as to who has permissions to what. SPManager has a tree view of the sites and I can see the permissions but I cant export that information, And I was hoping there might be something else out there what I could use. Regards, Marko This email and any files transmitted with it are intended solely for the use of the individual or entity to whom this email is addressed. This email's contents are confidential and may contain copyright and/or legally privileged information. If you are not the intended recipient, you must not read, print, store, copy, forward or use this email for any reason. If this e-mail was sent to you in error, please notify the sender by return email, and delete this email without making a copy. Any confidentiality or privilege is not waived or lost because this email has been sent to you by mistake. Thank you. P Please consider the environment before printing this email ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss