Access HPSM Tickets from Excel/similar

We are looking at accessing Ticket from the Excel(Report). This excel report is sent to X person who has access to HPSM, so what we need is to create/add a Hyper-link for the Ticket Number part on Excel - upon clicking that Ticket number on excel report, it should redirect the use to HPSM login page & then to the Ticket details.

The problem we are facing is with the "queryhash" and when we try other ways it just gives us the Logout page.

Any options or directions please?

we are currently on HPSM9.35 Classic version(Non-PD)

 

thanks in advance.

sanzz