Looking for help in creating a report that list computers with XP and SP3 listed. Report 100 will give me the computers that I need but it does not list the OUs. I have been trying to add the OU column but not sure how to do it. Any help will be appreciated. Thanks

you can use v_RA_System_SystemOUName to find System OU detials(column System_OU_Name0) given below: join v_RA_System_SystemOUName a ON sys.ResourceID=a.ResourceID Full Query look like this: Select SYS.Netbios_Name0, OPSYS.Caption0 as C054, OPSYS.Version0, OPSYS.CSDVersion0, OPSYS.InstallDate0, OPSYS.LastBootUpTime0, OPSYS.WindowsDirectory0, OPSYS.Description0,a.System_OU_Name0 from v_R_System SYS join v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID join v_RA_System_SystemOUName a ON sys.ResourceID=a.ResourceID where OPSYS.Caption0 like @os and IsNULL(OPSYS.CSDVersion0,'') like @sp order by SYS.Netbios_Name0 //Eswar Koneti @ http://eskonr.com/

You can also use the below query if you dont want to promopt values for OS and Service pack versions : Select SYS.Netbios_Name0, OPSYS.Caption0 as C054, OPSYS.Version0, OPSYS.CSDVersion0, OPSYS.InstallDate0, OPSYS.LastBootUpTime0, OPSYS.WindowsDirectory0, OPSYS.Description0, max(a.System_OU_Name0) as [OU] from v_R_System SYS join v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID join v_RA_System_SystemOUName a ON sys.ResourceID=a.ResourceID where OPSYS.Caption0 like '%xp%' and IsNULL(OPSYS.CSDVersion0,'') like '%3%' group by sys.netbios_name0, opsys.caption0, opsys.version0, opsys.csdversion0, opsys.installdate0, opsys.lastbootuptime0, opsys.windowsdirectory0, opsys.description0 order by SYS.Netbios_Name0//Eswar Koneti @ http://eskonr.com/

that was the ticket. Got all the information they need and more. Now to clone it and remove some of the columns. Thank you.