→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎03-28-2013 04:46 PM
‎03-29-2013 05:50 PM
PFDTOC wrote:
but can we edit the default report that is gone when clicking on an OU in the AD tab? From the URL, looks like this report is web50FindbyDomainandOU.
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblADComputers.OU,
tblAssets.Description As LocalDescription,
tblADComputers.Description As ADDescription,
tsysOS.OSname,
tblAssets.SP,
tblAssets.NrProcessors,
tblAssets.Memory,
tblAssets.IPAddress,
TsysChassisTypes.ChassisName,
tblADusers.Firstname,
tblADusers.Lastname,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Lastseen
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblADComputers.OU,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now