SecureMetrics PowerBI Template Docs
  • 👋Welcome to the SecureMetrics!
  • NIST CSF 2.0
    • NIST CSF 2.0 User Guide
  • Attack Surface Discovery
    • Attack Surface Discovery User Guide
  • SecureMetrics Risk Register
    • 🛠️Getting set up
      • 📑Risk Register
      • 📊Installing the PowerBI App
      • 🪄Connecting your data
      • 🪪Understanding licensing
    • 🥳Neat PowerBI Features
  • Astra PowerBI Plugin
    • ✨Welcome to Astra
    • 📓Release Notes
    • 💻PowerBI Visual Architecture and Data Security
  • Multicloud CIS Benchmarks with Prowler
    • Page 1
  • CIS Controls Reporting
    • Getting Started
  • Assessment & Data Import File
  • PowerBI Slide Template
  • Cyber Risk Quantification (CRQ) Community Edition
    • Welcome to CRQ Community
  • Using the Template
  • Understanding FAIR Inputs
  • Cyber Risk Quantification (CRQ) Pro
    • Welcome to CRQ Pro
  • Excel Model
  • PowerBI Model Report
  • PowerPoint Charts Template
Powered by GitBook
On this page
  • Getting Started
  • Step 1 - Install and run Amass from OWASP
  • Step 2 - Install a SQlite ODBC driver on your device
  • Step 3 - Copy the SQLite database file as path to clipboard
  • Step 4 - Open the PowerBI Template and provide the SQLite database filepath when prompted
  1. Attack Surface Discovery

Attack Surface Discovery User Guide

PreviousNIST CSF 2.0 User GuideNextGetting set up

Last updated 9 months ago

SecureMetrics' Attack Surface Discovery PowerBI Template allows security teams or consultants to report on their external-facing attack surface discovered using the

Note: there are two license versions for the Attack Surface Discovery Template: Internal & Consultant. There is no difference between the template, only the licensing terms.

Getting Started

When you purchase the Attack Surface Discovery PowerBI Template, you will receive a download with the following items:

  1. PowerBI template file (.pbit)

  2. Sample database file (.sqlite)

The PowerBI template will connect to a local sqlite database to load data into the dashboards. This database is auto-generated by the discovery engine, Amass. Your purchase also includes a sample database for testing connectivity.

Step 1 - Install and run Amass from OWASP

In order to use this template, you will need to install and run the open-source attack surface discovery tool Amass, by OWASP. Because the dashboards connect directly to the Amass database, there are few requirements on how you operate the tool.

You can install Amass in a variety of methods, as

In order to populate the database, you'll need to run a discovery using Amass. Because the PowerBI template is pulling directly from the Amass Sqlite database, you can run multiple discoveries over time for continuous reporting.

There are many options to get the most out of Amass. However, the easiest way to get started is to run the following command:

amass enum -dir ./your-output-directory -d example.com

Note: Make sure you use the -dir flag to denote the output directory for ease of management. You can choose to keep one central database, or create a new database for each discovery (such as different clients). If a database is already present in the output directory, Amass will append the results to it. If no database is present in the output directory, it will create a new one.

Step 2 - Install a SQlite ODBC driver on your device

Step 3 - Copy the SQLite database file as path to clipboard

Locate the SQLite database file generated by Amass. It will be located in the output directory and defaults to the filename amass.sqlite.

Step 4 - Open the PowerBI Template and provide the SQLite database filepath when prompted

Whenever you open the PowerBI template file (.pbit), you will be prompted for the location of the SQLite database file. Paste the path, removing the quotations (") if present.

That's it!

You can now either use the dashboard locally in PowerBI Desktop, or publish to the PowerBI Service to host in the cloud.

Unfortunately, you cannot connect to a SQLite database by default in PowerBI. In order to accomplish this, you will need to download and install a SQLite ODBC driver such as this open-source one:

http://www.ch-werner.de/sqliteodbc/
open-source tool OWASP Amass.
described in their documentation.
Copy the path to the generated SQLite database file
Load data