
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2016 03:19 PM
I am trying to create a report that will have all the assets that do not have Java installed on them. I have this report that shows all of them that are not at the current version:
I tried to modify it, for NOT LIKE, but it should be all the software on all the assets that isn't Java. Not the assets that are missing java.
Any help would be appreciated, I am not a SQL guy.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.softwareVersion,
tblAssets.AssetName
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.softwareName Like '%Java%' And
tblSoftwareUni.SoftwarePublisher Like '%Oracle%' And
tblSoftware.softwareVersion Not Like '%8.0.740.2%' And tblAssetCustom.State =
1
Order By tblAssets.AssetName
I tried to modify it, for NOT LIKE, but it should be all the software on all the assets that isn't Java. Not the assets that are missing java.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.softwareVersion,
tblAssets.AssetName
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.softwareName Not Like '%Java%' And
tblSoftwareUni.SoftwarePublisher Not Like '%Oracle%' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
Any help would be appreciated, I am not a SQL guy.
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-2016 11:01 PM
There is a sample report in our report center that lists Windows computers missing a specific software package. You can find it here.
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-16-2016 02:26 PM
Oh thank you! I looked for something in there, must have missed that one!
Thanks again!
Thanks again!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2016 11:01 PM
There is a sample report in our report center that lists Windows computers missing a specific software package. You can find it here.
