# Remediation Project Reporting

**URL:** <https://discuss.rapid7.com/t/remediation-project-reporting/5756>\
**Category:** InsightVM\
**Created:** [July 6, 2021, 8:15pm UTC](https://discuss.rapid7.com/t/remediation-project-reporting/5756 "2021-07-06T20:15:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nate.whistler\_nate.whistler](https://discuss.rapid7.com/letter_avatar_proxy/v4/letter/n/7c8e57/32.png) [@nate.whistler\_nate.whistler](https://discuss.rapid7.com/u/nate.whistler_nate.whistler)\
**Post date:** [July 6, 2021, 8:15pm UTC](https://discuss.rapid7.com/t/remediation-project-reporting/5756/1 "2021-07-06T20:15:01Z")

</div>

Is anyone doing reporting based on their remediation projects? We’ve been asked to generate a report of how many outstanding solutions are left, what’s been fixed, how much time is left in the project. It doesn’t look like there is a way to do it. Maybe a SQL query?

I find it surprising that this isn’t already something available or even remediation project alerting.

---

<div class="post-metadata">

**Author:** ![nate.whistler\_nate.whistler](https://discuss.rapid7.com/letter_avatar_proxy/v4/letter/n/7c8e57/32.png) [@nate.whistler\_nate.whistler](https://discuss.rapid7.com/u/nate.whistler_nate.whistler)\
**Post date:** [July 12, 2021, 6:38pm UTC](https://discuss.rapid7.com/t/remediation-project-reporting/5756/2 "2021-07-12T18:38:13Z")

</div>

I search a little more an answered my own question:

> [@Using API or SQL to get info from remediation projects](https://discuss.rapid7.com/t/using-api-or-sql-to-get-info-from-remediation-projects/2739):
>
> Hello, This might’ve been addressed in another topic, but I couldn’t find it. Is there a way to export information from the existing remediation projects (via API or SQL query)? I know I can go into the GUI and export via CSV, but we’d rather do it programmatically to build scripts that interact with our patching system. A good starting point would be to export all solutions titles from a given remediation project. Thanks!

---

<div class="post-metadata">

**Author:** ![holly\_wilsey](https://discuss.rapid7.com/user_avatar/discuss.rapid7.com/holly_wilsey/32/78_2.png) [@holly\_wilsey](https://discuss.rapid7.com/u/holly_wilsey)\
**Post date:** [July 12, 2021, 8:23pm UTC](https://discuss.rapid7.com/t/remediation-project-reporting/5756/3 "2021-07-12T20:23:08Z")

</div>

Sorry for the delay here, but glad you found what you were looking for. The topic you linked is indeed correct that there’s not currently a programmatic way to retrieve remediation project info for things like reporting. But thanks for posting, since this kind of feedback helps us understand what features/functionality folks are most interested in. 👍