Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kdunnett
Engaged Sweeper II
Once a computer is marked as retired, will Lansweeper still report any of the software from it, in a software count report?
1 ACCEPTED SOLUTION
Esben_D
Lansweeper Employee
Lansweeper Employee
By default, only assets in the "Active" state will be displayed in the reports. In the reports themselves, this is indicated with Where tblAssetCustom.State = 1.

Every state has their own specific code, alternatively you can add tblState and the field tblState.Statename to use the names of the field instead of the number.

View solution in original post

1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
By default, only assets in the "Active" state will be displayed in the reports. In the reports themselves, this is indicated with Where tblAssetCustom.State = 1.

Every state has their own specific code, alternatively you can add tblState and the field tblState.Statename to use the names of the field instead of the number.

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now