Uncorrelated accounts make them service Account type

[Diptansu_Sinha]

Hello Team, 

There is a requirement to map uncorrelated accounts = Service Account for one application. 

Can you provide sample approach/Query to achieve this requirement.

[NM]

@Diptansu_Sinha it will consider full application as a services account application.

[rushikeshvartak]

select accountkey as accounts__primarykey, 'Service Account' as accounts__accounttype from accounts where endpointkey =100 and accountkey not in (select accountkey from user_accounts ) limit 1; 

use above enhanced query for your requirement

[Diptansu_Sinha]

But after every recon does not the accounttype will be wiped out since we are setting it manually?

[rushikeshvartak]

No account type attributes does not get overwrite. If get overwrite then use triggerchain and run query after account / access import