good morning.I found these instructions for two separate reports, covering average CPU and RAM usage:CPU:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, Cast(Avg(tblPerformanceCountersScanMetric.Value) As int) As [Average CPU usage in %...

Good morning.I found this to be perfect, but it does count based on the ip and not the location map. How can I replace the location with the iplocation?Select Top 1000000 tblSoftwareUni.softwareName As Software, tblSoftware.softwareVersion As Versio...