This forum is for discussion of MySQL database related issues.
I am wondering which field stores the Computer Status. What I mean by this is the field which determines if the computer is viewable in the LabTech Console or if it has been deleted.
The reason that I need this field is that I want to write queries which only query computers that are being managed currently by LabTech instead of the machines which are no longer being managed by labTech due to an uninstallation of the agent or deletion inside of LabTech.
Thank you in advance,
- Posts: 2
- Joined: Mon Jul 09, 2012 11:36 am
If you delete it inside of labtech, it's moved to retiredassets table. If you're looking for computers that haven't been retired but haven't checked in for quite some time, you can use the computers > last contact field to build the query and set your own threshold for what you consider to be monitors and not.
- Posts: 13
- Joined: Thu Nov 10, 2011 12:13 pm
Return to MySQL Database
Who is online
Users browsing this forum: No registered users and 1 guest