‎06-19-2017 09:27 PM
‎06-27-2017 08:33 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Memory,
tblAssets.Username,
tblADusers.Displayname As [Full Name],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblADusers.Description,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblSoftwareUni.Approved,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftware.Installdate,
tblADComputers.OU As [PC AD OU],
tblADComputers.Description As [PC AD Description]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblADusers On tblAssets.Username = tblADusers.Username And
tblAssets.Domain = tblADusers.Userdomain
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tblAssets.AssetName Like '%0%' And tblSoftwareUni.softwareName Not Like
'%bcgov%' And tblSoftwareUni.softwareName Not Like '%hotfix%' And
tblSoftwareUni.softwareName <> 'Bitlocker Protection Status' And
tblSoftwareUni.softwareName Not Like '%setlocalgroup%' And
tblSoftwareUni.softwareName Not Like '%config%' And
tblSoftwareUni.softwareName Not Like '%trendmicro%' And
tblSoftwareUni.softwareName Not Like '%redist%' And
tblSoftwareUni.softwareName Not Like '%rsalPrin%' And
tblSoftwareUni.softwareName Not Like '%linePlug%' And
tblSoftwareUni.softwareName Not Like '%ortbundle%' And
tblSoftwareUni.softwareName Not Like '%kwavepl%' And
tblSoftwareUni.softwareName Not Like '%LocAccntMa%' And
tblSoftwareUni.softwareName Not Like '%be flash player 24%' And
tblSoftwareUni.softwareName Not Like '%jre 1.8.0.112%' And
tblSoftwareUni.softwareName Not Like '%appvdeskt%' And
tblSoftwareUni.softwareName Not Like '%printermigra%' And
tblSoftwareUni.SoftwarePublisher <> 'Intel Corporation' And
tblAssetCustom.State = 1
Order By tblSoftware.Installdate Desc
‎06-27-2017 08:18 PM
‎06-27-2017 07:44 PM
‎06-27-2017 06:25 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now