Hi Paul, I believe the GUIDs are visible if you look directly in the SQL tables/views. Not a very elegant solution, but if you can't find any other way it should provide you what you need.
If you use a SQL query to look in tables like:
Sites
Webs
Lists
Webparts
and look in one of the first couple of columns you can guess which column is
the GUID. You can also try tables/views starting with "All".
So for example you might use SQL Management Studio to run a query like:
select *
from lists
I can then see the the tp_id column is probably the GUID (tp_WebID is not
unique in the table so that's not the one - this is showing which Web the list
is related to I guess). So I'd then run the following query searching for the
particular GUID's you're interested in:
select *
from lists
where tp_id like '%C91183C6-0AA9-451A-A282-952D7E88A85A'%' or tp_id like
'%C5271BBD-917E-4A5E-9331-FCB3E1683597%'
Alternatively, I can give you some code (a SQL cursor) that will look through
every field in every table in a database. That may put a significant load on
the SQL server, if you're content databases are more than a few GBs. But it
would save you time looking through the tables yourself.
Hope that helps!
P.S. My background is in SQL, I'm just learning Sharepoint.
Regards
Chris Scalley
Technical Specialist
Managed Services
T
+61 2 9286 2255
[cid:[email protected]]
F
+61 2 9286 2200
M
+61 (0) 400 660 371
E
[email protected]<mailto:[email protected]>
W
www.cdm.com.au<http://www.cdm.com.au/>
Communications, Design & Management Pty Limited
Level 23, 1 Oxford Street
NSW 2010, Darlinghurst
________________________________
"This communication, including any attachments, is confidential. If you are not
the intended recipient, you should not read it - please contact me immediately,
destroy it, and do not copy or use any part of this communication or disclose
anything about it."
From: [email protected] [mailto:[email protected]] On Behalf Of Paul Noone
Sent: Friday, 13 February 2009 10:59 AM
To: [email protected]
Subject: SQL Timer Jobs
Hi guys,
We're continuing to get dozens of event log errors on most of the servers. Most
were references to an old SSP which didn't seem to get deleted properly. Others
were to files/paths which no longer existed.
But I have it a wall with the following.
Every minute I get two errors on the SQL box regarding connection issues with
one of the WFEs (we have two but only one is throwing errors!).
SQL Profiler shows the following two lines that match the event logs but how
can I work out which site, web or list is responsible from the GUID?
ULT-SPPWEB-01 is the WFE which continues to throw errors.
exec proc_StartTimerRunningJob
'C91183C6-0AA9-451A-A282-952D7E88A85A',NULL,'C5271BBD-917E-4A5E-9331-FCB3E1683597',N'Config
Refresh',N'ULT-SPPWEB-01',1
exec proc_CompleteTimerRunningJob
'C91183C6-0AA9-451A-A282-952D7E88A85A',NULL,'C5271BBD-917E-4A5E-9331-FCB3E1683597',N'ULT-SPPWEB-01',2
Thanks in advance,
Paul
________________________________
Support procedure: https://www.codify.com/lists/support
List address: [email protected]
Subscribe: [email protected]
Unsubscribe: [email protected]
List FAQ: http://www.codify.com/lists/ozmoss
Other lists you might want to join: http://www.codify.com/lists
IMPORTANT NOTICE TO RECIPIENT
Computer viruses - It is your responsibility to scan this email and any
attachments for viruses and defects and rely on those scans as Communications
Design & Management Pty Limited (CDM) does not accept any liability for loss or
damage arising from receipt or use of this email or any attachments.
Confidentiality - This email and any attachments are intended for the named
recipient only and may contain personal information, be it confidential or
subject to privilege, none of which are lost or waived because this email may
have been sent to you in error. If you are not the named addressee please let
CDM know by return email, permanently delete it from your system and destroy
all copies and do not use or disclose the contents.
Copyright - This email is subject to copyright and no part of it maybe
reproduced in any manner without the written permission of the copyright owner.
Privacy - Within the jurisdiction of Australian law, personal information in
this email must be dealt with in compliance with the Australian Federal Privacy
Act 1988.
--------------------------------------------------------------------------------
Support procedure: http://www.codify.com/lists/support
List address: [email protected]
Subscribe: [email protected]
Unsubscribe: [email protected]
List FAQ: http://www.codify.com/lists/ozmoss
Other lists you might want to join: http://www.codify.com/lists
<<inline: image001.jpg>>
