Plugin Status

Post Reply
CAbkeith
Posts: 6
Joined: Fri Jun 30, 2017 1:06 pm

Plugin Status

Post by CAbkeith »

Hello,

Is this plugin still being updated? I installed it a few weeks ago and have let it sit for a while. Checking on it today revealed it is not added all machines mapped drives to the tab. It is only showing a few of the machines mapped drives. Any idea what is going on?

User avatar
Cubert
Posts: 1531
Joined: Tue Dec 29, 2015 7:57 pm
Contact:

Re: Plugin Status

Post by Cubert »

The drives list is auto generated from LabTech's NetworkDrives table. LabTech populates that table as part of the daily audits being run against agents. See the query below, at the end of query it has a WHERE clause asking for client ID. Place any ID number to see the results for that client. Run query to verify that data is missing.

If this is not updating I would inquire with LT support on why this has stopped updating.


SQL query

Code: Select all

SELECT IF(c.LastContact > date_add(now(),interval -5 minute),'Yes','No') As Online, d.ComputerID, d.Letter, d.Model, d.User, c.Name As Computer, c.Domain, l.Name as Location, c.LastContact FROM networkdrives d  LEFT JOIN computers c on c.ComputerID = d.ComputerID LEFT JOIN locations l on l.locationID = c.LocationID WHERE d.ComputerID IN (SELECT ComputerID FROM computers WHERE ClientID = '1') Order By d.ComputerID;

CAbkeith
Posts: 6
Joined: Fri Jun 30, 2017 1:06 pm

Re: Plugin Status

Post by CAbkeith »

Thank you. I will look into this today!

CAbkeith
Posts: 6
Joined: Fri Jun 30, 2017 1:06 pm

Re: Plugin Status

Post by CAbkeith »

Looks like my network drives aren't populating to the networkdrives table. I'll get with support on this. Thanks!

Post Reply