Getting SQL code for canned reports

[GMFDE]

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.

[Susan_A · Accepted solution]

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.

[Daniel_B]

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