→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ahahum
Engaged Sweeper II
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?

3 REPLIES 3
User18954
Engaged Sweeper II
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
Lansweeper Employee
Lansweeper Employee
Do you have tblassets.assetID in the report? the report needs to be linked to tblassets before it can be used for deployments.
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