Hi,

I am putting some processes together for when an employee leaves our company.  Usually, our HR department emails us to find out what assets (hardware) is associated to that employee who is leaving.  HR then  contact them to let them know that we need this kit returned to the IT department upon their last day in the office. 

Currently we have different spreadsheets holding bits of information.  It is quite a tedious task to find out what someone has against them.  Therefore, i am planning to put all of the data into SDP so we have 1 central repository of data.  I am doing some testing at the moment and i can easily find out what hardware assets someone has against their name.  This works great.  However, how do i know easily what software is allocated to a certain person or machine.  If someone has a bit of software which we need to unallocate on SDP as we can use elsewhere, how can we easily see what is allocated against someone like we can with the hardware assets?

Scenario of what we want to happen with using SDP: 

-Someone hands in their notice

-HR ask the IT department to check SDP for all hardware and software assets against that person

-We send a report onto HR who then they inform the employee to make sure everything is ready on their last day at the company. 

-On the employee's last day at the company, they hand their hardware back to the IT department

-We then change the status of all hardware from In Use to In Stock

-We change the software from Allocated to Deallocate

It is the software section I am struggling with as it doesn't look like there is a search functionb against someone's name

Any ideas on how to around this?