→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Johanas
Engaged Sweeper
Hi

I am trying to find in the Lansweeper database where the following is displayed.

AKZACNTL2055.anglo.local Non-active

Thanx
2 REPLIES 2
Johanas
Engaged Sweeper
Thanx.
Johan
Hemoco
Lansweeper Alumni
Computer states are stored in the tblCompCustom.State field of the Lansweeper database. An example report can be seen below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.FQDN, tblComputers.Domain, tblCompCustom.State,
tblstate.Statename
From tblComputers Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Inner Join
tblstate On tblstate.State = tblCompCustom.State
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.