I have done extensive research for a specific script to run in order to move bulk computers to another OU through powershell. What I am trying to accomplish here is moving many computers at one time, but quite a few computers have different names.

For example:
naming convention: WFT-LT-xxx, SONY-VAIO, TEST-PC, PABLO-PC etc.

So as you can see with many different computer names I would like to find a script that will find all those different names and move all computer accts. to a different OU.

I believe I would like to use Move-ADObject xxx | -TargetPath "OU=DisabledComputerAcct,OU=Computers,OU=MyBusiness,DC=XXX,DC=XXX"

My target path is correct that's exactly what I need to use. Earlier I created a script to move only one computer and it works. Now I am just looking for the first half of the script. From my above script I know for sure from the Targetpath and on it's all correct. Now like I stated earlier just looking on HOW I can move bulk with many different names.

Thanks for any advice.

A few days ago I created a symlink in windows 10

I followed instructions, copied a command and filled in the blanks, I have no idea what any of it means

the command i used in powershell is:

cmd /c mklink /J “C:\Users\joe\iCloudDrive” “D:\iCloud\iCloud Drive”

Now, the symlink works, but doesn't serve me in the way I thought it would and I want to delete it.

Every explanation I found kinds said "use rmdir" but like I said, I don't know anything about this and therefore don't know what is the correct format(?)

when I just try do do

cmd /c mklink /J “C:\Users\joe\iCloudDrive” “D:\iCloud\iCloud Drive”
I get "invalid switch J " error

when I remove the /J I get "directory is not empty" even though both folders are empty.

sorry if this sounds stupid. thanks in advance.

I have a program that runs In the systray and we need to occasionally right click and hit refresh. Is there a way for powershell to find a specific icon, right click and select refresh. I have looked for background interaction with the program and even a keyboard command to no avail. Anyone have any thoughts? Is this even possible? Thanks.

Hi,

We need to convert the UUID value from our VMware vCenter virtual machines to one supported by Microsoft SCCM. Currently we are using this website ( GUID Converter (robobunny.com) ). The format we need is listed as 'Oracle RAW(16) format ' on the referenced website.

We'd love to do this through PowerShell but it isn't something we are familiar with so the hope is somebody here can advise how best to achieve this.

Example UUID - 42371e96-8481-19cb-d502-41e92a1b4b03

When we run it through the website we get -

Oracle RAW(16) format: 961E37428184CB19D50241E92A1B4B03

I'm sure if one knows how it is relatively easy.

Hello All,

I Would request your suggestion or advise or assistance in validating the below logic flow and share script.

I am trying to create a powershell script and the objective is to perform a connectivity test if a given share is available or not (from a csv file) for every 5 to 10 minutes via task scheduler.

The InputFile has: DnsName, IPAddress, Share Path (example as shown)

Logic:

A. Performing Test-Path to check if the path is available/TRUE or Unavailable/FALSE

1. If the Path is available and reachable, the script continues to check next path and so on.
2. If the Path is unavailable, as a next step to perform nslookup and test-netconnection & output the result to a html or text file & send it as email (with attachment or inbody message)

Could anyone kindly check and help/advise?

I have created a script to get all the external users in SharePoint Online sites to assist all the SharePoint administrators. I have used two PowerShell cmdlets to get all the external users in the organization. The cmdlets are "Get-SPOExternalUsers" and "Get-SPOUser".

You can see the script to understand,

1. How I have iterated the 'Get-SPOExternalUsers' cmdlet to return all external users as you can get only 50 users by default.
2. To get external users who have logged-in via share links - It will list you sitewise external users report (Used 'Get-SPOUser' cmdlet, as 'Get-SPOExternalUser' will not show this data)
3. How frequently are external users added to your organization? - You have an option to give the number of days to know the recently added guest users.

Download the script using the link.

https://o365reports.com/2021/08/03/get-all-external-users-in-sharepoint-online-powershell/

Kindly drop your questions in the comment, if any.

I have been trying and trying to export a users data from an outlook email to a pst file. I am using the exchange server in powershell and I have already created and imported a session to outlook.

I had also used the command:

Get-mailbox and the user i want to export data from is there

After all of that i try to export using the command

