cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Cobra7
Champion Sweeper
I have a report as follows:

Select tblComputerSystemProduct.Name, tblComputers.Computername, tblComputers.Lastseen, tblComputers.Username, tblComputerSystemProduct.IdentifyingNumber From tblComputers Inner Join tblComputerSystemProduct On (tblComputers.Computername = tblComputerSystemProduct.Computername) Where tblComputerSystemProduct.Name = 'OptiPlex 745'


Works great. My manager would like to turn the IdentifyingNumber into a support link like the action page of the web site, any way to do easily that?
3 REPLIES 3
Hemoco
Lansweeper Alumni
Try this :
Select tblComputerSystemProduct.Name, tblComputers.Computername, tblComputers.Lastseen, tblComputers.Username, <a href="http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?ServiceTag=' + tblComputerSystemProduct.IdentifyingNumber + '">Support link</a>' as link From tblComputers Inner Join tblComputerSystemProduct On (tblComputers.Computername = tblComputerSystemProduct.Computername) Where tblComputerSystemProduct.Name = 'OptiPlex 745'
Cobra7
Champion Sweeper
Sorry, I must be doing something wrong.

Select tblComputerSystemProduct.Name, tblComputers.Computername, tblComputers.Lastseen, tblComputers.Username, <a href="http://support.dell.com/support/topics/global.aspx/support/my_systems_info/details?ServiceTag=' + tblComputerSystemProduct.IdentifyingNumber + '">Support link</a> From tblComputers Inner Join tblComputerSystemProduct On (tblComputers.Computername = tblComputerSystemProduct.Computername) Where tblComputerSystemProduct.Name = 'OptiPlex 745'
Hemoco
Lansweeper Alumni
You can inject the sql directly into the query:

... ,'<a href="http://somesite.html?id=' + tblComputerSystemProduct.IdentifyingNumber + '">linktext</a>' as link from ....

New to Lansweeper?

Try Lansweeper For Free

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

Try Now