→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎04-21-2015 06:03 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.IPAddress,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Username,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon,
tblADComputers.OU
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblSoftwareUni.softwareName Like 'SOFTWARE_NAME %._ ' And
tblADComputers.OU Like '%COUNTRY% ' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version
Solved! Go to Solution.
‎04-23-2015 10:50 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.IPAddress,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Username,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon,
tblADComputers.OU
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where (tblSoftwareUni.softwareName Like 'iTunes 1.2.9%' Or
tblSoftwareUni.softwareName Like 'iTunes 1.3 Home Edition%') And
tblADComputers.OU Like '%COUNTRY %' And tblSoftware.Installdate < GetDate() - 7
And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version
‎04-23-2015 01:02 PM
‎04-23-2015 10:50 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.IPAddress,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Username,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon,
tblADComputers.OU
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where (tblSoftwareUni.softwareName Like 'iTunes 1.2.9%' Or
tblSoftwareUni.softwareName Like 'iTunes 1.3 Home Edition%') And
tblADComputers.OU Like '%COUNTRY %' And tblSoftware.Installdate < GetDate() - 7
And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version
‎04-22-2015 03:06 PM
‎04-21-2015 08:02 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.IPAddress,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Username,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon,
tblADComputers.OU
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblSoftwareUni.softwareName Like 'SOFTWARE_NAME %._' And
tblSoftwareUni.softwareName Like '%home edition' And
tblADComputers.OU Like '%COUNTRY%' And tblSoftware.Installdate < GetDate() - 7
And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now