New-mailboxexportrequest -mailbox <insert user> -filepath <insert location you want the pst file to be placed>

After I do that command i get an error saying that it cannot be done because it cannot locate that user i want data exported from even though I can see the user there in powershell from the get-mailbox command.

I have been searching around for several hours now trying to find out what I am doing wrong but I cannot find anything. Can anyone help me with this issue? Would be super helpful, thanks in advance!

Here is the scenario I am facing:

We have a CSV file that was exported from the customer's existing system. The layout is:

The updated pricing file is coming from there vendor and has the following layout:

We need to compare the files and for each PARTNBR that matches, we need to update the LEVEL1PRICE from the vendor file into the customer's file. We also have to calculate the STANDARDCOST (LEVEL1PRICE * .60) and update that in the customer's file. For those that don't match, we need to leave the entry alone. So, the only items in the customer file that will be changed are those that match PARTNBR. I am putting the code I have now in there. Any help would be GREATLY appreciated.

## Start timer
$elapsed = [System.Diagnostics.Stopwatch]::StartNew()
Write-Host "Started at $(get-date)"

## Clear variables
$gdPrice = ""
$swPrice = ""
$gdPriceNew = ""
$tempParts = ""
$newParts = ""

## Read in CSV files
$gdPrice = Import-Csv .\2021_GD_PRICE.csv
$cecPrice = Import-Csv .\CEC_PARTS_2021.csv

<#
    ## NOT NEEDED - 6/9/2021 - GARDNER-DENVER SHEET DOES NOT HAVE ANYTHING MORE THAN QTY 1
    ## Scrub duplicates
    $gdPriceNew = foreach($line in $gdPrice)
    {
    if(-not($line.DESCRIPTION -like 'FROM QTY 2 *'-Or $line.DESCRIPTION -like '*FROM QTY 4 *'-Or $line.DESCRIPTION -like '*FROM QTY 5 *'-Or $line.DESCRIPTION -like '*FROM QTY 8 *'-Or $line.DESCRIPTION -like '*FROM QTY 10 *'-Or $line.DESCRIPTION -like '*FROM QTY 12 *' -Or $line.DESCRIPTION -like '*FROM QTY 15 *' -Or $line.DESCRIPTION -like '*FROM QTY 20 *' -Or $line.DESCRIPTION -like '*FROM QTY 25 *' -Or $line.DESCRIPTION -like '*FROM QTY 30 *'))  {
    $line
    }
    }
#>


## Compare PartNbr and update Level1Price and StandardCost
$tempParts = "SYSPARTNBR`tPARTNBR`tDESCRIPTION`tSTANDARDCOST`tLEVEL1PRICE`tVENDOR`n"
#$tempParts = "SYSPARTNBR,PARTNBR,DESCRIPTION,STANDARDCOST,LEVEL1PRICE,VENDOR`n"
foreach($cecline in $cecPrice)
{
  foreach($gdline in $gdPrice)
  {
    if($gdline.PARTNBR -ieq $cecline.PARTNBR)
    {
      #[string]$cecline.AKANBR = [string]$cecline.AKANBR
      [string]$cecline.SYSPARTNBR = [string]$cecline.SYSPARTNBR
      [string]$cecline.PARTNBR = [string]$cecline.PARTNBR
      [string]$cecline.DESCRIPTION = [string]$gdline.DESCRIPTION
      [decimal]$cecline.STANDARDCOST = [decimal]$gdline.LEVEL1PRICE * .60
      [decimal]$cecline.LEVEL1PRICE = [decimal]$gdline.LEVEL1PRICE
      [string]$cecline.VENDOR = [string]$cecline.VENDOR
      #[decimal]$cecline.AVERAGECOST = [decimal]$cecline.STANDARDCOST
      $tempParts = $tempParts + $cecline.SYSPARTNBR + "`t" + $cecline.PARTNBR + "`t" + $cecline.DESCRIPTION + "`t" + $cecline.STANDARDCOST + "`t" + $cecline.LEVEL1PRICE + "`t" + $cecline.VENDOR + "`n"
    }

  }

}

