Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Export-DbaUser is much faster than Get-DbaUser, even though it does less work. #9450

Open
ReeceGoding opened this issue Aug 21, 2024 · 0 comments
Labels
bugs life triage required New issue that has not been reviewed by maintainers

Comments

@ReeceGoding
Copy link
Contributor

Verified issue does not already exist?

I have searched and found no existing issue

What error did you receive?

No error, but this doesn't feel like intended behaviour. If I want to get all users for a particular login, Get takes minutes. If I want to export the scripts to create them as well as their extra permissions, Export takes seconds. Logically, Export ought to require getting each user, so this mismatch in runtimes seems very strange.

Steps to Reproduce

Just run both for a particular login on one of your boxes. No special parameters or steps needed. Don't specify a database. It might be worth mentioning that my instances all have around 50 databases.

Please confirm that you are running the most recent version of dbatools

Yes.

Other details or mentions

No response

What PowerShell host was used when producing this error

Windows PowerShell (powershell.exe)

PowerShell Host Version

5.1.19041.4648

SQL Server Edition and Build number

I hit multiple, but mostly 2019.

.NET Framework Version

Very recent.

@ReeceGoding ReeceGoding added bugs life triage required New issue that has not been reviewed by maintainers labels Aug 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bugs life triage required New issue that has not been reviewed by maintainers
Projects
None yet
Development

No branches or pull requests

1 participant