Report Building

[darren_kimber]

I'd like to know if you can build a report from a drilled in view (attached Doc). For example I have a software from a vendor which I can drill into and then filter versions etc. I was hoping the 'New Report' option in the left pane would build a report based on that view.

Is this an option or could I suggest a feature?

Cheer
Darren

[Susan_A]

Have a look at this forum topic as well. There is a workaround for copying the queries of automatically generated pages. A built-in button is still on our customer wish list.

[Daniel_B · Accepted solution]

This is not currently possible. Many web console pages have special functions included, which can't be built into a report. For data about installed software we recommend having a look at the built-in report Software: List of software by computer. You could edit this report, save it as a copy and add some filters to it, i.e. to show only certain software products. The following report would only list software installations for SnapDrive:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblSoftwareUni.softwareName As software,
  tblSoftware.softwareVersion As version,
  tblSoftwareUni.SoftwarePublisher As publisher,
  tsysOS.Image As icon
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblSoftwareUni.softwareName Like '%snapdrive%' And tblAssetCustom.State =
  1
Order By tblAssets.AssetName,
  software,
  version