08-21-2012 11:34 AM
Solved! Go to Solution.
12-09-2014 10:37 AM
nickt wrote:
When I paste this into a new report I get the following message.
Invalid SELECT statement. Unknown object name: "tblComputers".: Unexpected token "tblComputers" at line 0, column -1
Any help would be appreciated.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName,
software,
version
12-09-2014 10:37 AM
nickt wrote:
When I paste this into a new report I get the following message.
Invalid SELECT statement. Unknown object name: "tblComputers".: Unexpected token "tblComputers" at line 0, column -1
Any help would be appreciated.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName,
software,
version
12-02-2014 01:50 PM
08-23-2012 04:52 PM
Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Description, tblComputers.Firstseen, tblComputers.Lastseen,
tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher, tblSoftware.Lastchanged,
SoftwareCount.[Total Installations]
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join
(Select Count(tblSoftware.ComputerName) As [Total Installations],
tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher
From tblSoftware Inner Join
tblComputersystem On tblComputersystem.Computername =
tblSoftware.ComputerName
Where tblComputersystem.Domainrole > 1
Group By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblSoftware.SoftwarePublisher) SoftwareCount On SoftwareCount.softwareName
= tblSoftware.softwareName And SoftwareCount.softwareVersion =
tblSoftware.softwareVersion And SoftwareCount.SoftwarePublisher =
tblSoftware.SoftwarePublisher
Where tblComputersystem.Domainrole > 1
Order By tblSoftware.softwareName, tblSoftware.softwareVersion,
tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now