FAQShop.com : Is there a Way to Query for Failed Client Installations?

Is there a Way to Query for Failed Client Installations?

I've recently inherited an SMS program that is about 80% functional. On the clients that were successfully discovered and installed with the client agents...no complaints.

However, is there a way that I can query SMS to give me names (either computer names, but hopefully "last logged on user") of machines that failed to install the clients?

I have about 1700 clients on three different campuses, and the 150+ clients that failed are going to be a nightmare to track down without some automation.

Contributed By: Wally Mead [MS]
You could create a query to find all discovered resources that have a value for System Resource - Client of 0. An installed client would have a value of 1.