Vulnerabilities by asset

I am looking for a way to create a report that displays vulnerabilities by asset based on an asset group or site. Any guidance is appreciated.

And then also be able to create tickets (using Jira integration) by asset. Or allow me to chose per remediation plan. For instance, one workstation has 100 things that need to be done, but instead it came across as 100 different solutions/tickets. However, I could see that approach being helpful when the project is “Update Chrome on these 20 assets”.