Tuesday, July 10, 2012 6:07 PM
I'm looking for a Software Update report that I haven't seen anywhere. I'd like to look at every system in the environment and report on which specific updates have failed. I don't want to filter on collection or deployment package or update list. I just want to know if an update tried to install on a workstation and failed. Columns would have the name of the update and the count of systems it's failed on (sorted by highest failures on top). I'd like to have each update able to be clicked on so that i can see which specific systems have failed, the returned failure code, and the last status date.
Has anyone seen a report like this? I did see a nice one here: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/2e9f5954-add8-4651-bd56-db02adf631c9
But, it filters based on deployment package and doesn't let you drill down to see which systems actually have which state. Good for an overall view, but wouldn't be very useful for finding which systems need to be looked at.
- Moved by Matthew Hudson [MVP]MVP Saturday, July 14, 2012 12:16 PM (From:Configuration Manager 2007 General)
Tuesday, July 10, 2012 6:49 PM
The reason you don't see one is because it is just plain not easy to do. I'm assuming it would need to be some kind of massive pivot type tempdb thing, and you're talking millions, perhaps billions of rows to parse through, convert into columns, and indicate compliant or not.
All I can say is... "Good Luck!"
Standardize. Simplify. Automate.
Tuesday, July 10, 2012 7:20 PMYou would think there would be an easier way. In WSUS all you need to do is create a view and sort a column. Done. Seeing which updates are failing easilly would be a common thing admins would be looking to have I'd imagine. :/