Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2012 09:09 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2012 10:43 AM
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.
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
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2012 01:49 PM
Thank you
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2012 10:43 AM
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.
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
