I'm trying to scope a canned report about compliance with a deployment, specifically "Software Updates - C Deployment States\States 4 - Computers in a specific state for a deployment", to a collection of computers. I'm not sure how best to do it. I've tried a couple of times without success and thought that there were some SQL guru's here that might be better at this than me. Basically I'd like "Computers with state 'Compliant' for 'Windows Server 2008R2 Updates Deployment' that are in the 'All Department Devices' collection " and ultimately a count too. I'm trying to provide compliance numbers to individual department heads based on their collections. Any direction anybody can point me in?
TIA Todd
smime.p7s
Description: S/MIME cryptographic signature
