Asset report with department name
Hello,
I need to create a report of all assets but by department. The issue is that an asset is either allocated to a department, a workstation or a user.
So I was planning to build a query with some "join" in order to get the
- The workstation to which an asset is attached
- Then the user name to which a workstation is attached
- Finally, with the user name get the department name.
But I cannot figure out the link between the various table. Could you please give the name of the various table I need to query to achieve such a report ?
Thank you
Loic
I need to create a report of all assets but by department. The issue is that an asset is either allocated to a department, a workstation or a user.
So I was planning to build a query with some "join" in order to get the
- The workstation to which an asset is attached
- Then the user name to which a workstation is attached
- Finally, with the user name get the department name.
But I cannot figure out the link between the various table. Could you please give the name of the various table I need to query to achieve such a report ?
Thank you
Loic
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?