Opmanager - how to find devices without a notification profile

Hi,

Can you provide a query (MSSQL and MySQL) to list any managed devices where I don't have a notification profile attached?

Many thanks,

Dean