Mac OS computers without purchase date.sql

select MACHINE.NAME as MNAME, OS_NAME,MACHINE.OS_VERSION,MACHINE.LAST_SYNC, MACHINE.CLIENT_VERSION
                            from ORG1.MACHINE left join MACHINE_DISKS on MACHINE.ID = MACHINE_DISKS.ID  
                  LEFT JOIN KBSYS.KUID_ORGANIZATION O ON O.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION C ON C.KUID = MACHINE.KUID AND O.ORGANIZATION_ID = 1
                 where (((  OS_NAME like '%Mac%') AND (1 not in (select 1 from ORG1.MACHINE_CUSTOM_INVENTORY where MACHINE.ID = MACHINE_CUSTOM_INVENTORY.ID and MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID = 25152 and MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE like '%/%')) )) GROUP BY MACHINE.ID