Got it working, I had messed up the table itself. Never mind! From: [email protected] [mailto:[email protected]] On Behalf Of Sherry Kissinger Sent: Wednesday, October 21, 2015 11:47 AM To: [email protected] Subject: Re: [mssms] Reporting on users in Administrators group
You could rip out all of the craziness about the "reliability" of the data, based on the last hinv and the last eval, and just look at the actual data: select sys1.netbios_name0 ,lgm.name0 [Name of the local Group] ,lgm.account0 as [Account Contained within the Group] , lgm.category0 [Account Type] , lgm.domain0 [Domain for Account] , lgm.type0 [Type of Account] from v_gs_localgroupmembers0 lgm join v_r_system_valid sys1 on sys1.resourceid=lgm.resourceid order by sys1.netbios_name0, lgm.name0, lgm.account0 The reliability of the data (based on last hinv vs. last ci eval) was an interesting thought ... but it is kind of confusing and overkill. On Wednesday, October 21, 2015 1:30 PM, "Murray, Mike" <[email protected]<mailto:[email protected]>> wrote: 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]>
