# Building Investigative Solutions **URL:** https://community.siren.io/c/building-investigative/8.md [Latest](https://community.siren.io/latest.md) · [Categories](https://community.siren.io/categories.md) --- ## [About the Building Investigative Solutions category](https://community.siren.io/t/about-the-building-investigative-solutions-category/26)
**Author:** [@jccq](https://community.siren.io/u/jccq)\ **Replies:** 0
Use cases and applications of the Siren Platform across sectors. Questions? Ideas? Join us here --- ## [Plugin to fetch data from Acta Publica](https://community.siren.io/t/plugin-to-fetch-data-from-acta-publica/342)
**Author:** [@Martin\_Fredriksson](https://community.siren.io/u/Martin_Fredriksson)\ **Replies:** 1\ **Last updated:** [November 25, 2020, 9:14am UTC](https://community.siren.io/t/plugin-to-fetch-data-from-acta-publica/342 "2020-11-25T09:14:47Z")
Attached is a plugin I wrote that connects to Acta Publica API. Acta Publica is a document archive covering more than 600 Swedish authorities, including the courts and prosecution offices. It expects input in “short SSN… --- ## [Dancho Danchev - Law Enforcement and OSINT Intelligence Operation "Uncle George" - Seeking Siren Community Support](https://community.siren.io/t/dancho-danchev-law-enforcement-and-osint-intelligence-operation-uncle-george-seeking-siren-community-support/167)
**Author:** [@ddanchev](https://community.siren.io/u/ddanchev)\ **Replies:** 0\ **Last updated:** [December 2, 2019, 3:33pm UTC](https://community.siren.io/t/dancho-danchev-law-enforcement-and-osint-intelligence-operation-uncle-george-seeking-siren-community-support/167 "2019-12-02T15:33:18Z")
Hi everyone, My name is Dancho Danchev I’m an internationally recognized (https://ddanchev.blogspot.com) cybercrime researcher security blogger and threat intelligence analyst that has recently launched Law Enforcement … --- ## [Nested objects - Handling](https://community.siren.io/t/nested-objects-handling/161)
**Author:** [@mmuthukrishnan](https://community.siren.io/u/mmuthukrishnan)\ **Replies:** 1\ **Last updated:** [November 28, 2019, 4:12pm UTC](https://community.siren.io/t/nested-objects-handling/161 "2019-11-28T16:12:33Z")
Hello Everyone, As we have a limitation on nested objects for aggregation and searches in siren, Need to know how to handle the nested objects. Say for example you wanted to do a pie chart of gender. Gender is stored a… --- ## [Find out who traveled together more than once](https://community.siren.io/t/find-out-who-traveled-together-more-than-once/134)
**Author:** [@kokoroko](https://community.siren.io/u/kokoroko)\ **Replies:** 3\ **Last updated:** [October 15, 2019, 3:14pm UTC](https://community.siren.io/t/find-out-who-traveled-together-more-than-once/134 "2019-10-15T15:14:58Z")
Hey guys. I have a table with thousands of bus travel records, telling who was on the buses. What would you do at Siren to find out people who traveled more than once with suspect X? --- ## [Create link analysis graph based on sql server database data](https://community.siren.io/t/create-link-analysis-graph-based-on-sql-server-database-data/106)
**Author:** [@danarardhito](https://community.siren.io/u/danarardhito)\ **Replies:** 3\ **Last updated:** [August 1, 2019, 10:27am UTC](https://community.siren.io/t/create-link-analysis-graph-based-on-sql-server-database-data/106 "2019-08-01T10:27:40Z")
Good afternoon, I’m looking for a link analysis graph solution which can create a relation between 2 or more data. right now I have SQL database data which I want to relate it between those data. my data are consist of… --- ## [Drug repositioning investigation workflow on a “virtualized” Knowledge Graph](https://community.siren.io/t/drug-repositioning-investigation-workflow-on-a-virtualized-knowledge-graph/54)
**Author:** [@jccq](https://community.siren.io/u/jccq)\ **Replies:** 0\ **Last updated:** [May 12, 2019, 5:16pm UTC](https://community.siren.io/t/drug-repositioning-investigation-workflow-on-a-virtualized-knowledge-graph/54 "2019-05-12T17:16:25Z")
Heads up, part one of the article by Siren Life Science specialist Andrew Winter is available here: describes some of what can be done on a pretty advanced Siren deployment that we’re happy to demonstrate to intereste… --- ## [Product Brief - Siren for Financial Crime](https://community.siren.io/t/product-brief-siren-for-financial-crime/44)
**Author:** [@john.campbell](https://community.siren.io/u/john.campbell)\ **Replies:** 0\ **Last updated:** [April 11, 2019, 8:20am UTC](https://community.siren.io/t/product-brief-siren-for-financial-crime/44 "2019-04-11T08:20:04Z")
Hi! For all those interested this document is a good starting point to understand what Siren offers for financial crime investigations. --- ## [Large life science knowledge graph integration demo available soon](https://community.siren.io/t/large-life-science-knowledge-graph-integration-demo-available-soon/41)
**Author:** [@Frocco](https://community.siren.io/u/Frocco)\ **Replies:** 0\ **Last updated:** [April 11, 2019, 1:00am UTC](https://community.siren.io/t/large-life-science-knowledge-graph-integration-demo-available-soon/41 "2019-04-11T01:00:47Z")
Hi all just a heads up we are going to be writing about our large “starter pack” life science knowledge graph integration in 2 blogs posts in the next few weeks (the first one this week actually). Just as a teaser here… --- ## [What does Siren add on top of Elasticsearch for Cybersecurity?](https://community.siren.io/t/what-does-siren-add-on-top-of-elasticsearch-for-cybersecurity/40)
**Author:** [@Frocco](https://community.siren.io/u/Frocco)\ **Replies:** 0\ **Last updated:** [April 11, 2019, 12:35am UTC](https://community.siren.io/t/what-does-siren-add-on-top-of-elasticsearch-for-cybersecurity/40 "2019-04-11T00:35:48Z")
Supercharging ELK for cybersecurity Elasticsearch is an outstanding storage for security related logs. With its ability to scale, search and drill down, it provides a great basis for investigation. The Siren Federate p… --- ## [Threat hunting with Siren, by Pellegrino](https://community.siren.io/t/threat-hunting-with-siren-by-pellegrino/39)
**Author:** [@Frocco](https://community.siren.io/u/Frocco)\ **Replies:** 0\ **Last updated:** [April 10, 2019, 10:57pm UTC](https://community.siren.io/t/threat-hunting-with-siren-by-pellegrino/39 "2019-04-10T22:57:02Z")
Heads up on a quite interesting article by written by Patrick Pellegrino, Senior Cybersecurity Analyst where Siren is used to investigate malware behavior. " The heavy lifting of the remaining tasks is completely left…