
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-11-2020 05:21 PM
Hi Everyone,
New and a novice so please be gentle...
looking to create a report that shows computers that do not have a certain software name/title. When I do produce the report it shows all computers with every software title on that computer. I just want that computer name to appear once with that missing software title.
thank you in advance,
GeneDi
New and a novice so please be gentle...
looking to create a report that shows computers that do not have a certain software name/title. When I do produce the report it shows all computers with every software title on that computer. I just want that computer name to appear once with that missing software title.
thank you in advance,
GeneDi
Labels:
- Labels:
-
General Discussion
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-12-2020 04:05 PM
CC,
outstanding.....you are a genius.
Thank you
GeneDi
outstanding.....you are a genius.
Thank you
GeneDi


Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-12-2020 08:48 AM
There are two way's to complete this.
You can use a dynamic group or a report.
Try the following report just change the line Microsoft .NET Framework 3% note the % sign is used as a wildcard. So you can either use the exact software name or if there are various names like Project 2010, Project 2016 you can either search %project% or Project 2010.
You can use a dynamic group or a report.
Try the following report just change the line Microsoft .NET Framework 3% note the % sign is used as a wildcard. So you can either use the exact software name or if there are various names like Project 2010, Project 2016 you can either search %project% or Project 2010.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like 'Microsoft .NET Framework 3%') And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
