cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ESIT
Engaged Sweeper
Trying to run the built in Software Report in lsbuilder and it's coming up with no data. We have plenty of data and I've run other reports with success. Here is the the SQL and I haven't done any kind of modification to it:

SELECT
web30repsoftwaretotal.Software,
web30repsoftwaretotal.Version,
web30repsoftwaretotal.Publisher,
web30repsoftwaretotal.Total,
tblADusers.Username
FROM
tblADusers
INNER JOIN web30repsoftwaretotal ON (tblADusers.Username = web30repsoftwaretotal.Version)

This looks like what I'm trying to get, but again, no results. I created one that kind of works, but it displays multiples of the same software and version resulting in way too many rows. I need a report that displays something similar to this:

Adobe Reader 9.0.0 total: 450
Adobe Reader 9.5.0 total: 100
Adobe Photoshop 12.0.0 total: 45

That would list all software, the version, and the totals.

Thanks.
3 REPLIES 3
Hemoco
Lansweeper Alumni
What about : "Select * From web30repsoftwaretotal"
Hemoco
Lansweeper Alumni
Your join is wrong "ON (tblADusers.Username = web30repsoftwaretotal.Version)"
You need to join the same fields in the tables.
ESIT
Engaged Sweeper
Lansweeper wrote:
Your join is wrong "ON (tblADusers.Username = web30repsoftwaretotal.Version)"
You need to join the same fields in the tables.


I guess I don't exactly understand what I need to change. Any way you could post an example code based off what I need from the original post?

Thanks!

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now