
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2013 04:32 AM
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?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2013 02:08 PM
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
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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2013 06:59 PM
Perfect, thanks for the quick response.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2013 02:08 PM
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
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
