How to export virus definition and client information in an excel format?
1. Log in the SEPM Console and Click on Monitor ---> Logs-----> View logs
2. Then click on Export ( This will create a text file with the name computer_status_export.txt)
3. Open Excel and Click File -> Open and select the computer_status_export.txt file to open
4. In the Text Import Wizard select Delimited and Click Next
5. In the Step 2 Check Comma and click next.
6. In the steps 3 select Text and Click Finish
This will export the logs in the Columns , which can be filtered accordingly as per requirement.
References
https://www-secure.symantec.com/connect/articles/how-export-virus-definition-and-client-information-excel-format