Does anyone have any information on how I can build a report to show all the machines that have LD Antivirus installed, the last time their defenitions were updates and if possible the last 30 days of what's blocked?
I searched but couldn't find anything here on the fourms.
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
I've seen how to build reports but I don't know what information or coloums to query from in order to pull defenition updates or what the software has blocked.
And Yes i'll need it per machine.
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.