Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jcorso11
Engaged Sweeper
I created a report to show me all computers running a program with mozilla in name.

Great. Now I need to link to something to get the description field (Username here) to be included in report.

Right now, it looks like this.

Thanks

SELECT
tblSoftware.SoftwarePublisher,
tblSoftware.softwareVersion,
tblSoftware.softwareName,
tblSoftware.ComputerName
FROM
tblSoftware
WHERE
tblSoftware.SoftwarePublisher LIKE '%mozilla%'
1 REPLY 1
Hemoco
Lansweeper Alumni
try this:

SELECT     dbo.tblComputers.Computername, dbo.tblSoftware.SoftwarePublisher, dbo.tblSoftware.softwareVersion, dbo.tblSoftware.softwareName, 
dbo.tblComputers.Domain, dbo.tblComputers.Userdomain, dbo.tblComputers.Username
FROM dbo.tblSoftware INNER JOIN
dbo.tblComputers ON dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername
WHERE (dbo.tblSoftware.SoftwarePublisher LIKE '%mozilla%')

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now