Smart Label for new installed Desktops / Laptops
i've tried to create a smart label that lists all installed computer (laptops / desktops) since the 25th of october. Here is the code, i get no results, but computers are installed since this date. What did I wong?
select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME,
UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS
LEFT JOIN KBSYS.KUID_ORGANIZATION ON KUID_ORGANIZATION.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION ON SMMP_CONNECTION.KUID = MACHINE.KUID AND KUID_ORGANIZATION.ORGANIZATION_ID = 1
where ((( CHASSIS_TYPE like '%laptop%') AND OS_INSTALLED_DATE > '24.09.2012'))