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 · Accepted solution]

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'))

[Saikumar2328]

@rushikeshvartak @NM - I have updated it and working as expected Thank you for support.

Now i'm doing the delete account Json for mail box.

user status is 0, and user have an email address on the term date user mailbox should be removed.

can you please share the query for this.