Reports

[blm]

Hi,

I wanted to know if there is a way to do reports which show me exactly what servers are Windows 2008 standard and which ones are 2008 enterprise etc...

Could you let me know please.

Thanks

[Hemoco]

try this:

Select Top 1000000 dbo.tblComputers.Computername,    dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,    dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon,    RTrim(LTrim(tblOperatingsystem.Caption + ' ' +    tblOperatingsystem.OtherTypeDescription)) As OS From dbo.tblComputersystem  Inner Join   dbo.tblComputers On dbo.tblComputersystem.Computername =      dbo.tblComputers.Computername Inner Join   dbo.web40ActiveComputers On  dbo.tblComputers.Computername =     dbo.web40ActiveComputers.Computername  Inner Join   Web40OSName On Web40OSName.Computername =  dbo.tblComputers.Computername   Inner Join   tblOperatingsystem On  dbo.tblComputers.Computername =     tblOperatingsystem.Computername Where  dbo.tblComputersystem.Domainrole > 1 Order By dbo.tblComputers.Computer