I'd like to have a weekly report generated from PDM Professsional and emailed to a group of people showing all files in a specific state. The objective is to provide awareness on stalled efforts.
Report generator as itself doesn't allow automation. Sure you can make such query there but user have to push it himself.
I have done similar things directly to the database server as scheduled SQL Jobs.
Basically that can be done, but it's pretty tricky if you don't have higher understanding of SQL queries.
Example schedule to run every night in sql agent job:Select wanted data into #temptable
While Loop all email entries in #temptableIn every while you set needed variables(example select document name and path)
and create message variable combining text and thoseAlso set email as own variable
and send email using EXEC msdb.dbo.sp_send_dbmail
Use email variable to send email to correct user
Retrieving data ...