cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Srikanth08
Engaged Sweeper II
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..
Regards, Srikanth08
4 REPLIES 4
Srikanth08
Engaged Sweeper II
Thanks this is the exact report i wanted..
Regards, Srikanth08
Hemoco
Lansweeper Alumni
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
Engaged Sweeper II
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?
Regards, Srikanth08
Hemoco
Lansweeper Alumni
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