Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
agresbach
Engaged Sweeper
I have a report (below) which generates a list of computers with specific software (in this example Adobe Acrobat) and contains the OU that the user is a member of so that we can export a report and breakdown by department if need be which is working well . I am trying to find a way to add in a column for that users Manager Name so that we can break it down further (each department has different managers). Would anyone have any idea what I can do to add this in?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblADusers.OU,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tblADusers.ManagerADObjectId
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Adobe Acrobat XI Standard%' And
tblAssetCustom.State = 1


0 REPLIES 0

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now