software Report - not on PC

[GeneDi]

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

[GeneDi]

CC,

outstanding.....you are a genius.

Thank you

GeneDi

[CyberCitizen]

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