LabTech Support Forums

Computer Status Field and Table

This forum is for discussion of MySQL database related issues.

Moderator: jware.connectwise

Computer Status Field and Table

Postby nathan.fullymanaged » Mon Jul 16, 2012 9:24 pm

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,
nathan.fullymanaged
Newbie
Newbie
 
Posts: 2
Joined: Mon Jul 09, 2012 11:36 am

Re: Computer Status Field and Table

Postby ctapp.absithelp » Tue Jan 15, 2013 12:03 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.
ctapp.absithelp
Newbie
Newbie
 
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 7 guests