A script to check a log file. If conditions are met the script will then delete, and copy in a file into the folder.

 I wrote a quick script to automate a process I found myself doing every few months.  

We have software that has a maximum number of licenses available. Unfortunately, when a user logs out, the software does not release that license.  To solve this issue we simply delete a .log and .dat file, and then paste a old copy of the .dat file back into that location.  Sounds kind of complicated, but it might make a little more sense looking at the script.  Lets take a look:

The software will output a license count to a logfile that looks something like this.


So in order to get the license count, we need to pull that log file into PowerShell, split it on the empty space, and then count the numbers remaining.  This was a little complicated for me to figure out but this is what I came up with.

$split = Import-Csv C:\Users\alexg\Desktop\Scripts\license.log -Delimiter " " -Header Name,Amount
$Count = $split | Measure-Object 'Amount' -Sum | Select-Object -expandProperty Sum


So now that we have the log file imported and arranged in an array of objects, we can select the object we want to work with and work with it.  

The second line of that snippet tells PowerShell to get the sum of the objects in the Amount column.  I used the Measure-Object cmdlet, specified the object (Amount), and specified the measurement I wanted (in my case the Sum). 

So now we have the number of licenses that are being used.  We can now use that number in the rest of the script.

if($count -gt 50){
Remove-Item -Path C:\Users\alexg\Desktop\Scripts\software.dat
Remove-Item -Path C:\Users\alexg\Desktop\Scripts\license.log
Copy-Item -Path C:\Users\alexg\Desktop\net.dat -Destination C:\Users\alexg\Desktop\Scripts
}

Now that we have checked the license count I input that number ($count) into a if then statement with the max number of licenses allowed.  

If the license count is greater than 50, the script will remove the .dat file and the .log file.  It will then copy the old .dat file from a separate location and import it into the desired location.  The final script looks like this:

$split = Import-Csv C:\Users\alexg\Desktop\Scripts\pcm_server.log -Delimiter " " -Header Name,Amount
$Count = $split | Measure-Object 'Amount' -Sum | Select-Object -expandProperty Sum
 
if($count -gt 50){
Remove-Item -Path C:\Users\alexg\Desktop\Scripts\software.dat
Remove-Item -Path C:\Users\alexg\Desktop\Scripts\license.log
Copy-Item -Path C:\Users\alexg\Desktop\net.dat -Destination C:\Users\alexg\Desktop\Scripts
}

This is just a quick script that will prevent us from having to do this manually.

Comments

Post a Comment

Popular posts from this blog

Bulk AD User creation Powershell Script

Image
 As a follow up, I want to post of one of my most recent scripts.  This script is used to do bulk AD user creation.   My company has been growing rapidly and it takes up a lot of my time when creating and setting up new employee accounts and mailboxes.  I recently spent some time writing a script to automate this process.  This script takes a CSV file that has been filled out by HR with the new employee's name and other information.  It imports that information into Active Directory and creates a user profile.   Our hiring managers often include in the service ticket the name of an employee who would have the same rights/permissions/and memberships as the new employee.  So to simplify things, I put in my CSV file a column that is the "User to Copy".  This tells the script to copy that user's profile/OU/memberof details and apply them to the new user.   Once created, the script then starts a remote session into our On-prem ...
Read more

PowerShell: Update User Permissions for a Shared Mailbox or Calendar using Add-MailboxFolderPermission

 I use this simple script to update permissions for a Shared Calendar for a group of Users.  This can be used for updating permissions to other Shared Mailbox Folders also. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 #Connect to Exchange Online Connect-ExchangeOnline -UserPrincipalName alex.g @COMPANY .com #Create a list of User email addressses by seraching specific OUs and adding them to a users variable. $users = get-aduser -filter * -SearchBase "OU=MEC_Operations,OU=MEC,OU=COMPANY Users,DC=COMPANY,DC=local" -Properties mail | Select-Object mail $users += get-aduser -filter * -SearchBase "OU=COL_Operations,OU=COL,OU=COMPANY Users,DC=COMPANY,DC=local" -Properties mail | Select-Object mail $users += get-aduser -filter * -SearchBase "OU=HAR_Operations,OU=HAR,OU=COMPANY Users,DC=COMPANY,DC=local" -Properties mail | Select-Object mail $users += get-aduser -filter * -SearchBase "OU=RIC_Operations,OU=RIC,OU=...
Read more