cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kschrantz
Engaged Sweeper II
I read the note about adding the field Computername to the output of the report to get the resulting drill down link.

I don't get the desired result (the whole computername column does not show, just the caption and portname).

to keep it simple my code is

************************************************************************
Select Top 1000000 tblComputers.Computername, tblPrinters.Caption,
tblPrinters.Portname
From tblComputers Inner Join
tblPrinters On tblComputers.Computername = tblPrinters.Computername
************************************************************************

What am I missing?
2 REPLIES 2
kschrantz
Engaged Sweeper II
That did it. Have I said recently that Lansweeper ROCKS!

well... Lansweeper ROCKS!!!
Hemoco
Lansweeper Alumni
You also need to include tblcomputers.computerunique field

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now