Trying to get a specific date for the report below
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblNtlog.TimeGenerated,
tblAssets.Description,
tblAssetCustom.Model,
tblNtlog.Eventcode,
tblNtlogSource.Sourcename,
tblNtlogMessage.Message,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
tblNtlog.SourcenameID
Where tblNtlog.TimeGenerated Like '%2017-05-23%' And tblNtlog.Eventcode = 6008
And tblAssetCustom.State = 1
Order By tblNtlog.TimeGenerated Desc
