There are standard reports provided in LANDesk but none that would provide all of this information. A custom report would have to be created using Report Designer.
Are you looking to report blocked/detected files per machine? If not and are just looking for a list, it seems better to have a separate report for this.
The LD Report Landing page could help
For LDAV, looks like the information is in the Antivirus table in the database. (ProductName and DefVersion columns)
For blocked files, etc- looks like this is in the PatchHistory table. The 'Type' column looks like what defines patches vs LDAV records. The table also contains a table named ActionDate (to retrieve the last 30days)
Type 0= patches
Type 80= LDAV records
I was able to pull all of this information from the database using crystal reports thanks for all your help.
I'm trying to generate a query in LANDesk to pull the action 80 items.
Where can I find this information in the inventory scans?
I've found other action items like windows updates but I don't see which fileds to pull from when building the query.