cisco

7 Topics

Windows 10 VPN and SQL with Meraki VPN
Hi, when our users connect to VPN (Windows 10 VPN on Meraki) they used to be able to access a client application on a SQL server host (also a Windows 10 Pro box)....but something recently happened on the host (uninstalled Norton security and it likely reset a bunch of stuff) and now client VPN users are no longer able to access that application....we can ping the SQL host from the client device after connecting to VPN but no longer access the application, so my guess its some Windows firewall port or protocol on the SQL server blocking the traffic when it sees the traffic coming in via VPN because it works fine within the network, and its not as permission issue as I put the same client device on the network and it can access the application without any issues. Any thoughts or ideas?
redtechguy
Feb 12, 2020 Place SQL Server
2.8KViews
0likes
1Comment
Windows 10 VPN and SQL with Meraki VPN
Hi, when our users connect to VPN (Windows 10 VPN on Meraki) they used to be able to access a client application on a SQL server host (a Windows 10 host)....but something recently happened on the host (uninstalled Norton security and it likely reset a bunch of stuff) and now client VPN users are no longer able to access that application....we can ping the SQL host from the client device after connecting to VPN but no longer access the application, so my guess its some Windows firewall port or protocol on the SQL server blocking the traffic when it sees the traffic coming in via VPN because it works fine within the network, and its not as permission issue as I put the same client device on the network and it can access the application without any issues. Any thoughts or ideas?
redtechguy
Feb 12, 2020 Place Windows 10
2.2KViews
0likes
4Comments
Friday Mail Sack: Robert Wagner Edition
First published on TechNet on Sep 09, 2011 Hello folks, Ned here again.
NedPyle
Apr 05, 2019 Place Ask the Directory Services Team
1.4KViews
0likes
0Comments
Friday Mail Sack: Super Slo-Mo Edition
First published on TechNet on Sep 30, 2011 Hello folks, Ned here again with another Mail Sack.
NedPyle
Apr 05, 2019 Place Ask the Directory Services Team
1.4KViews
0likes
0Comments
Creating and exporting a collection with variable properties
My script logs into multiple Cisco UCS servers and extracts the CPU information, storing it in a collection which is then written to a CSV file. My problem is that I have a loop which creates a set of properties for each CPU in the server and adds it to the collection. However some servers have 2 CPUs and some have 4. When my code exports the data to CSV, I only get 2 CPUs of data for ALL servers, even though I can see 4 CPUs defined in the collection as I step thru the code. Thus, as the code runs and collects CPU data, the collection ($IMCRackServerInventory) looks like this: Server01, CPU1_ID, CPU1_Model, CPU2_ID, CPU2_Model Server02, CPU1_ID, CPU1_Model, CPU2_ID, CPU2_Model Server03, CPU1_ID, CPU1_Model, CPU2_ID, CPU2_Model, CPU3_ID, CPU3_Model, CPU4_ID, CPU4_Model Server04, CPU1_ID, CPU1_Model, CPU2_ID, CPU2_Model But then the collection is exported to CSV and I only get the following in the CSV: Server01, CPU1_ID, CPU1_Model, CPU2_ID, CPU2_Model Server02, CPU1_ID, CPU1_Model, CPU2_ID, CPU2_Model Server03, CPU1_ID, CPU1_Model, CPU2_ID, CPU2_Model Server04, CPU1_ID, CPU1_Model, CPU2_ID, CPU2_Model So it seems to be only writing the first 2 CPU details to file as not all records have 4 entries. Is there a way around this? My Code: # # ================================FUNCTION DECLARATION START==================================================================== # # # Check the required columns for this script to run, are present in the user-selected CSV import file. Function CheckCSVColumnsExist { Param( [Object]$CSVImportFile, [Array]$ColumnsToCheck = '' ) $ColumnHeaders = (Import-Csv $CSVImportFile | Get-Member -MemberType NoteProperty).Name $MissingColumnHeaders = @() ForEach( $ColumnToCheck in $ColumnsToCheck) { $MissingColumnName = New-Object PSObject If ($ColumnHeaders -match $ColumnToCheck ) { # Nothing to do. } Else { $MissingColumnName | Add-Member -type NoteProperty -Name 'Column_Name' -Value $ColumnToCheck $MissingColumnHeaders += $MissingColumnName } } Return $MissingColumnHeaders } # This function shows the Open File dialog to the user so the user can # select the import CSV file. # Function Get-FileName($InitialDirectory) { [System.Reflection.Assembly]::LoadWithPartialName("System.windows.forms") | Out-Null $OpenFileDialog = New-Object System.Windows.Forms.OpenFileDialog $OpenFileDialog.initialDirectory = $initialDirectory $OpenFileDialog.filter = "CSV (*.csv) | *.csv" $OpenFileDialog.ShowDialog() | Out-Null $OpenFileDialog.FileName } # # ================================FUNCTION DECLARATION FINISH=================================================================== # # # ================================SCRIPT START================================================================================== # # Import-Module Cisco.IMC # The input CSV file contains the details required for the script # to log into each Cisco UCS server. # # Get the CSV import file name and path: $ImportCSVFile = Get-FileName Write-Host "Script starting." -ForegroundColor Green # Check if the user cancelled the request. if ($ImportCSVFile -eq "") { # They did! Throw "No file selected. Ending script" } # Load the CSV file contents. $UCSRackServerReport = Import-CSV $ImportCSVFile -ErrorAction SilentlyContinue # Ask the user for the CIMC credential details. $IMCServerCredential = Get-Credential admin $IMCRackServerInventory = @() # Read each entry in the import CSV file, then try to logon to the # CIMC of each one and collect hardware details. ForEach ($vRow in $UCSRackServerReport) { $Item = New-Object PSObject # Get the server CIMC IP. $RackServerIMCIP = $vRow."IP Address" # Get the server User Label and Host Name. $RackServerIMCUserLabel = $vRow."User Label" $RackServerIMCHostName = $vRow."Host Name" # If the User Label is blank, use the Host Name for console output updates. If ([string]::IsNullOrWhiteSpace($RackServerIMCUserLabel) ) { $StringLabel = "[$RackServerIMCHostName/$RackServerIMCIP]" } Else { $StringLabel = "[$RackServerIMCUserLabel/$RackServerIMCIP]" } Try { # Let's connect to the CIMC. $Connected = $True Write-Host "$StringLabel Attempting a connection to server IMC." -ForegroundColor Yellow $IMCHandle = Connect-IMC -Name $RackServerIMCIP -Credential $IMCServerCredential -NotDefault -ErrorAction Stop } Catch { # Did not connect due to connection issue. Write-Host "$StringLabel Error: $($PSItem.ToString())" -ForegroundColor Red If ($PSItem.Exception.ToString().Contains("Unable to connect")) { # Set connection flag false. $Connected = $False } } # Did we connect to the CIMC? If (!$Connected) { # No we did not. Record this event. If ([string]::IsNullOrWhiteSpace($RackServerIMCUserLabel) ) { $NewUserLabel = $RackServerIMCHostName } Else { $NewUserLabel = $RackServerIMCUserLabel } # Set collection details and the properties not read in will be set to "Not Connected". $Item | Add-Member -type NoteProperty -Name 'UserLabel' -Value $NewUserLabel $Item | Add-Member -type NoteProperty -Name 'Model' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'Serial' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'ServerID' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'CIMC_IP' -Value $RackServerIMCIP $Item | Add-Member -type NoteProperty -Name 'Vendor' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'IMCName' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'DN' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'Rn' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'CPUID_1' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'CPUModel_1' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'OperState_1' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'Presence_1' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'SocketDesignation_1' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'CPUVendor_1' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'CPUIMC_1' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'Dn_1' -Value "Not Connected" $Item | Add-Member -type NoteProperty -Name 'Rn_1' -Value "Not Connected" } Else { # We connected OK. Write-Host "$StringLabel Connection to server IMC established." -ForegroundColor Cyan Write-Host "$StringLabel Gathering Rack Unit data." -ForegroundColor Cyan # Get rack server hardware details. $IMCServerUnit = Get-IMCRackUnit -Imc $IMCHandle # Check if User Label is blank and if so, use the IMC field as the server label. If ([string]::IsNullOrWhiteSpace($IMCServerUnit.UsrLbl) ) { $NewUserLabel = $IMCServerUnit.Imc } Else { $NewUserLabel = $IMCServerUnit.UsrLbl } # Record rack server hardware details. $Item | Add-Member -type NoteProperty -Name 'UserLabel' -Value $NewUserLabel $Item | Add-Member -type NoteProperty -Name 'Model' -Value $($IMCServerUnit.Model) $Item | Add-Member -type NoteProperty -Name 'Serial' -Value $($IMCServerUnit.Serial) $Item | Add-Member -type NoteProperty -Name 'ServerID' -Value $($IMCServerUnit.ServerId) $Item | Add-Member -type NoteProperty -Name 'CIMC_IP' -Value $RackServerIMCIP $Item | Add-Member -type NoteProperty -Name 'Vendor' -Value $($IMCServerUnit.Vendor) $Item | Add-Member -type NoteProperty -Name 'IMCName' -Value $($IMCServerUnit.Imc) $Item | Add-Member -type NoteProperty -Name 'DN' -Value $($IMCServerUnit.Dn) $Item | Add-Member -type NoteProperty -Name 'Rn' -Value $($IMCServerUnit.Rn) Write-Host "$StringLabel Gathering Processor data." -ForegroundColor Cyan $CPUCounter = 1 # Get the rack server processor details. $IMCServerProcessors = Get-IMCProcessorUnit -Imc $IMCHandle # For multiple processors, cycle thru each object found. ForEach ($IMCServerProcessor in $IMCServerProcessors) { # Dynamically create the property name with "_#" at the end for each processor. Record processor details. $FieldName = "CPUID_$CPUCounter"; $Item | Add-Member -type NoteProperty -Name $FieldName -Value $($IMCServerProcessor.Id) $FieldName = "CPUModel_$CPUCounter"; $Item | Add-Member -type NoteProperty -Name $FieldName -Value $($IMCServerProcessor.Model) $FieldName = "OperState_$CPUCounter"; $Item | Add-Member -type NoteProperty -Name $FieldName -Value $($IMCServerProcessor.OperState) $FieldName = "Presence_$CPUCounter"; $Item | Add-Member -type NoteProperty -Name $FieldName -Value $($IMCServerProcessor.Presence) $FieldName = "SocketDesignation_$CPUCounter"; $Item | Add-Member -type NoteProperty -Name $FieldName -Value $($IMCServerProcessor.SocketDesignation) $FieldName = "CPUVendor_$CPUCounter"; $Item | Add-Member -type NoteProperty -Name $FieldName -Value $($IMCServerProcessor.Vendor) $FieldName = "CPUIMC_$CPUCounter"; $Item | Add-Member -type NoteProperty -Name $FieldName -Value $($IMCServerProcessor.Imc) $FieldName = "Dn_$CPUCounter"; $Item | Add-Member -type NoteProperty -Name $FieldName -Value $($IMCServerProcessor.Dn) $FieldName = "Rn_$CPUCounter"; $Item | Add-Member -type NoteProperty -Name $FieldName -Value $($IMCServerProcessor.Rn) $CPUCounter += 1 } Write-Host "$StringLabel Gathering Firmware data." -ForegroundColor Cyan # Get the firmware package details. $IMCFirmwarePackage = Get-ImcFirmwareRunning -Imc $IMCHandle | Where {$_.Deployment -eq "system" -and $_.Type -eq "blade-controller"} # Add the firmware package details to the collection. $Item | Add-Member -type NoteProperty -Name 'BMCFirmwarePackage' -Value $($IMCFirmwarePackage.Version) } $IMCRackServerInventory += $Item Write-Host "$StringLabel Data collection completed." -ForegroundColor Blue # Close the connection to the server's CIMC. If ($IMCHandle -ne $Null ) { $CloseIMCHandle = Disconnect-IMC -Imc $IMCHandle } Write-Host "$StringLabel Closing session to server IMC." -ForegroundColor Blue Write-Host "" } # Write the collected data to CSV file. $IMCRackServerInventory | Export-CSV -Path "UCS_IMC_RackServer_Inventory.csv" -NoTypeInformation -UseCulture Write-Host "Script Finished." -ForegroundColor Green
Solved
JulianMilano
Aug 03, 2023 Place Windows PowerShell
1.3KViews
0likes
6Comments
MS Teams Cisco Video integration Assign -ResourceGroupName
Could you assign a -ResourceGroupName to MSTeam CVI integration using MS Team Powershell? We can identify and assign the tenant and individual user vis email address. But I was not able to locate the option to the user -ResourceGroupName. Is this an available option?
MrHill12Many
Jan 09, 2023 Place Microsoft Teams
953Views
0likes
1Comment
Calling via teams // Cisco worsen the quality
Hi community, while calling via teams it is possible to get another call via cisco Lync. So cisco is ringing while I am trying to communicate with someone via teams. This worsen the quality of the teams callings... please help me to better my calling's quality. kind regards
NMille72
Apr 22, 2020 Place Teams Developer
844Views
0likes
0Comments