→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
PFDTOC
Engaged Sweeper
Hello,

We are looking for a little bit more of an advanced report that shows up for the Active Directory tab. When you click on an OU with computers in it, you get a list with:

Assetname, Description, OS, SP, Proc, Memory, IP, Lastseen

I was wondering if I could get some additional fields added to this report to easily print off info for our OUs. What I'm looking to add:

ChassisName, last AD user (using full name, not login name), Computer Manf. and Computer Model.

I understand this would be a custom report most likely.. 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.

If you need me to explain further, I will.

Thanks!
1 REPLY 1
Hemoco
Lansweeper Alumni
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.

We strongly advise against doing this, as making changes to automatically generated pages is likely to break Lansweeper functionality. You can use the custom report below instead.
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