→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
DIDE
Engaged Sweeper
Is there any possible way to make a listing (report) which lists the windows network logonserver (system variable %logonserver%)?
I need this because we have mutiple sites and some clients are authenticating to different DC's.
Havign this list will show me who has this problem.
Thank you
1 REPLY 1
Hemoco
Lansweeper Alumni
You could create a report listing domain controllers or machines that have the NETLOGON share. An example report can be seen below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblShares.Caption, tblShares.Name, tblShares.Path,
tblShares.Type, tblShares.Lastchanged
From tblComputers Inner Join
tblShares On tblComputers.Computername = tblShares.Computername
Where tblShares.Name Like '%NETLOGON%'
Order By tblComputers.ComputerUnique


To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now