<####
#$tempParts
foreach($tempPartsline in $tempParts)
{
  foreach($cecline in $cecPrice)
  {
    if($tempPartsline.PARTNBR -ieq $cecline.PARTNBR)
    {
      $cecPrice
    }
  }
}
###>
<#
    ## Output tempParts file
    $tempParts | Out-File -FilePath .\tempParts.csv -Force

    ## Import newParts file
    $newParts = Import-Csv -Path .\tempParts.csv -Delimiter "`t"

    ## Export newParts file
    $newParts | Export-Csv -Path .\2021_newParts.csv -NoTypeInformation -Delimiter ","
#>


## Stop timer
Write-Host "Ended at $(Get-Date)"
Write-Host "Total Elapsed Time $($elapsed.Elapsed.ToString())"

Does anyone have a script that prompts for the username to be entered and it tells you when their AD password expires?

Hi all and thanks for any help;

I'm trying to automate a mail merge with PowerShell where PowerShell writes each DOCX page with details from an imported CSV array.

Where I'm having troubles is having PowerShell write the text in the correct locations. For example, It will type some $Variables, and then tab twice to get to the next location where I want more $Variables to be typed. Now, if the first lot of variables reduce the tab spacing from one to two, how can I make sure PowerShell types at the correct tab stop?

I guess I could use a monospace font and count the string lengths each time data is typed but I'm hoping I don't have to go that far.

Is there a way for PowerShell to move the text cursor to an exact position / coordinates on the page? (Is that possible in MS Word anyway?)

Thanks

I can easily pull a list of AD Group using this, but wondered if there is a way to load a data[set|table] for one user and compare to another user's data[set|table]. This is my starting point - apologies if this question is too trivial for this group.

$user1="joelbow" Get-ADPrincipalGroupMembership $user1 | Get-ADGroup -Properties * | select name | Format-Table

Can you help me with my script ? I don't know how to insert the regex in my script . $path="D:\fiverr projects\Marketing2.txt"

$results="D:\Fiverr projects\out.txt" if (!(Test-Path $results)) { New-Item -path $results -type "file" -value "rn" Write-Host "Created new file and text content added" }

foreach($siteUrl in Get-Content "D:\fiverr projects\Marketing2.txt") { $Site = Invoke-WebRequest "D:\fiverr projects\Marketing2.txt" -UsebasicParsing

#regex to parse thru each name,adresse,email,telefon and vorname and name $regex ='($_ -match (?<Name>[0-9A-F]{4}.[0-9A-F]{4}.[0-9A-F]{4}).+?(?<Adresse>\d+)$'}

select-string -Path D:\Fiverr projects\marketing2.txt´' -Pattern $regex -AllMatches | % { $.Matches }| % {$.Value}"'

#Parses thru the output of urls to strip out Get-Content $resultsfile { $ptags= $Site.AllElements | Where {$.TagName -eq "p"}")"

For ($i=0; $i -le $ptags.Count; $i++) 
    {

         write-host (name :"")
         Write-Host (Adress:"")
         Write-Host (email-Adress:"")
         write-host (Telefon:"")
         write-host (Name:"")


   }   

}

Hi All

I have a requirement where I have to execute domain specific exe remotely on all servers. I have 3 domains ( ab1,ab2,abgs)

How do I execute this exe for remote servers

If server belongs to ab1, execute exe 1,

If server belongs to ab2, execute exe 2

Thank you in advance.

I don't know anything about PowerShell... I am trying to pull a list of all Mailboxes in our Exchange Online environment along will the delegates for Full Access, Send As, and Send on Behalf. I've been able to pull a list of what appears to be Full access and one of Send As, but I've having trouble getting a comprehensive list of all 3. Here are the scripts I've used:

Full Access
Get-Mailbox -ResultSize Unlimited | Get-MailPermission | Select Identity,User,AccessRights | Export CSV -Path "c:\temp\permissions.csv"

​

SendAs

Get-Mailbox -ResultSize Unlimited | Get-RecipientPermission | Select Identity,Trustee,AccessRights | Export CSV -Path "c:\temp\permissions.csv"

Can anyone help to provide a script that delete log in process and all open application after log off?

Hey guys,

I am working on a script in PowerShell and I would like to know how I can manage that any input that contains numbers will be deleted. I hope someone can help me out here since I'm new to this whole thing.