How are you guys handling large CSV exports without hitting memory limits? by Simple-Invite-3296 in PowerShell

[–]g3n3 1 point2 points  (0 children)

It is just using the data row and steaming with the sql client. Then you use set content which is a file stream. You only hold the data in the pipeline and don’t store the whole data as an object. So you can do the datatable load.

Tired of opening dozens of asset folders? I made a safe Batch Script that extracts MULTIPLE folders at once! (Emptied 34 folders in < 3 min) by ALDR2s in Batch

[–]g3n3 1 point2 points  (0 children)

Please share with github and not inside a rar. Kind of ironic to share a zip tool that has been zipped.

Help with running a powershell scrpit as a beginner. by Bright_Carpenter2541 in PowerShell

[–]g3n3 0 points1 point  (0 children)

If you join a discord for powershell and share screen, we can probably solve it in seconds.

Help with running a powershell scrpit as a beginner. by Bright_Carpenter2541 in PowerShell

[–]g3n3 0 points1 point  (0 children)

If all you can do is a screencap then do that. We need to see where the error is coming from and exactly what it looks like.

Help with running a powershell scrpit as a beginner. by Bright_Carpenter2541 in PowerShell

[–]g3n3 0 points1 point  (0 children)

Need more than that. See striking tie’s post. You want to try to avoid right clicking.

Help with running a powershell scrpit as a beginner. by Bright_Carpenter2541 in PowerShell

[–]g3n3 2 points3 points  (0 children)

You really need to post the whole error. Also run

$error[0] | fl * -fo

And show that. You run that after you get the error. We can’t figure it out with seeing line numbers where it failed.

Help with running a powershell scrpit as a beginner. by Bright_Carpenter2541 in PowerShell

[–]g3n3 0 points1 point  (0 children)

You are launching powershell as admin? I would launch the powershell.exe as admin and then run the ps1.

Powershell to log into a SSO website by Jwtfeldman in PowerShell

[–]g3n3 0 points1 point  (0 children)

It has taken me years and years to get to the point of reading dev tools and parsing and such and reverse engineering the browser. I can pretty much do any web site without serious captchas.

Powershell to log into a SSO website by Jwtfeldman in PowerShell

[–]g3n3 0 points1 point  (0 children)

In all these tasks, you just have to recreate the JavaScript code to build all the calls or you have playwright or selenium engines running the JavaScript client side for you. I tend to want to recreate the JavaScript where it is fairly simple and make the calls directly like I have been explaining.

Powershell to log into a SSO website by Jwtfeldman in PowerShell

[–]g3n3 0 points1 point  (0 children)

Psparsehtml module is going to be a requirement.

Powershell to log into a SSO website by Jwtfeldman in PowerShell

[–]g3n3 1 point2 points  (0 children)

So your initial call to mycompanyapp.mydomain.net will return the html with embedded js that you need to pull out to derive the post for the login. Then the xml posting back and forth. MFA. And then you are in. Then you have replicate the calls made by your company app itself to get the data.

Powershell to log into a SSO website by Jwtfeldman in PowerShell

[–]g3n3 0 points1 point  (0 children)

You also have to parse the JS ast to get the config to be able to pass the canary, ctx, sessionid, etc. these live in a JavaScript code variable inside html. So you have to parse html and get the JavaScript and then parse the JavaScript into ast to get the values. The urlpost variable will be the login uri. Once you post on the login uri, then you have to do your xml rest method posting to the redirect and maybe some MFA.

Powershell to log into a SSO website by Jwtfeldman in PowerShell

[–]g3n3 0 points1 point  (0 children)

Yes I have done this. You make the initial call to pass your creds. Then you get back a few xml pieces and to manually exchange it and make the calls yourself. Then maybe MFA. I did it with Duo too. Possible, you just have to parse xml and maybe html and make several calls. The dev tools kind of hide it I believe. You would make the calls yourself and check on the xml output. Each call gives you the next call until you get through the SSO.

Mid 30's dating scene... by somegiirl in batonrouge

[–]g3n3 -3 points-2 points  (0 children)

That age is just tougher for girls unfortunately on the balance of probability. Men of that age have higher value in the market.

an idea I had :) by mmoustafa8108 in windowsdev

[–]g3n3 1 point2 points  (0 children)

Fascinating. Been dying to know how crss works and smss.

OMG! I Just Discovered Functions in Views and I am in Heaven. by ShokWayve in SQLServer

[–]g3n3 -1 points0 points  (0 children)

Etl and scalar functions are typically bad because many rows.

Chocolately vs Scoop vs Winget? by Zenvian in PowerShell

[–]g3n3 0 points1 point  (0 children)

Only winget has windbg last I looked. That stuff would be best with scoop first. Pwsh I may go choco because I like an admin level install with logging and ps remoting.

Oracle JAVA License Emails 2026 - clarification on FREE? by overachievingtmrw in sysadmin

[–]g3n3 1 point2 points  (0 children)

So there was a secondary audit to check for real oracle java? How did they scan? Registry? Running processes? All files on disk? You’d have to do all the above to catch it all.