Active Directory Report for AD Group and group membership and their managers email

[powerut12]

Hello,

I am trying to create a Lansweeper report that includes group membership of a specific group and each user in that groups manager's email. Is this possible? Any help would be appreciated. 

[DavidPK]

Hi 

We have added a sample report that will get you started.  

Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/knowledgebase/how-to-add-a-report-to-your-lansweeper-installation/

If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial: https://www.w3schools.com/sql/
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-database-documentation/
• Checking out our report library: https://www.lansweeper.com/report/

Select Top 1000000 tsysOS.Image As icon,

  tblAssets.AssetID,

  tblAssets.AssetName,

  tblAssets.Domain,

  tblAssets.Username,

  tblAssets.Userdomain,

  tblAssets.IPAddress,

  tblAssets.Firstseen,

  tblAssets.Lastseen,

  tblAssets.Lasttried,

  tsysOS.OSname

From tblAssets

  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID

  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode

Where tblAssets.AssetID Not In (Select tblADComputers.AssetID

  From tblADComputers Left Join tblADMembership

      On tblADMembership.ChildAdObjectID = tblADComputers.ADObjectID Left Join

    tblADGroups On tblADMembership.ParentAdObjectID = tblADGroups.ADObjectID

  Where tblADGroups.Name Like 'SP-%') And tblAssets.AssetID Not In (Select

    tblADComputers.AssetID

  From tblADComputers Left Join tblADMembership

      On tblADMembership.ChildAdObjectID = tblADComputers.ADObjectID Left Join

    tblADGroups On tblADMembership.ParentAdObjectID = tblADGroups.ADObjectID

  Where tblADGroups.Name Like 'Baseline-%') And tblAssetCustom.State = 1 And

  tblComputersystem.PartOfDomain = 1

Order By tblAssets.Domain,

  tblAssets.AssetName