→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
scio
Engaged Sweeper
Hello,
I would like to ask. We have a custom report but I don't know how to change the link on computer to clickable. It is really messy report but It is working fine if we don't touch it very much:) Don't you know please how to change it? Here it is:


Select Top 1000000 c.Computer,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As Umístìní,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1,
c.Computername As pocitac
From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer




Thank you very much!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try with the following report:

Select Top 1000000 c.Computer as assetname,
c.Computername As assetid,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As Umístìní,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1

From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer

View solution in original post

2 REPLIES 2
scio
Engaged Sweeper
That did the trick! Thank you very much!
Hemoco
Lansweeper Alumni
Please try with the following report:

Select Top 1000000 c.Computer as assetname,
c.Computername As assetid,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As Umístìní,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1

From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer

New to Lansweeper?

Try Lansweeper For Free

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

Try Now