SQL Query Export Example: Asset Discovery

Document created by erikc Employee on Jan 10, 2014Last modified by zeroorone on Apr 17, 2014
Version 3Show Document
  • View in full screen mode

Reporting on discovered assets has historically been one of our most frequently requested features here in support.   I am pleased to announce that this feature is now easily available using the new SQL query export feature.  The following is a description of the fact_asset_discovery table and the information it provides.

 

fact_asset_discovery

Level of Grain: A snapshot of the discovery dates for an asset.

Fact Type: accumulating snapshot

Description: The fact_asset_discovery fact table provides an accumulating snapshot for each asset within the scope of the report and details when the asset was first and last discovered. The discovery date is interpreted as the precise time that the asset was first communicated with during a scan, during the discovery phase of the scan. If an asset has only been scanned once both the first_discovered and last_discovered dates will be the same.

 

This query will provide you with the following:

 

  • Asset IP Address
  • Asset Hostname
  • Asset MAC Address
  • Asset First Discovered Date
  • Asset Last Discovered Date

 

To utilize this table to report this data via the SQL query export feature, you can now use a query formed like the following:

 

SELECT da.ip_address, da.host_name, da.mac_address, fad.first_discovered, fad.last_discovered

FROM fact_asset_discovery fad

   JOIN dim_asset da USING (asset_id)

 

To know more about our SQL Query Export feature, please check out the introductory blog.

Attachments

    Outcomes