Deploy to report of assets where user is in a specific group

[iwchisholm]

I've a specific AD USER group to which I want to deploy software to.
I've created a report which pulls computers that users of this group are the most recent logged in user. (also pull chassis as laptop users get two software deployed, desktops only one)

HOWEVER - the result of the report isn't one I can use to deploy to - the Asset names are not clickable and "Deploy" is not an option. Any thoughts?

Select Top 1000000 tblAssets.AssetName,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Username,
tblADusers.email,
tblADusers.EmployeeID,
Replace(Replace(Replace(Replace(tblADusers.OU, 'OU=Users,', ''), ',DC=CR,',
''), 'DC=LOCAL', ''), 'OU=', '') As Department,
tblADGroups.Name,
TsysChassisTypes.ChassisName,
tblSoftwareUni.softwareName,
tblSoftwareUni.Added
From tblADusers
Inner Join tblADMembership On tblADusers.ADObjectID =
tblADMembership.ChildAdObjectID
Inner Join tblADGroups On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Inner Join tblAssets On tblAssets.Username = tblADusers.Username And
tblAssets.Userdomain = tblADusers.Userdomain
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID And
tblSystemEnclosure.AssetID = tblAssets.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblADGroups.Name = 'Global - AD Users'

[iwchisholm]

I was being an idiot...

Thanks for the quick solution!

Ian.

[David_G · Accepted solution]

The reason why you are not able to click on the asset names is that you have left out the database field tblAssets.AssetID. If you include this database field into your report, you will be able to click on the asset names.

Also, to easily deploy a package based on a report, you can go to Deployments\Installer Packages, then select the deployment package you want to deploy on the assets and there you will have the option to deploy the package to all the assets in a certain report.