Page 1 of 1

Plugin Status

Posted: Tue Jul 18, 2017 2:20 pm
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?

Re: Plugin Status

Posted: Tue Jul 18, 2017 3:51 pm
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;

Re: Plugin Status

Posted: Wed Jul 19, 2017 4:33 pm
by CAbkeith
Thank you. I will look into this today!

Re: Plugin Status

Posted: Wed Jul 19, 2017 4:52 pm
by CAbkeith
Looks like my network drives aren't populating to the networkdrives table. I'll get with support on this. Thanks!