→ 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: 
lspiehler
Engaged Sweeper
I'd like to be able to put custom variables in the request URL for a report that can be used in the SQL for the report. This would allow me to create reports that link to other reports to drill down further. Is this possible? Thank you!

Example:

Report URL:
https://<my_lansweeper_fqdn>/Report/report.aspx?det=web50rep71990cb431c84d3cb821db94db6e2cac&title=Lyas+-+Test&dhcpserver=0.0.0.0

Report SQL:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblAssetCustom.State = 1 And tblNetwork.DHCPserver = '%dhcpserver%'
0 REPLIES 0