How to export list of user accounts and their home folders

Question

I know how to export a list of users from .sdf file using "SQL Server Compact" query but I don't see a column for the user account home folder.

Answer 1

The home folder can be different for each site, so there's a table called SiteUser that maps users to sites. This table has a NodeID, which is the foreign key of the user's home folder, which is stored in the Node table.

SELECT UserName AS UserName, Configuration AS Path FROM [User]
INNER JOIN SiteUser ON SiteUser.UserID=[User].UserID
INNER JOIN Node ON SiteUser.NodeID=Node.NodeID
INNER JOIN Site ON SiteUser.SiteID=Site.SiteID
WHERE Site.System=0