Thank you for all your help :- As it is going to be a number of machines can I put more than one Where tblNtlog.Eventcode = 4625 And tblAssetCustom.State = 1Order By tblNtlog.TimeGenerated DescCan I add more than one field e.gWhere tblNtlog.Eventcode...

Thank you very much for your help

I really need this to be in LanSweeper rather than that solution if possible as this is to go alot of machines etc..