Help modifying existing report / View

[snowens]

I am tring to modify this existing report and or view, I need help finding the report located in:
Click on Active directory computer overview
Click on an OU with computers in it then I see:
- <web40FindbyDomainandOU>
<ComputerUnique>OU\OR2GLSLB1\1</ComputerUnique>
<Icon>seven10.png</Icon>
<Computername>72</Computername>
<Description />
<OS>Win 7</OS>
<SP>0</SP>
<Proc>1</Proc>
<Speed>2992</Speed>
<Memory>4096</Memory>
<IP>128.120.219.170</IP>
<Lastseen>2010-06-29T09:27:26.857-07:00</Lastseen>

I want to add the last user who logged onto this computer to the results, how would I do this and is there more documentation on the report builder that I can review?

Thanks
Shaun

[Hemoco]

try this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblADComputers.OU, tblComputers.Description,
tblADusers.Displayname, tblOperatingsystem.Caption, tblComputers.LastknownIP
From tblComputers Inner Join
tblADComputers On tblComputers.Computername = tblADComputers.Computername
Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain

[snowens]

Can I build a custom report that includes:

Computer OU
Computer Name
Computer Description
Computer OS
Computer IP
Name of user that last logged onto this computer

What tables would I use and what links would I use?

Thanks
Shaun

[snowens]

Checking on updates, please advise...........

Thanks
Shaun

[snowens]

Can I create a custom report using the fields below plus the last user who logged onto this computer to the results? I don't see the web40FindbyDomainandOU stored procedure in the report builder, other tables to use perhaps?

Shaun

[Hemoco]

web40FindbyDomainandOU cannot be changed by the report builder because it is a stored procedure.

You can manually change it using sql server management studio but we don't support this.

[Hemoco]

Lansweeper wrote:
web40FindbyDomainandOU cannot be changed by the report builder because it is a stored procedure.

You can manually change it using sql server management studio but we don't support this.

You will have to use sql management studio but we don't support editing the predefined stored procedures.