Skip to content
This repository has been archived by the owner on Feb 14, 2024. It is now read-only.

Create Cybersixgill Views #182

Closed
9 tasks done
aloftus23 opened this issue Apr 25, 2022 · 3 comments · May be fixed by #195
Closed
9 tasks done

Create Cybersixgill Views #182

aloftus23 opened this issue Apr 25, 2022 · 3 comments · May be fixed by #195
Assignees
@aloftus23 @arng4108
Labels
improvement This issue or pull request will add or improve functionality, maintainability, or ease of use

Comments

@aloftus23
Copy link
Contributor

aloftus23 commented Apr 25, 2022 •
edited by arng4108
Loading

💡 Summary

Limit data manipulation in the python scripts by creating views in the Postgres database.

  1. Social Media Mentions
  2. Dark Web Mentions
  3. Asset Alerts
  4. Executive Alerts
  5. Threat Actors
  6. Potential Threats
  7. Invite-only markets
  8. Most Active Sites
  • Social Media Mentions, "vw_darkweb_socmedia_mostactposts"
  • Dark Web Mentions, "vw_darkweb_mentionsbydate"
  • Asset Alerts, "vw_assetalerts"
  • Executive Alerts, "vw_darkweb_execalerts"
  • Threat Actors, "vw_darkweb_threatactors"
  • Potential Threats, "vw_darkweb_potentialthreats"
  • Invite-Only Markets, "vw_darkweb_inviteonlymarkets"
  • Most Active Sites, "vw_darkweb_sites"
  • All views accounted for, no remaining tasks
@aloftus23 aloftus23 added the improvement This issue or pull request will add or improve functionality, maintainability, or ease of use label Apr 25, 2022
@aloftus23 aloftus23 self-assigned this May 1, 2022
@aloftus23 aloftus23 mentioned this issue May 3, 2022
Draft
9 tasks
@stewartl97
Copy link
Contributor

Need status and identify remaining tasks.

@arng4108
Copy link
Contributor

@stewartl97 All the views mentioned in this issue have been created and are functioning in the PE staging DB

@arng4108
Copy link
Contributor

arng4108 commented Dec 6, 2022

All CyberSixGill views mentioned have been created and are accounted for in the database

@arng4108 arng4108 closed this as completed Dec 6, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@aloftus23 aloftus23

@arng4108 arng4108

Labels
improvement This issue or pull request will add or improve functionality, maintainability, or ease of use
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

2- Create and implement Cybersixgill views cisagov/pe-reports
3 participants
@stewartl97 @aloftus23 @arng4108