Our Products:   CompleteFTP  edtFTPnet/Free  edtFTPnet/PRO  edtFTPj/Free  edtFTPj/PRO
0 votes
in CompleteFTP by (120 points)
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.

1 Answer

0 votes
by (48k points)

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