I'm trying to make a a power shell script out of this query so I can logs for a particular collection and move them directly to a text file. 

Select stat.*, ins.*, att2.* from SMS_StatusMessage as stat left outer join SMS_StatMsgInsStrings as ins on stat.recordid = ins.recordid left outer join SMS_StatMsgAttributes as att1 on stat.recordid = att1.recordid inner join SMS_StatMsgAttributes as att2 on stat.recordid = att2.recordid  WHERE ((att1.AttributeID=000 AND att1.AttributeValue="YYYY")) AND (SiteCode="XXX") order by att2.AttributeTime Desc

• Moved by Garth JonesMVP Tuesday, June 30, 2015 4:37 PM Powershell question