This column is mandatory for deployments to work with reports

[ahahum]

I'm trying to deploy software to a report that contains machines that do not have this software on it. However, when I try to run it I get this error in the deployment logs:

This column is mandatory for deployments to work with reports

Looking at my report, I do have the AssetID in there so I'm not sure what exactly it is looking for. What specific table and and column is deployment requiring here?

[User18954]

I had the same issue.
I was reporting strictly on NAS units, not Windows units to do a WOL too.

So I added 1 PC into the mix of NAS units and it took it. So it deploys now. Still have to test if it really does WOL on the units at a set time (due to power losses and the NAS units themselves BIOS not WOLing after power loss).

[Esben_D]

Do you have tblassets.assetID in the report? the report needs to be linked to tblassets before it can be used for deployments.

[paulruvalcaba]

Esben.D wrote:
Do you have tblassets.assetID in the report? the report needs to be linked to tblassets before it can be used for deployments.

I am having this same issue.

I get "...had no 'AssetID' column. This column is mandatory for deployments to work with reports."
Where does it want the AssetID to be listed? I see it a couple of times in the report already.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Username,
  tblADusers.Firstname,
  tblADusers.Lastname,
  SubQuery1.Value As [Registry Value],
  tblAssets.Firstseen,
  SubQuery1.Lastchanged,
  tblAssets.Lastseen As Lastseen
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
  Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
  Left Join (Select Top 1000000 tblRegistry.AssetID,
        tblRegistry.Regkey,
        tblRegistry.Valuename,
        tblRegistry.Value,
        tblRegistry.Lastchanged
      From tblRegistry
      Where
        tblRegistry.Regkey Like
        '%SYSTEM\CurrentControlSet\Control\Session Manager\Environment' And
        tblRegistry.Valuename = 'JAVA_TOOL_OPTIONS') SubQuery1 On
    SubQuery1.AssetID = tblAssets.AssetID
  Inner Join tblADusers On tblADusers.Username = tblAssets.Username
Where tblAssetCustom.State = 1 And TsysWaittime.CFGname = 'registry'
Order By tblAssets.AssetName