Reporting for new patchs
I need to create two reports, they will contain all the new downloaded patchs (status = active), during a certain period of time :
- One report for all new active downloaded patchs (type = SECURITY), for the last 24h hours.
- One report for all new active downloaded patchs (type = NON-SECURITY), for the last week.
I tried several tips (like the one with smart label..) and it not figure to work.
The patchs are not labelised.
The machines are (name of label = XX)
What i try to do is to make a report at the morning to see if some patchs have to be disabled (manually) before deployement.
I'm not very good at SQL, if someone have made it before, thanks for help ! :)