In the Microsoft Configuration Manager 2007 console, under System Status, under Status Message Queries, there's a Query named "Collections Created, Modified, or Deleted". Right-click and choose "Show Messages" opens the report viewer and prompts for specifying some date criteria.
Clicking View/Query Information, it shows the WQL query that produces the output.
select stat.*, ins.*, att1.*, stat.Time from SMS_StatusMessage as stat left join SMS_StatMsgInsStrings as ins on stat.RecordID = ins.RecordID left join SMS_StatMsgAttributes as att1 on stat.RecordID = att1.RecordID where stat.MessageType = 768 and stat.MessageID >= 30015 and stat.MessageID <= 30017 and stat.Time >= '2013/01/04 15:00:17.000' order by stat.Time desc
However, it doesn't show where it pulls the "Description" column from. If I click on Filter, and set a filter statement like (ABC00012) it updates to show the appropriate rows. If I click on QUery Properties again, it shows the filter statement in the lower window as "FDESCRIPT=(ABC00012) ", but the query itself (upper window) appears unchanged. What table or view contains this "FDESCRIPT" column?