I have the following query that I'd like to run in a report, click a selected statename and have it generate another detailed report with all assets that match that state.SELECT ts.Statename, ts.State, count(ta.AssetID) AS TotalFROM tblAssets AS ...
I'm seeing the exact same behavior. We did manage to get it work work once, but haven't been successful in other attempts. On the assets that were imported, they did not get inserted into the Intune device tables but were deposited in the Assets ta...
For those interested, here is how I was able to get it to work:Select Top 1000000 'http://SERVERNAME:81/Report/report.aspx?det=Web50getdevicebystate&title=All ' + ts.Statename + ' Assets&@state=' + Convert(NVARCHAR(2),ts.State) As hyperlink_hyp, ...