→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
GeneDi
Engaged Sweeper
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
2 REPLIES 2
GeneDi
Engaged Sweeper
CC,

outstanding.....you are a genius.

Thank you

GeneDi
CyberCitizen
Honored Sweeper
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.

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