
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2009 07:46 PM
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%'
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%'
Labels:
- Labels:
-
Report Center
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-03-2009 10:33 AM
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%')
