Can Microsoft MBSA Record Server Vunerabilities to a SQL Server ?

CaussyR
CaussyR used Ask the Experts™
on
I have a number of server that I need to run MBSA and then analyse the data.  Can MBSA record server findings to a SQL DB ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Exec Consultant
Distinguished Expert 2018
Commented:
MBSA produces *.MBSA files which are  XML-based results and there can be text output (by default) when using Mbsacli.exe with suppressed output using the /qt (quiet text output) parameter and is the same output provided by the /ld (list report details) option. in short no direct option into SQL DB per se.

however, there are alternative indirectly to convert XML into the desired format e.g. sharing below which may work out to manual porting of those into sql db ...
(via the normal import into Excel) http://myitkit.blogspot.com.au/2012/10/how-to-convert-mbsa-scan-report-to-excel.html
(via powershell) http://fatbeards.blogspot.sg/2009/01/powershell-mbsa-logs.html

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial