Trying to get an update analysis report done and the canned reports in WSUS isn't cutting it. When you view a report, you have 2 export options; Excel and PDF.
Excel is preferable because I can easily throw into an Access DB (or any other RDMS), and do some queries. But when the report is of a certain size, the .xls
file seems to become broken. For example, I'm trying to do any export on a single machine showing all updates to. The resulting .xls
file comes out to be about 81 MB. When it's open, I get the following error:
Excel found unreadable content in 'Update Report for server1.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.
Of course I click yes, but when it is "recovered", nothing is showed in the work book. The PDF option isn't that great because of the formating. Are there any other options aside from entering all 30,000 entries manually?
runas
and opened up Excel. Still running into the same problem :/