I have been asked to create a report from TRIM. I had a look at the report builder within TRIM but it wasn't going to do the job. I can created the query no worries I just need to know where the data and relationships are. Does anyone have a data dictionary for TRIM 7.3? I have tried created an ERD diagram from within SQL managment studio but it's not that great. If someone has a data dictionary that explains the tables and columns that would be fantastic.
A few years ago the powers that be at HP stopped making such information publicly available. They no longer distribute ERD's or data dictionaries for TRIM/HPRM.
As you've already discovered, you can create your own ERD from SQL Server. If this doesn't give you enough information to figure out what you're trying to achieve, you can log a support case with HP explaining exactly what you're trying to report on, and which bits of data you're having trouble figuring out (though when it comes to divulging deep dark secrets about how security such as caveats are handled in the tables, you may hit a brick wall.)
Sometimes you can discover what you need to know by running the HPRM client as an administrator user, viewing the activity log pane, and enabling logging in the dataset tab. Then when you perform operations/queries you'll see which tables/fields it's accessing.
Note: Any posts I make on this forum are my own personal opinion and (unless explicitly stated) do not constitute a formal commitment on behalf of HPE.
(Please state the version of CM you're using in all posts.
HPE Software Support Online (SSO): https://softwaresupport.hpe.com/