Install-Module MSOnline - not working
Hi all, I am struggling to install: Install-Module MSOnline I get: I have tried: Get-PSRepository WARNING: Unable to find module repositories. When I run: Register-PSRepository -Default I get no error but when trying to run Get-PSRepository again i get WARNING: Unable to find module repositories. Any ideas on how to fix this?
Script to convert .log files to JSON
Recently setup a pipeline from AWS S3 to our SIEM (Microsoft Sentinel) using a lambda function to ingest our AWS WAF logs. There is a succesful connection between the two but I noticed that the logs weren't being pushed. The logs are stored in .log format and after converting the format to JSON they went through and I could see them in the SIEM. The problem is we had to do this manually and need to find a way to automate this. Is there a powershell script that could automate the conversion of a .log file to JSON? The lambda function is a powershell script so this would be easy to add.
Extracting Virtual Machine Information in Azure.
I just want to shared my modified code in azure vm information extraction. Data will be the list of VMName, IPAddress, ResourceGroup, VmSize & Tag. # User Authentication $ua = Get-StoredCredential -Target AzureAccount $credential = New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $ua.UserName,$ua.Password # Login to your Azure Account Connect-AzAccount -Tenant '<Tenant ID>' -Credential $credential # Get All Virtual Machines & VMSize $resultVMs = Get-AzVM | Where-Object { $_.Name -and $_.ResourceGroupName -and $_.HardwareProfile.VmSize } ` | Select-Object -Property @{n="Resource"; e={ $_.ResourceGroupName }}, @{n="VMName"; e={ $_.Name }}, @{n="VmSize"; e={ $_.HardwareProfile.VmSize }} ` # Get All Virtual Machines & WorkNo Tag $resultTags = Get-AzResource -ResourceType "Microsoft.Compute/virtualMachines" ` | Where-Object { $_.Name -and $_.ResourceGroupName -and $_.Tags.WorkNo } ` | Select-Object -Property @{n="Resource"; e={ $_.ResourceGroupName }}, @{n="VMName"; e={ $_.Name }}, @{n="Tags"; e={ $_.Tags.WorkNo }} ` # Get All Virtual Machines & Ip Address $resultIPAdds = Get-AzNetworkInterface | Where-Object { $_.ResourceGroupName -and $_.VirtualMachine -and $_.IPConfigurations -and $_.IPConfigurations.PrivateIPAddress } ` | Select-Object -Property @{n="Resource"; e={ $_.ResourceGroupName }}, @{n="VMName"; e={ $_.VirtualMachine.Id.Split("/")[-1] }}, @{n="PrivateIPAddress"; e= { $_.IpConfigurations.PrivateIPAddress }} ` # Create Report Array $report = @() # Loop All VM's foreach($resultVM in $resultVMs){ # Creating Report Header $reportdetails = "" | Select VMName, IPAddress, ResourceGroup, VmSize, Tag # Save the VM Name $reportdetails.VMName = $resultVM.VMName # Save the Resource Group Name $reportdetails.ResourceGroup = $resultVM.Resource # Save the VmSize $reportdetails.VmSize = $resultVM.VmSize # Save the IP Address $temp = @(($resultIPAdds | Where-Object { $_."VMName" -match $resultVM.VMName }).PrivateIPAddress) $reportdetails.IPAddress = $temp[0] # Save the Tag $temp = @(($resultTags | Where-Object { $_."VMName" -match $resultVM.VMName }).Tags) $reportdetails.Tag = $temp[0] # Save Report $report+=$reportdetails } # Generate Report $report | Export-Excel ".\Desktop\VMList_ $(get-date -f yyyy.MM.dd.HH.mm.ss).xlsx" Write-Host "Finished..." Hope it can help others too. 😁😁😁.
How can I use a System Managed Identity with Connect-MsolService
Does anyone know how to use Connect-MsolService with a system-assigned managed identity? I need it for the purpose of getting MFA status data about the organisation's employees. MSGraph seems to have zero data on this, except for the User Registration Details report, which again does not show MFA status.
