→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ced47
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
ced47
Engaged Sweeper
Thank you
Hemoco
Lansweeper Alumni
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