How to get the list of all checked out item in tridion under all users accounts

Question

I have a requirement where i need to find the list of all checked out item in Tridion under all Tridion users. I am using tridion 2013 SP1.

I can get all checked out items under my name by using below code.

 RepositoryLocalObjectsFilterData filter = new RepositoryLocalObjectsFilterData();
 XElement itemList = client.GetSystemWideListXml(filter);
 Console.WriteLine("Count :: " + itemList.Descendants(tcm + "Item").Count());

How to get it for all users. Do i need to use some filter?

Answer 1

Well, if the user (under which you are running the code) has proper rights your code should return the desired result for you, as I think the code is correct.

on the other side, if you want to list items checked out by specific user; you can use RepositoryLocalObjectsFilterData.LockUser Property.

UPDATE:

I am little surprised that the code returning the items checked by one user only. But there is a alternate approach as well, though it may take much time to run the script but it should serve the puspose.

1. get all the users using getSystemWideList
2. Iterate through the user, and use your same code but set RepositoryLocalObjectsFilterData.LockUser Property to the user.
3. collect the results from each iteration.

Answer 2

There was a defect in 2013 (and SP1) that caused administrators to no longer see items checked out by other users. This has been addressed in a hotfix.

Until it is available for download on SDL Tridion World, I'd advice you to contact Customer Support and reference CM_2013.1.0.88013 (assuming you are on 2013 SP1).

Answer 3

Please check the similer question with answer in below link:

How do I get a list of checked out items with the Core Service?