Case Studies

VioPoint - Power Shell Reports


Business Needs

VioPoint and their clients needed security solutions to handle multiple points of security standards. Their preexisting applications were in need of being updated, and new processes needed to be built to handle growth and customer needs. VioPoint needed reports that complied with client standards based and/or government regulation, reduced the number of vulnerabilities in their systems, and could be used to create a baseline to compare data. They also needed a PowerShell utility use cases to produce data based on specific criteria, which would then be updated and create a graphic representation of the report for the user. Different solutions were needed based on security vulnerabilities and scanning times.

Company Information

For more than 9 years, VioPoint has been helping organizations effectively manage the challenges of protecting critical business data. They understand the value of delivering results and each of their core offerings (testing, compliance, vulnerability management, and monitoring) are focused on this simple goal.   VioPoint’s experience transcends a broad range of clients that include leading industry segments.

Organizations work with VioPoint because they want to accelerate security program performance and establish a foundation for continued success.  If you are struggling to quantify results and faced with the all too common challenge of selling silence, VioPoint can help.

General Problem Description

VioPoint relied on PowerShell and Qualys to run their operations, as well as the operations of their clients. The existing PowerShell utility tools were in need of updates and a way to process new data. When VioPoint came to us, updates were needed that involved creating new reports and visual graphics in Excel so that user could quickly understand and process the data.

Solution

Spud Software utilized existing PowerSHell utilities and enhanced them to fit the needs of VioPoint’s clients. We expanded the functionality of the PowerShell Cmdlets to handle new use cases and adjusted existing use cases, and the utilities download data from both Qualys and Kenna. With the data from Qualys and Kenna, the utility would generate a report in either a CSV or Excel format. If CSV, it would list all of the data with column headers that the client had requested for that use case. The Excel format files would have multiple sheets, one for data similar to the CSV, and a second for visual charts. Charts varied from line graphs to stacked bar/column charts.


Technical Details

The utilities would call out to APIs for Qualys and Kenna through PowerShell commands using a web request and would then process the data to produce a CSV/Excel report. The Excel reports would contain charting of the data to show trends and the current status of the companies’ assets.

Spud Software, Inc. BBB Business Review