Dynamic asset group

[Joris_]

Hello All,

I don't see the option for my Dynamic asset group to filter on User level.

Let me specify my issue.

We have field people and need an application. I want to rollout the program with the deploy option.
If I can make a dynamic asset group based on user ou it is possible for me.

Ideas ?

[Jeremy_D · Accepted solution]

Dynamic asset groups don't allow you to filter the user OU, but you can build a report to list the information you are after. Deployments can be run on reports as well. We included a sample report below that lists computers whose last logged on user belongs to a specific OU. Replace what we've highlighted with your OU name. To add the report to your Lansweeper installation, follow these instructions.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblADusers.OU,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
    tblADusers.Userdomain = tblAssets.Userdomain
Where tblADusers.OU Like '%technicians%' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName