→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
Old name: Software: No dotnet framework 1.1 (Built-in)

The report below lists all computers not having .NET framework 1.1 installed
  • The asset state is set to "active".
  • The asset has been successfully scanned at least once.
  • The asset does not have dotnet framework 1.1 installed.
  • The asset is a Windows computer.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssets.Lasttried,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tblAssets.LocationID =
tsysIPLocations.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName = 'Microsoft .NET Framework 1.1') And
tblState.Statename = 'Active' And (tsysAssetTypes.AssetTypename = 'Windows' Or
tsysAssetTypes.AssetTypename = 'Windows CE')
Order By tblAssets.Domain,
tblAssets.AssetName
0 REPLIES 0