Dear All,

Can I have a SQL Report demonstrating the Current Assigned User on the Assets and the Last Logged-in User. We would also like to have Current Assigned User "Reporting To" and, the "Department Name".

We would like to have below columns :

a) Product Type

b) Product Name

c) Asset Name

d) Assigned User

e) Asset State

f) Assigned User Reporting To

g) Assigned User Department

i) Last Logged-in User

Regards,

Wajahath Farooq