My report for SRP:
Select Top 10000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Username,
tblADusers.OU,
tblNtlogSource.Sourcename,
tblNtlog.Eventcode,
tblNtlog.TimeGenerated,
tblNtlogMessage.Message
From tblAssets
Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID
Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID
Inner Join tblNtlogSource On tblNtlogSource.SourcenameID =
tblNtlog.SourcenameID And (tblNtlogSource.Sourcename =
'Microsoft-Windows-SoftwareRestrictionPolicies' Or
tblNtlogSource.Sourcename = 'Software Restriction Policies')
Left Join tblADusers On tblADusers.Username = tblAssets.Username
Order By tblNtlog.TimeGenerated Desc