Need Software Report as department wise

[Srikanth08]

Hi,
Iam looking for a software report sorted as department wise..Kindly provide me the query to run because sql query i dont know..

[Hemoco]

It you add the user you cannot make the software total count or group by department.

[Srikanth08]

Hi,.

Thanks for the quote..it is showing only the data..there is no facility to see inside the software who is the user..can you provide that one also..so that it is useful for us to find the user..

[Hemoco · Accepted solution]

Select tblADusers.Department, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
Count(tblSoftware.SoftwareID) As Total
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Group By tblADusers.Department, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
Order By tblADusers.Department, tblSoftware.softwareName

[Srikanth08]

we need the department of last logged on user in that system..

so that we can segregate

[Hemoco]

Do you need the department of:
Last logged on user
Custom field
Active directory computer object