Searching for an Umbraco User
These are three different SQL commands that filter userLogin, id and userEmail respectivly. They should be used independantly.
SELECT TOP (1000) * FROM [dbo].[umbracoUser] WHERE userLogin = '<user>' SELECT TOP (1000) * FROM [dbo].[umbracoUser] WHERE id = <3> SELECT TOP (1000) * FROM [dbo].[umbracoUser] WHERE userEmail = '<your.email@company.com>'
Note: Anything with in the greater/less than parentheses should be replaced with your filter parameters.