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%'
