report for OS name

[Srikanth08]

Hi,

I need one custom report showing the following items..

Computer name

OS name with full details standard/Enterprise etc..

User name

Really urgent..kindly provide me the SQL code for that..

[Srikanth08]

Thanks this is the exact report i wanted..

[Hemoco]

Please try the following report instead:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Caption As
OScaption, tblComputers.Username
From tblComputers Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Order By tblComputers.ComputerUnique

[Srikanth08]

Thanks..but in this report it is telling only as windows 2000 no professional or standard like that..then how i can manage? i require full details..any help?

[Hemoco]

Please try the following report:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description As
OSdescription, tblComputers.Username
From tblComputers Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Order By tblComputers.ComputerUnique