Jump to content
zigstick

Change linked to Application Configuration Item Detail

Recommended Posts

Hello, first time board user so go easy on me. I need to create a report that shows the  approvers for change tickets.  From the ticket, I can get to the approver name by selecting, in order: Additional Info tab, Config. Items, and from there selecting the application name.  That brings up the configuration item detail info which shows the approvers name.

We user Crystal Reports 2008 for repoting, but I could use either Crystal or SQL if I understood the linking required.  Any suggestions would be VERY appreciated as I'm stumped.

Thanks much!

mark

Share this post


Link to post
Share on other sites

Please note that a Change Order can have multiple Configuration Items linked to it. The linking table is usp_lrel_asset_chgnr.The "chg" column is a foreign key to the "id" column of the chg table and the "nr" column is a foreign key to the "own_resource_uuid" column of the ca_owned_resource table.

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...