I went through this blog post. I've got the query working properly in SQL Management Studio, but when I run it in a report, it's just blank. It returns ~16k rows in the query. Any ideas?
https://walidhegazy.wordpress.com/2014/09/11/sccm2012-r2-collect-local-group-users-custom-report/ Best Regards, Mike Murray Desktop Management Coordinator - IT Support Services California State University, Chico 530.898.4357 [email protected]<mailto:[email protected]>
