
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-12-2015 06:53 PM
There are a number of canned reports such as dynamically generated reports like "All Unknown Items" report that might appear in the Asset Type Overview widget. When you open these reports, there is no "Edit" function. I understand you might not want to provide that feature, but would it be possible to have a function that exports the SQL code used to generate that report?
That would give users the ability to create new custom reports based upon that default code.
As always, thanks for a great product.
That would give users the ability to create new custom reports based upon that default code.
As always, thanks for a great product.
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
‎07-03-2015 02:10 PM
FYI: you can copy the queries of automatically generated pages by following the instructions in this forum topic. Not all pages read from a simple SQL query however.
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-03-2015 02:10 PM
FYI: you can copy the queries of automatically generated pages by following the instructions in this forum topic. Not all pages read from a simple SQL query however.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-15-2015 02:06 PM
Web console functions can't be edited because most of them require additional parameters or have special functions. The following report lists the output of "All Unknown items".
Select tblAssets.AssetName,
tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.IPAddress As [IP Address],
tsysAssetTypes.AssetTypename As Type,
tblAssets.Domain,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssetCustom.State As Thestate,
tblAssets.Lastseen,
Case
When (tblAssets.Assettype = -1 And Coalesce(tblAssets.OScode, '') =
'') Then 'red' Else 'black' End As foregroundcolor
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Where tblAssetCustom.State = 1 And tblAssets.Assettype = 0
Order By tblAssets.AssetName
