
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-03-2013 09:37 PM
Is there anyway to find java version by using lansweeper? Thanks for your help.
Kevin
Kevin
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
‎12-06-2013 06:15 PM
This is an example report list of all Java software for the active assets:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssetCustom.Location,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblOperatingsystem.Caption As OS,
tblOperatingsystem.ServicePackMajorVersion As SP
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblSoftwareUni.softwareName Like '%Java%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
Software
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssetCustom.Location,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblOperatingsystem.Caption As OS,
tblOperatingsystem.ServicePackMajorVersion As SP
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblSoftwareUni.softwareName Like '%Java%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
Software
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2013 06:15 PM
This is an example report list of all Java software for the active assets:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssetCustom.Location,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblOperatingsystem.Caption As OS,
tblOperatingsystem.ServicePackMajorVersion As SP
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblSoftwareUni.softwareName Like '%Java%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
Software
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssetCustom.Location,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblOperatingsystem.Caption As OS,
tblOperatingsystem.ServicePackMajorVersion As SP
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblSoftwareUni.softwareName Like '%Java%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
Software
