---
title: Find Animals without Due Reminders (SQL)
description: VetLinkPro Find Animals without Due Reminders
---

# VetLink PRO

 Connecting Veterinary Professionals with Smarter Solutions

[Skip to content](https://help.vetlinkpro.com/vetlinkpro/find-animals-without-due-reminders#main-content)

English - Australia

Show submenu for translations

![Vetlinkpro - Intergrity - excellence - clarity](https://help.vetlinkpro.com/hs-fs/hubfs/MAIN_2026-1.png?width=528&height=160&name=MAIN_2026-1.png)

Open main navigation

Close main navigation

- English - Australia
  
  Show submenu for translations
- Contact us

 Contact us

 How can we help you?

- There are no suggestions because the search field is empty.

1. [VetLink PRO](https://help.vetlinkpro.com/vetlinkpro)
2. [Support](https://help.vetlinkpro.com/vetlinkpro/support)
3. [Exports](https://help.vetlinkpro.com/vetlinkpro/support#exports)

# Find Animals without Due Reminders (SQL)

## v6,v7

See [Create Export to CSV using SQL Query](https://help.vetlinkpro.com/vetlinkpro/create-export-to-csv-using-sql-query) for information on using query below for export to csv.

 

 SELECT am."Ref\_Number" AS "Patient Number",  
(SELECT gad."Name" FROM "Get\_Animal\_Details"(am."Ref\_Number") gad) AS "Patient Name",  
(SELECT gad."Type" FROM "Get\_Animal\_Details"(am."Ref\_Number") gad) AS "Species",  
(SELECT gad."Breed" FROM "Get\_Animal\_Details"(am."Ref\_Number") gad) AS "Breed",  
(SELECT gad."Gender" FROM "Get\_Animal\_Details"(am."Ref\_Number") gad) AS "Gender",  
(SELECT gad."Neuter" FROM "Get\_Animal\_Details"(am."Ref\_Number") gad) AS "Desexed",  
am."Date\_Birth" AS "Date of Birth",  
am."Owner" AS "Owner Number",  
(SELECT gcd."First\_Name" FROM "Get\_Client\_Details"(am."Owner") gcd) AS "Owner First Name",  
(SELECT gcd."Last\_Name" FROM "Get\_Client\_Details"(am."Owner") gcd) AS "Owner Last Name",  
(SELECT gcd."Mobile" FROM "Get\_Client\_Details"(am."Owner") gcd) AS "Mobile",  
(SELECT gcd."Email" FROM "Get\_Client\_Details"(am."Owner") gcd) AS "Email"  
FROM "Animal\_Main" am  
WHERE am."Status" = 'A'  
AND (am."Deceased" IS NULL OR am."Deceased" \<\> 'Y')  
AND NOT EXISTS (  
    SELECT 1  
    FROM "Reminders" r  
    WHERE r."Sub\_Num" = am."Ref\_Number"  
    AND r."Status" = 0  
    )  
and am."Ref\_Number" \> 10000001000  
ORDER BY am."Ref\_Number"

- [Support](https://help.vetlinkpro.com/vetlinkpro/support#main-content)

    - [Client Portal](https://help.vetlinkpro.com/vetlinkpro/support#client-portal)
    - [Creditors](https://help.vetlinkpro.com/vetlinkpro/support#creditors)
    - [Upgrade](https://help.vetlinkpro.com/vetlinkpro/support#upgrade)
    - [Payments](https://help.vetlinkpro.com/vetlinkpro/support#payments)
    - [Patient](https://help.vetlinkpro.com/vetlinkpro/support#patient)
    - [Product](https://help.vetlinkpro.com/vetlinkpro/support#product)
    - [Xero](https://help.vetlinkpro.com/vetlinkpro/support#xero)
    - [Clinical History](https://help.vetlinkpro.com/vetlinkpro/support#clinical-history)
    - [RDS Setup](https://help.vetlinkpro.com/vetlinkpro/support#rds-setup)
    - [Client](https://help.vetlinkpro.com/vetlinkpro/support#client)
    - [Diary](https://help.vetlinkpro.com/vetlinkpro/support#diary)
    - [Mailers](https://help.vetlinkpro.com/vetlinkpro/support#mailers)
    - [Exports](https://help.vetlinkpro.com/vetlinkpro/support#exports)
    - [Stocktake](https://help.vetlinkpro.com/vetlinkpro/support#stocktake)
    - [Reports](https://help.vetlinkpro.com/vetlinkpro/support#reports)
    - [EOP / Statements](https://help.vetlinkpro.com/vetlinkpro/support#eop-statements)
    - [Eforms / Digital Forms](https://help.vetlinkpro.com/vetlinkpro/support#eforms-digital-forms)
    - [Other](https://help.vetlinkpro.com/vetlinkpro/support#other)
    - [Printing](https://help.vetlinkpro.com/vetlinkpro/support#printing)
    - [Email](https://help.vetlinkpro.com/vetlinkpro/support#email)
    - [Server / Technical](https://help.vetlinkpro.com/vetlinkpro/support#server-technical)
    - [Insurance](https://help.vetlinkpro.com/vetlinkpro/support#insurance)
    - [Bill](https://help.vetlinkpro.com/vetlinkpro/support#bill)
    - [Vac Reminders](https://help.vetlinkpro.com/vetlinkpro/support#vac-reminders)
    - [Online Booking](https://help.vetlinkpro.com/vetlinkpro/support#online-booking)
    - [Mobile Billing](https://help.vetlinkpro.com/vetlinkpro/support#mobile-billing)
    - [Barcoding](https://help.vetlinkpro.com/vetlinkpro/support#barcoding)
    - [SMS](https://help.vetlinkpro.com/vetlinkpro/support#sms)
    - [General Ledger](https://help.vetlinkpro.com/vetlinkpro/support#general-ledger)
    - [Staff](https://help.vetlinkpro.com/vetlinkpro/support#staff)
    - [Telemedicine](https://help.vetlinkpro.com/vetlinkpro/support#telemedicine)
- [Manual](https://help.vetlinkpro.com/vetlinkpro/manual#main-content)

    - [6.1](https://help.vetlinkpro.com/vetlinkpro/manual#6-1)
    - [7.0](https://help.vetlinkpro.com/vetlinkpro/manual#7-0)

[![Vetlinkpro - Intergrity - excellence - clarity](https://help.vetlinkpro.com/hs-fs/hubfs/MAIN_2026-1.png?width=528&height=160&name=MAIN_2026-1.png "Vetlinkpro - Intergrity - excellence - clarity")](https://www.vetlinkpro.com)

<https://www.facebook.com/> <https://www.twitter.com/> <https://www.instagram.com/> <https://podcasts.apple.com/> [mailto:email@email.com](mailto:email@email.com)

Copyright © 2026, VetlinkPRO