LabTech Support Forums

Automatically Delete Missing Drives

This forum is for the discussion of all things related to the Computer Management Screen.

Moderator: jware.connectwise

Automatically Delete Missing Drives

Postby infotechmsp » Fri Nov 25, 2011 4:49 am

As the Online Documentation ( states for deleting missing drives:

Missing drives can be deleted as they are only kept for informational purposes. Removable drives, such as USB jump drives, will show up as missing drives and will be re-entered into the database as new drives when they are reinserted into the computer and the computer rescans its drives.

To delete a drive, right-click on the drive and select Delete.

I would prefer that these drives be automatically removed once they are disconnected or declared 'missing'. I understand that I can manually delete them...however does anyone know of a way that these missing drives can be automatically removed.
Posts: 9
Joined: Wed Dec 31, 1969 8:00 pm

Re: Automatically Delete Missing Drives

Postby alan.shearer.mclaneintel » Wed Nov 30, 2011 12:48 am

I believe its a known issue/feature request. I have opened a couple tickets about this with support. Even though the drives are inventoried every day, it does not always get rid of the drives that are no longer detected from the list.
Full Member
Full Member
Posts: 117
Joined: Sat Jan 22, 2011 7:31 pm

Re: Automatically Delete Missing Drives

Postby ntrahan.ntwo » Tue May 29, 2012 5:23 pm

I found a way to remove the missing drives automatically. I did it by creating a monitor to look for missing drives and then created a MySQL script to delete the findings.

I am attaching the screen shots. Hope that you find this helpful.
Remove Missing Drives Script.JPG
(45.45 KiB) Downloaded 10 times
Remove Missing Drives Monitor.JPG
(73.37 KiB) Downloaded 10 times
Posts: 2
Joined: Tue Jun 07, 2011 8:58 pm

Re: Automatically Delete Missing Drives

Postby omar.garcia.rgvemrit » Thu Jul 18, 2013 1:05 pm

I created a "maintenance script" with an sql Execute of

delete FROM `labtech`.`drives` where drives.Missing=1

I then went to dashboard/management/schedule client scripts - and scheduled the script to run after we swap the externals.
Jr. Member
Jr. Member
Posts: 62
Joined: Wed Dec 31, 1969 8:00 pm

Re: Automatically Delete Missing Drives

Postby beng.phase42 » Fri Jul 19, 2013 10:50 am

Great options.

For anyone new to LabTech, the monitor script is useful because it can be applied to a specific group client etc. While the scheduled script will apply globally.
In both you might also want to experiment with the WHERE clause to look for just USB drives or SD cards etc so you do not lose history on all "disconnected" drives.

For example if an ISCSI attached drive goes missing.

Rgds Ben

Sent from my GT-I9305T using Tapatalk 2
Full Member
Full Member
Posts: 153
Joined: Tue Aug 30, 2011 6:35 am
Location: Melbourne Australia

Return to Computer Management

Who is online

Users browsing this forum: No registered users and 1 guest