Re: Collection based on Status Messages

There is a query option '<unspecified>' that is designed for items that do
not fit the normal 'system resource' definition....

Steve
"Sonnichsen" <Sonnichsen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:950F0859-EDE2-463B-9C20-F95921E59F9A@xxxxxxxxxxxxxxxx
By the way, this is the original query from SMS Status Message Viewer
which
the SMS Collection Query Builder doesn't accept:

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=401 AND att1.AttributeValue="100200DC")) AND
(stat.Time>='2006/06/27 22:00:00.000') AND (MessageID=10007) AND
(SiteCode="100") AND (ModuleName="SMS Client") order by att2.AttributeTime
Desc

--
Soren Holst Sonnichsen


"Sonnichsen" wrote:

Hi

Is it possible to create a collection based on certain status messages?

I need to make a collection which shows the clients that doesn't install
a
certain program, but instead reports an error back to SMS.

Thanks

--
Soren Holst Sonnichsen



.