Need to build a new technical rule for a task

[Saikumar2328]

Hi Friends,

I need to build a new technical rule for remote mail box enable for a user from win connector 

from connection we are calling the PS Script.

To trigger this action, I need a technical rule for create remote mail box is

user status is "active" and user should have a mail address and user should have an active ad account.

we need to pass all three requirements, can you please help me for build a advance query or we can select from condition  in Technical rule.

Thanks,

Sai Kumar M.

[NM]

@Saikumar2328 try this.

a.statuskey=1 AND a.email is not null AND a.id in (select ua.userkey from User_accounts ua, Accounts cc where ua.accountkey=cc.id and cc.endpointkey=<endpointkey to enter> and cc.status in (1,'Manually Provisioned')

Btw for win connector you have deployed the agent right on iis server?

[Saikumar2328]

yes @NM we have deployed agent in IIS server.

[rushikeshvartak]

a.statuskey=1 AND a.email is not null AND a.id in (	select ua.userkey from User_accounts ua, Accounts cc where ua.accountkey=cc.id and cc.endpointkey=100 and cc.status in (1,'Manually Provisioned'))