
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-09-2016 10:41 PM
I am trying to create a report to generate Computer names and last logged in user.
My final goal would be to match last user to AD property "MangedBy", but I don't if that's possible. If it is the I would like to flat it if there is a difference.
Can lansweeper read AD properties?
Thank you.
My final goal would be to match last user to AD property "MangedBy", but I don't if that's possible. If it is the I would like to flat it if there is a difference.
Can lansweeper read AD properties?
Thank you.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-16-2016 12:15 AM
Lansweeper scans a number of Active Directory user and computer attributes and properties. These are stored in the "tblAD..." database tables. I've included a sample report below that lists your Windows computers, their last logged on user and the manager of that user. You can add this report to your Lansweeper installation by following these instructions.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email,
tblADObjects.sAMAccountName As ManagerName,
tblADObjects.domain As ManagerDomain,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblADObjects
Right Join tblADusers On tblADObjects.ADObjectID =
tblADusers.ManagerADObjectId
Right Join tblAssets On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1
Order By tblAssets.Domain,
tblAssets.AssetName
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-16-2016 12:15 AM
Lansweeper scans a number of Active Directory user and computer attributes and properties. These are stored in the "tblAD..." database tables. I've included a sample report below that lists your Windows computers, their last logged on user and the manager of that user. You can add this report to your Lansweeper installation by following these instructions.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Name,
tblADusers.Displayname,
tblADusers.email,
tblADObjects.sAMAccountName As ManagerName,
tblADObjects.domain As ManagerDomain,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblADObjects
Right Join tblADusers On tblADObjects.ADObjectID =
tblADusers.ManagerADObjectId
Right Join tblAssets On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1 And tsysAssetTypes.AssetType = -1
Order By tblAssets.Domain,
tblAssets.AssetName
