Lansweeper Raports problem

[RpiTMS]

Hello i got problem with Lansweeper reports, i use

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption As SO, = 'Microsoft Windows 10 Pro'
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.OScode,
tblNtlog.Eventcode, = 6005
tblNtlog.TimeGenerated,
tblAssetCustom.State
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Where tblOperatingsystem.Caption = 'Microsoft Windows 10 Pro' And
tblNtlog.Eventcode = 6005 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

Lansweeper is scanning assets correctly creating log for event 6005, but some of the logs are not appearing in the reports and some are. And where is the problem?

[RpiTMS]

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblOperatingsystem.Caption As SO,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblNtlog.Eventcode,
tblNtlog.TimeGenerated
From tblAssets
Inner Join tblOperatingsystem

I Removed alsmot everything but i still got this random error some logs are shown in raport and some aren't.


We got this rule that all pc supost to run at 7:00AM but not every Pc starts up, how to create report in lansweepr that show which pc did'n start up at 7:00 AM

[Esben_D]

I just pasted your code in the report builder of Lansweeper and you seem to have criteria in your select statement which give an error.

With the criteria removed it seems to work just fine.

Have you tried doing a left join for tsysOS and tblOperatingsystem? Maybe some of your assets do not have a those fields filled in and are therefore filtered out.