Clear Still infected status from Database
I am trying I am trying to figure out where in the database the still infected status flag is set. Currently I have a script that can check for Devices still infected and automatically create the Help Desk ticket to clean the virus. Now I need to find out how clear this status, so when the ticket is closed the still infected status is cleared.
I was able to find the still infected devices, using the inventorycurrentrisk & inventorycurrentvirus tables to create the tickets but when I change the deleted from 0 to 1 it does not clear the still infected status in the console. Any help on finding out how to clear this flag via the database would be greatly appreciated.