Threat level report
I would like to generate a report by software threat level or category (under Inventory/Software:Edit Software Detail/Metadata). I would also like this report to email out weekly. Does anyone have an idea on how to do this? There doesnt appear to be any ready made reports for this and I cant find it under the email alerts categories either. Any help would be much appreciated.
Thanks!
Thanks!
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
GillySpy
13 years ago
Take a look at the software table and the data you need is probably there. Also, it would help your request if you gave a sample layout.
A simple version would be:
A simple version would be:
select DISPLAY_NAME, DISPLAY_VERSION , THREAT, CATEGORY FROM SOFTWARE
ORDER BY CATEGORY, THREAT
LIMIT 10
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
