RE: [mssms] SQL query to get status messages?

Thanks Troy and Sherry! Daniel Ratliff From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of slkissin...@sbcglobal.net Sent: Friday, March 28, 2014 11:22 AM To: mssms@lists.myitforum.com Subject: Re: [mssms] SQL query to get status messages? You want to do

Re: [mssms] SQL query to get status messages?

Take a look/search on John Nelson's blog on myITforum... Sent from my iPhone On Mar 28, 2014, at 10:45 AM, "Daniel Ratliff" mailto:dratl...@humana.com>> wrote: Has anyone ever done any SQL queries to gather status messages? Any ideas on how I can get this data? I can get just about any colum

[mssms] SQL query to get status messages?

Has anyone ever done any SQL queries to gather status messages? Any ideas on how I can get this data? I can get just about any columns I need, but not the actual message itself! My query select top 1000 * from v_statusmessage MSG INNER JOIN v_statmsgattributes ATT ON MSG.RecordID = ATT.Rec

Re: [mssms] SQL query to get status messages?

You want to do this: http://myitforum.com/cs2/blogs/jnelson/archive/2009/11/20/143120.aspx so you get your own custom schema, table, and view. Note that what’s available is “only” the status messages from cm07. If there are any status messages specific to cm12; those aren’t there. Fr