How to delete empty records from user table using any script?

[SK36]

hi

I want to delete empty records from user table. How to achieve this by using script?

[Ankur Bawiskar]

@SK36 

how do you mean by empty records?

what script did you start with?

[Ankur Bawiskar]

@SK36 

Unfortunately you didn't share answers to my questions.

Glad that you got the script.

[Gunjan Kiratkar · Accepted solution]

Hi @SK36 ,

I'm considering here username as empty. You may have different field. apply query according to that.

var gr = new GlideRecord('sys_user');  
gr.addEncodedQuery('user_nameISEMPTY'); // user_nameISEMPTY     if user id field is empty and people id filed is empty
gr.query();  
while (gr.next()) {  
  gr.deleteMultiple();
}  

[SK36]

Hi, is this fix script or background script?