Query about software

[ced47]

Hi
I need to create a report with name of the computer, the user and the MS Office's version
I don't find how to make a relation between computer and software
Thank you

[ced47]

Thank you

[Hemoco · Accepted solution]

When linking tables to tblComputers you will be most commonly linking the “Computername” fields in both tables. You do this by “grabbing” (left-click and hold) the Computername field from one table and dragging it to the Computername name field of the other table. Let go of your left mouse button to see the connection appear. Right-click on a connection and choose Remove to delete it.

Most tables will automatically link to tblComputers on the Computername field when they are added to a query. Connections to other fields are also possible and are created in the same way as described above.

For the particular report you are after, please try the SQL code below.

Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Username, tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSoftware.Installdate,
tblSoftware.Lastchanged
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.softwareName Like '%microsoft office%' And
tblSoftware.SoftwarePublisher Like '%microsoft%'
Order By tblComputers.Domain, tblComputers.Computer, tblSoftware.softwareName