Query Template Information
I am new to the world of SharePoint and have inherited several SharePoint sites. Is there anyway at a site, list, or library level to tell which template the object was created from? For example, an existing site has several Project lists (List, Tasks, Issues, Milestones), that tie into each other. New users want similar functionality in their sites but I don't know the source of these lists.
December 17th, 2011 12:31pm

Hi, First we can find the list created time in “AllLists” table in SQL Server. Open SQL Server, choose the database in the toolbar, then use “ select * from AllLists where tp_Title=' Milestones' ” to select the list you want to find, which name is Milestones here for example, then get the list created time. Next we go to default directory C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS to find the log when Milestones list created. But first we need to know that in SQL Server the time is GMT, so we need to add the balance which can be find in Regional Settings in site. Then we get the list created local time, we can open the relevant log. In log file, we can find sentences look like: The list "Milestones" in web "http://server/.../site" was created at URL "Lists/ Milestones" instead of at URL "Lists/list2"……..So here, the list2 for example is the source of Milestones list. Or you can find the related list, save it as template again, then use this template to create a list. Thanks. Emir Liu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
December 20th, 2011 3:42pm

Hi, First we can find the list created time in “AllLists” table in SQL Server. Open SQL Server, choose the database in the toolbar, then use “ select * from AllLists where tp_Title=' Milestones' ” to select the list you want to find, which name is Milestones here for example, then get the list created time. Next we go to default directory C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS to find the log when Milestones list created. But first we need to know that in SQL Server the time is GMT, so we need to add the balance which can be find in Regional Settings in site. Then we get the list created local time, we can open the relevant log. In log file, we can find sentences look like: The list "Milestones" in web "http://server/.../site" was created at URL "Lists/ Milestones" instead of at URL "Lists/list2"……..So here, the list2 for example is the source of Milestones list. Or you can find the related list, save it as template again, then use this template to create a list. Thanks. Emir Liu TechNet Community Support
December 23rd, 2011 7:56am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics