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!
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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:
select DISPLAY_NAME, DISPLAY_VERSION , THREAT, CATEGORY FROM SOFTWARE
ORDER BY CATEGORY, THREAT
LIMIT 10
Answered 08/17/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity