cancel
Showing results for 
Search instead for 
Did you mean: 

Data Dictionary for TRIM Database

Highlighted
mattbuglisi
Acclaimed Contributor

Data Dictionary for TRIM Database

Hi Guys,

 

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.

 

Cheers,

 

M

2 REPLIES
mattbuglisi
Acclaimed Contributor

Re: Data Dictionary for TRIM Database

Anyone?

ANY documents relating to the database tables would be fantastic.

Neil Summers
HPE Expert

Re: Data Dictionary for TRIM Database

Hi Matt,

 

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.


Neil

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. At any given time, HPE are supporting approx. 30+ released versions)

HPE Software Support Online (SSO): https://softwaresupport.hpe.com/
//Add this to "OnDomLoad" event