cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Srikanth08
Engaged Sweeper II
Hi,
Iam looking for a software report sorted as department wise..Kindly provide me the query to run because sql query i dont know..
Regards, Srikanth08
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

5 REPLIES 5
Hemoco
Lansweeper Alumni
It you add the user you cannot make the software total count or group by department.
Srikanth08
Engaged Sweeper II
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..
Regards, Srikanth08
Hemoco
Lansweeper Alumni
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
Engaged Sweeper II
we need the department of last logged on user in that system..

so that we can segregate
Regards, Srikanth08
Hemoco
Lansweeper Alumni
Do you need the department of:
Last logged on user
Custom field
Active directory computer object