SharePoint world of ECM and Information Management : Code Snippet

SharePoint Tip #34. Do you know “how to get the list of check-out files"?!

Michael — Fri, 22 May 2009 04:30:07 GMT

SharePoint provides OOTB support for document versioning, allowing user to check-in/check-out files, and keep history of changed documents. But unfortunately, versioning system doesn't provide inbuilt method to find these all check-out items made by users.

For some administrative task and farm maintenance it's recommended to have all files to be check-in before making changes. And this task became daunting task for administrators, because you need to check all site collection and list collections manually via SharePoint interface , to check-in user files.

The way to get the list of all check-out files across specific site is to use the following SQL script for SharePoint AdminContent DB

        1: SELECT     tp_DirName, 'http://SiteName/' + tp_DirName AS Expr1, tp_LeafName, 

       2:                       CASE WHEN AllUserData.tp_ContentType = 'Item' THEN 'http://SiteName/' + AllUserData.tp_DirName + '/DispForm.aspx?ID=' + AllUserData.tp_LeafName ELSE 'http://SiteName/'

       3:                        + AllUserData.tp_DirName + '/' + AllUserData.tp_LeafName END AS Link, tp_ContentType, nvarchar1, nvarchar2, tp_ModerationStatus, tp_DeleteTransactionId, 

       4:                       tp_IsCurrent

       5: FROM         AllUserData AS AllUserData

       6: WHERE     (tp_ModerationStatus = 2) AND (tp_DeleteTransactionId = 0x0) AND (tp_IsCurrent = 1)

       7: ORDER BY tp_DirName, tp_LeafName

Source

Have anything to add?! Send your tips to be published via this form.

SharePoint Templates for CodeSmith tool

Michael — Sun, 17 May 2009 13:30:47 GMT

Are you a big fun of CodeSmith tool?! If yes, then you will find the blog post from Waldek Mastykarz very attractive, because we is offering a set of CodeSmith templates to automate some coding stuff for SharePoint.

The following templates are available for download:

Generates the ContentTypeBinding element for the given Content Type and List
Generates Page Layout for the given Content Type
Generates wrapper class for the given Content Type so that you can reference all fields from that Content Type using code with intellisense instead of fiield names
Generates ElementFile element for every file in the given directory and its subdirectories. Extremely useful for Features like branding where you have to provision many different files using a Feature
Generates contents of a Feature Element Manifest (commonly named as Elements.xml or ProvisionedFiles.xml).

Really good stuff, because CodeSmith community didn’t provide any SharePoint templates before

SharePoint Tip #16. Do you know “how to get the SharePoint version programmatically”?

Michael — Sun, 22 Feb 2009 12:56:00 GMT

The administrative way of getting SharePoint version is navigating to “Central Administration > Operations > Servers in Farm”. But what if you need to get version programmatically?!

It might be that your feature relies on the specific version, lets say SharePoint SP1 + Infrastructure Update installed, and you need to check version of the SharePoint when feature installs. The way to get version programmatically is use the following SQL script

SELECT Version, UserName  
FROM Versions 
WHERE VersionId = '00000000-0000-0000-0000-000000000000' 
ORDER BY Id DESC

This script should be run against the Central Administration content database, and it returns the value which is show in “Service In Farm”. Refer the following post to find which Update/Patch corresponds to SharePoint version number.

Use the following code-snippet to find the content database of the Central Administration site, to be used in the SQL script

using (SPSite startSite = new SPSite("<Central Admin url>"))
{
    SPFarm farm = startSite.WebApplication.Farm;
    SPWebService service = farm.Services.GetValue<SPWebService>("");
  
    foreach (SPWebApplication webApplication in service.WebApplications)
    {
        foreach (SPSite site in webApplication.Sites)
        {
            Console.WriteLine(string.Format("{0} - {1}", site.Url, site.ContentDatabase.Name));
        }
    }
}

Current "SharePoint Tips and Tricks" series has been moved to its own "SharePoint SandBox" site, to leave the place for others SharePoint posts on this blog