Cadet 3rd Class
Cadet 3rd Class
240 views

How to create a custom dashboard for Fortify SCA?

Hi Guys,

I'm a user of both Fortify on Demand and Fortify SCA, and i'm looking into creating a custom dashboard for executives outside of what the tools offer out of the box.  Does anyone have any experience connecting BI tools such as PowerBI to the database and generating dashboards? Example dashboards i'm trying to create are

  1. Enterprise/Application trend by severity over 1 year
  2. % of issues fixed from a set date
  3. OWASP Top 10 trend
  4. Developer triage trend
  5. Top fixed categories this week.
Labels (2)
0 Likes
1 Reply
Lieutenant Lieutenant
Lieutenant

Hi!

Do you have SSC? Because it has a good API REST to download data without going directly to the database. I used powershell to connect to MySQL and get some data also but I think it is more reliable to use the API.

Then you have to play a little with the API to understand filters and groups to get the information you want. For example OWASP or CWE classification are external lists and the way I use is grouping information with the exact IDs of these lists.

Hope this helps.

Veronica

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.