How to create Database view between Catalog Task and Asset Table

[SourabhAkiwate]

Hello All,

I have requirement that create report on, which assets has been assigned to user who is Requested for from catalog task table.

Could you please help me out to create report through script or through Database view ?

Thank you,

Sourabh A

[Ankur Bawiskar]

@SourabhAkiwate 

on catalog task where are you storing the asset? some custom field or OOB one?

If yes then you can join sc_task table and alm_asset table

what did you start with and where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Brad Bowman]

Requested for is not a field on the Catalog Task table.  Are you viewing the field from the Request (sc_request) or Requested Item (sc_req_item) table on your Catalog Task form, or do you have a custom field on the sc_task table?  If you are viewing from one of the other tables, in the report do you need to see fields from sc_task specifically (like Catalog Task number), or will a join on whichever (RITM or REQ) show you the fields you need?

[SourabhAkiwate]

Hello @Ankur Bawiskar ,

We are not storing asset on sc_task table.

Actually I need a report on : Assets owned by requested for (catalog task) table.

[Ankur Bawiskar]

@SourabhAkiwate 

you can join sc_req_item and alm_asset as per @Robert H 

If my response helped please mark it correct and close the thread so that it benefits future readers.