SolarWinds SDK Powershell WMI Add script

Hi,

when I need something like this my script looks like this.

$username = "YOURUSERNAME"

$SecurePassword = ConvertTo-SecureString -AsPlainText -Force -String 'YOURPASSWORD'

$cred = New-Object -typename System.Management.Automation.PSCredential -argumentlist $username, $Securepassword

$SwisConnection = Connect-Swis -Hostname $hostname -Credential $cred

#then I use a variable for the SQL-command because sometimes they are very long

#For Example SQL-Statement to get Attributes of a custom property

$customproperty = "devicetype"

$YOURVARSQL = @"

SELECT Table, Field, DataType, MaxLength, StorageMethod, Description, TargetEntity, Mandatory, Default

FROM Orion.CustomProperty  WHERE Field = '$($customproperty)'

"@

#Note I am new to Powershell but I figured out that sometime you have to parse a variable to get the output as a string or something like this. Please correct me So for that use $($variablename) like above in the SQL-command.

$YOURVAR = Get-SwisData -SwisConnection $SwisConnection -Query $YOURVARSQL

Hope this helps you