How to tell if a domain user is a local admin on the machine

Question

I have above 50,000 rows of data in my excel sheet. It makes too much of time to insert the data into database table because it runs in for loop(spring boot for backend). Can some one suggest me the best for way for insert the data into database from excel in sql query.

Solution 1

Try net localgroup administrators instead. If you'd like a PowerShell command to check a specific user, take a look at this blog post. I would hope however that there aren't so many local administrators that you can't spot the user in question.

Solution 2

Try

C:\>NET USER SomeUser /domain

instead of

C:\>NET USER MYDOMAIN\SomeUser

Solution 3

Try this command to get all information of the user. it's a powershell command.

GPRESULT -Z /USER [username]

Comments

[Ramhound]

You do understand that a domain level permission would override any local permissions you might assign a local profile right?

[rtf]

@Ramhound Seems like he's concerned with domain users, not local users. He understands how to check a local account, but not how to check if a domain account is a local admin from the command line.

[Mike Christensen]

Correct. I was just looking for command line shortcuts for things I was already doing.

[Rajesh]

you're using spring data JPA or spring JDBC?

[Ajith]

we are using JPA

[Rajesh]

First read data from excel and added to POJO List and use repository.saveAll()

[Ajith]

Thanks for your effort. Can i get some regards as you mentioned. Because i am new to this language

[Rajesh]

Check the answer

[Mike Christensen]

Exactly what I was looking for! Thank you sir.

[Matthew Williams]

Since this question has already has an accepted answer you need to give more detail as to why your method is a more suitable option.

[Ajith]

Thanks for effort. Actually we have using java spring boot as backend. So it is not possible in using node js.

[Chamikara Samarasekara]

But we did 1 million rows within 10 minutes using nodejs app (ram 512, 1 cpu)