[ZendTo] Finding unclaimed drop off's.

[Martel, Michael H.]

As is usual, I suspect if I just didn't drink as much coffee I might find the answer before I post.

It appears that I can do this :

select rowID,created from dropoff left join pickup on dId = rowID where dID is null;

And that appears to produce what I am looking for.  

DOH.  Sorry to waste your time!


Michael

-- 

  --------------------------------o---------------------------------
   Michael H. Martel              | Director of Data Center Administration
   michael.martel at vsc.edu         | Systems and Security Administrator
   Vermont State Colleges         | PH:802-224-3010 FX:802-224-3035

-----Original Message-----
From: ZendTo <zendto-bounces at zend.to> On Behalf Of Martel, Michael H. via ZendTo
Sent: Tuesday, February 26, 2019 10:05 AM
To: zendto at zend.to
Cc: Martel, Michael H. <michael.martel at vsc.edu>
Subject: [ZendTo] Finding unclaimed drop off's.

This message is from an external sender. Please be careful when clicking on links and attachments.



Greetings!

We are in the midst of setting up a new ZendTo server to replace our old one, and were wondering if we can see if there are any unclaimed drop off's before we replace the old server ?

I assume, I will need to get into the database and write a query of some sort, but was hoping someone had already done it.

Thanks!


Michael

--

  --------------------------------o---------------------------------
   Michael H. Martel              | Director of Data Center Administration
   michael.martel at vsc.edu         | Systems and Security Administrator
   Vermont State Colleges         | PH:802-224-3010 FX:802-224-3035


_______________________________________________
ZendTo mailing list
ZendTo at zend.to
https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fjul.es%2Fmailman%2Flistinfo%2Fzendto&data=02%7C01%7Cmichael.martel%40vsc.edu%7C64182a6ab1ca4ab71c4808d69c05d94a%7Cb17e9703dbdd49fa909c03dfd13086af%7C1%7C0%7C636867946282926303&sdata=Cnw9AugL2qyKAkcCIQ%2BxMYFbwS%2BYY3h0%2FC8JX2Tyb9g%3D&reserved=0