Modify data shown in IP Location asset group report/widget

[lvvwd]

From the IP Locations Overview Widget, is it possible to modify the report that is generated when clickong on a subnet so that the client OS is included? If that is not possible, is there a report that will allow me to see PCs with their OS, and group those by subnet?

[lvvwd]

Perfect, thanks for the quick response.

[Hemoco · Accepted solution]

The report that is generated needs a parameter, so you can not change that.

You could use the following:

Select Top 1000000 tblAssets.AssetID,
tsysIPLocations.IPLocation,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tsysOS.OSname,
tblOperatingsystem.Caption,
tblAssets.SP,
tblAssets.Lastseen,
tsysOS.Image As icon,
tblOperatingsystem.OSProductSuite,
tblOperatingsystem.PlusProductID,
tblOperatingsystem.PlusVersionNumber,
tblOperatingsystem.ProductType,
tblOperatingsystem.SerialNumber
From tblAssets
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetCustom.State = 1
Order By tsysIPLocations.IPLocation,
tsysOS.OSname,
tblAssets.AssetName,
tblOperatingsystem.Caption