System Center Service Manager - Get-SCSMObject Filter

51 views Asked by At

I want to search for all UserComments of all Incidents in System Center Service Manager containing a bracket [.

So I tried it with Criteria:

$clUserComment = get-scsmclass System.WorkItem.TroubleTicket.UserCommentLog 
$criteria = New-Object "Microsoft.EnterpriseManagement.Common.EnterpriseManagementObjectCriteria" `
                ("Comment like '%[%'", $clUserComment )
$comments = Get-SCSMObject -Criteria $criteria

and with filter:

$comments = Get-SCSMObject -Class $clUserComment -Filter "Comment -like '%[%'"

I guess, that '[' is a special char, but don't know how to escape that.

And yes, one answer is adding a where-Object

 $doitComments = $comments | Where-Object { $_.comment -match '\[' }

but this answer is too slow for my usecase.

(c# tag because maybe experience with criteria) tia

0

There are 0 answers