simple and straight forward report that gives you the computers with operating system,CSD version(service Pack),Version number,OS Installed date,LastBootup time.windows Directory etc.
You can customise this by adding additional colums http://technet.microsoft.com/en-us/library/dd334593.aspx
and Creating Custom Reports By Using Configuration Manager 2007 SQL Views http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22052
Select SYS.Netbios_Name0, OPSYS.Caption0 as C054, OPSYS.Version0, OPSYS.CSDVersion0, OPSYS.InstallDate0, OPSYS.LastBootUpTime0, OPSYS.WindowsDirectory0, OPSYS.Description0
from v_R_System SYS
join v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID
order by SYS.Netbios_Name0
