cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Flexera beginner

Is there a way to determine the request an attachment is associated with?

FNCI 6.x -- attachments to requests are kept under  {install-dir}/config/core/attachments/{mmddyyyy}_ {nnnnnnnnn}_{username}_{attachment filename}

I am not sure what the {nnnnnnnnn} number is -- I assume it is a timestamp?

Is there a way to determine from this filename what request the file is attached to?

It would very useful if an attachment name could be mapped back to the request to which it is attached.

thanks,

  Michelle

Labels (1)
0 Kudos
1 Reply
Flexera
Flexera

Re: Is there a way to determine the request an attachment is associated with?

Michelle,

You can get the request ID associated with a given attachment from the database using the query below:

SELECT ENTITY_ID_ FROM PAS_ATTACHMENT WHERE ENTITY_TYPE_ = 'R' AND NAME_ = 'ATTACHMENT_FILE_NAME';

Hope that helps,

-Alex

0 Kudos