Weekly installed software using K1000
How can i run a report that shows all new software that has been installed on all computers?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
nshah
11 years ago
You could use this as a report and just change the interval. I will show you what was created and the display title regardless of who installed it.
SELECT created,display_name FROM SOFTWARE
WHERE NOW() < DATE_ADD(created,INTERVAL 7 DAY);
