How do I create an email alert for new computers within one day that don't have certain software installed?
I've been trying to configure an email alert but can't quite get it to do what I want - I am trying to make an email alert that will shoot off an email once a day that will show a list of computers that do not have a certain software title installed and have only new computers for that day - their record was created or agent installed in the last day. Can anyone point me to some information how to configure this?
Community Chosen Answer
I can give you part of the answer. The sql down below will give you any new machines that have been created or just checked in for today. I would modify that code to include an and with the software packages you are looking for that are missing.
select DATE_FORMAT(CREATED,'%W %m-%d-%Y') as CREATED1, MACHINE.NAME as MACHINE_NAME, SYSTEM_DESCRIPTION, IP, MAC, REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as USER_LOGGED, CS_DOMAIN, CREATED as CREATED_TIME from MACHINE where DATE_FORMAT(CREATED,'%m%d%Y') =5118012 order by CREATED_TIME
Put your AND statement after the date to filter out the software.