Jump to content
twilson

Additional Condition - Internal Monitor Filtering

Recommended Posts

Posted (edited)

Hello,

We copied and modified an internal monitor for free space alerting and we're looking to add another condition to look for 'online' computers only. This is what we currently have in the 'Additional Condition' field:

Drives.Size > 20480 and Drives.FileSystem not in ('ERR','CDFS','UNKFS','DVDFS','FAT','FAT32','NetFS')  and Drives.free < 4096 and Drives.internal=1 and Drives.Missing !=1 and Drives.Model not like '%USB%'

Would we need to add another AND condition at the end of the above like this?:

and Computers.Uptime >= 0 AND DATE_ADD(Computers.LastContact, INTERVAL 15 MINUTE) > NOW(), 1, 0) as `Computer.LabTech.IsOnline`

I don't know a lick of SQL so any insight or pointers will be greatly appreciated.

Thank you,

Edited by twilson

Share this post


Link to post
Share on other sites

Try pasting the following code into your additional conditions after whatever you have in there:

AND computers.LastContact > DATE_ADD(NOW(),INTERVAL -15 MINUTE)

So it should look like this:

Drives.Size > 20480 
and Drives.FileSystem not in ('ERR','CDFS','UNKFS','DVDFS','FAT','FAT32','NetFS')  
and Drives.free < 4096 and Drives.internal=1 and Drives.Missing !=1 and Drives.Model not like '%USB%' 
AND computers.LastContact > DATE_ADD(NOW(),INTERVAL -15 MINUTE)

 

  • Thanks 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...