I saw that but when I tried to add caption0 the report went nuts. I found another link that also referenced Sherrys post and made adjustments to it and got what I wanted.
link: http://chadstech.net/sccm-report-of-os-types/ final sql: SELECT pr.datawidth0 [Processor bits] , pr.addresswidth0 [OS bits] , os.Caption0 [OS Name] , os.CSDVersion0 [Service Pack] ,COUNT(sys.resourceid) [Computers] FROM v_r_system sys JOIN v_gs_processor pr ON sys.ResourceID=pr.ResourceID inner join v_GS_OPERATING_SYSTEM os on sys.ResourceID = os.ResourceID GROUP BY pr.datawidth0, pr.addresswidth0, os.Caption0, os.CSDVersion0 ORDER BY pr.datawidth0, pr.addresswidth0, os.Caption0, os.CSDVersion0 On Mon, Mar 30, 2015 at 10:11 AM, Jason Sandys <[email protected]> wrote: > Here’s Sherry’s blog post on this: > http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx > > > > J > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *David Jones > *Sent:* Monday, March 30, 2015 7:58 AM > *To:* [email protected] > *Subject:* [mssms] Report on OS including bit type > > > > I remember a few years ago finding a post about a report to count OS > versions with OS bit value, not HW bit width. I can't seem to come across > that. Does anyone know what that is? I'm pretty sure it had to use a > something like v_gs_processor.datawidth0 to determine the OS bit before it > could count. > > > > Dave > > > >
