Service manger data to SCOM

Would there be a way to create groups for reporting automatically from my cmdb source in this case Service Manger. This would allow me to group things easily by application or tier.

I have done a similar configuration in our SCOM environment. I have setup an automatism based on SCOM which pulls data from our CMDB(Service manager). The base automatism ist setup like the way provided by Kevin Holman. For setting things up like this you need skills in PowerShell and SCOM MP Authoring. Also a Little in SQL for the query.

https://blogs.technet.microsoft.com/kevinholman/2017/10/12/how-to-create-a-scom-group-from-a-sql-cmdb-query/

Have you looked into using SCORCH (Orchestrator) and some PowerShell for this?

I was looking at SCORCH I have an upgrade to it and SCSM happening the end of the month so that we have all our System Center on a current build. I did not see a way to do it right off in my current build but hoping the 2016 build will add some functionality