Lansweeper-PS.psm1
|
if (Get-Module -ListAvailable -Name dbatools) { import-module dbatools } else { write-host "The module dbatools is not installed, but it is required to function. Please follow the prompts to install dbatools." try{install-module dbatools} catch{Write-Host "Failed to install the dbatools module! Are you able to connect to the PSGallery repository, or do you need to install from another location?"} break import-module dbatools } function EncryptableVolumeStatus($AssetObject, $AssetID) { $MyHash = [ordered]@{} try {$DiskArray = Invoke-Command {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblEncryptableVolume WHERE AssetID = @Variable" -SqlParameters @{Variable = $AssetID} -SqlInstance "SVR3-SQL"}} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} foreach($Disk in $DiskArray) { $MyHash[$Disk.DriveLetter] = $Disk.ProtectionStatus } if ($MyHash["C:"] -eq 0) {$AssetObject | Add-Member -MemberType NoteProperty -Name "OSDriveEncryptionStatus" -Value $false -Force} if ($MyHash["C:"] -eq 1) {$AssetObject | Add-Member -MemberType NoteProperty -Name "OSDriveEncryptionStatus" -Value $true -Force} if ($MyHash["C:"] -eq 2) {$AssetObject | Add-Member -MemberType NoteProperty -Name "OSDriveEncryptionStatus" -Value "Unknown" -Force} $AssetObject | Add-Member -MemberType NoteProperty -Name "EncryptableDisks" -Value $MyHash -Force } function Get-LSAsset { <# .Description Get-Asset queries lansweeperdb.dbo.tblAssets for asset(s) matching the passed parameters. Object is returned with parameters for each column in SQL database. -SQLInstance parameter is used to specify the SQL server where the database exists. #> #Parameters are defined to search for matching objects. [CmdletBinding()] param ( [parameter(Mandatory=$false)]$AssetID, [parameter(Mandatory=$false)]$AssetName, [parameter(Mandatory=$false)]$Credentials, [parameter(Mandatory=$false)]$IPAddress, [parameter(Mandatory=$false)]$LastChanged, [parameter(Mandatory=$false)]$Lastseen, [parameter(Mandatory=$false)]$LastTried, [parameter(Mandatory=$false)]$LastTriggered, [parameter(Mandatory=$false)]$LastActiveScan, [parameter(Mandatory=$false)]$LastScheduled, [parameter(Mandatory=$false)]$LastSaved, [parameter(Mandatory=$false)]$MAC, [parameter(Mandatory=$false)]$Memory, [parameter(Mandatory=$false)]$OSCode, [parameter(Mandatory=$false)]$Processor, [parameter(Mandatory=$true)] $SQLInstance, [parameter(Mandatory=$false)]$Scanserver, [parameter(Mandatory=$false)]$SP, [parameter(Mandatory=$false)]$Username, [parameter(Mandatory=$false)]$Userdomain ) #Build a query based on assigned parameters that are not SQLInstance or Credentials. foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials") { $ComputerObject = $PSBoundParameters.item($Parameter) try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblAssets WHERE $Parameter = @Variable" -SqlParameters @{Variable = $ComputerObject} -SQLCredential $Credentials -SqlInstance $SQLInstance}} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} break #Allows only one parameter to be run without creating literally dozens of parameter sets } } } function Get-LSAssetCustom { <# .Description Get-AssetCustom queries lansweeperdb.dbo.tblAssetCustom for asset(s) matching the passed parameters. Object is returned with parameters for each column in SQL database. -SQLInstance parameter is used to specify the SQL server where the database exists. #> [CmdletBinding()] param ( [parameter(Mandatory=$false)]$AssetID, [parameter(Mandatory=$false)]$BranchOffice, [parameter(Mandatory=$false)]$Contact, [parameter(Mandatory=$false)]$CustID, [parameter(Mandatory=$false)]$Credentials, [parameter(Mandatory=$false)]$DNSName, [parameter(Mandatory=$false)]$Department, [parameter(Mandatory=$false)]$DeviceVersion, [parameter(Mandatory=$false)]$FirmwareVersion, [parameter(Mandatory=$false)]$HardwareVersion, [parameter(Mandatory=$false)]$HTTPServer, [parameter(Mandatory=$false)]$HTTPSServer, [parameter(Mandatory=$false)]$SNMPOID, [parameter(Mandatory=$false)]$SMTPHeader, [parameter(Mandatory=$false)]$FTPHeader, [parameter(Mandatory=$false)]$LastChanged, [parameter(Mandatory=$false)]$Location, [parameter(Mandatory=$false)]$LastPatched, [parameter(Mandatory=$false)]$LastFullBackup, [parameter(Mandatory=$false)]$LastFullImage, [parameter(Mandatory=$false)]$Manufacturer, [parameter(Mandatory=$false)]$Model, [parameter(Mandatory=$false)]$Serialnumber, [parameter(Mandatory=$true) ]$SQLInstance, [parameter(Mandatory=$false)]$SystemSKU, [parameter(Mandatory=$false)]$Warrantydate, [parameter(Mandatory=$false)]$Custom1, [parameter(Mandatory=$false)]$Custom2, [parameter(Mandatory=$false)]$Custom3, [parameter(Mandatory=$false)]$Custom4, [parameter(Mandatory=$false)]$Custom5, [parameter(Mandatory=$false)]$Custom6, [parameter(Mandatory=$false)]$Custom7, [parameter(Mandatory=$false)]$Custom8, [parameter(Mandatory=$false)]$Custom9, [parameter(Mandatory=$false)]$Custom10, [parameter(Mandatory=$false)]$Custom11, [parameter(Mandatory=$false)]$Custom12, [parameter(Mandatory=$false)]$Custom13, [parameter(Mandatory=$false)]$Custom14, [parameter(Mandatory=$false)]$Custom15, [parameter(Mandatory=$false)]$Custom16, [parameter(Mandatory=$false)]$Custom17, [parameter(Mandatory=$false)]$Custom18, [parameter(Mandatory=$false)]$Custom19, [parameter(Mandatory=$false)]$Custom20 ) foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials") { $ComputerObject = $PSBoundParameters.item($Parameter) try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblAssetCustom WHERE $Parameter = @Variable" -SqlParameters @{Variable = $ComputerObject} -SQLCredential $Credentials -SqlInstance $SQLInstance}} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} break } } } function Get-LSADComputer { <# .Description Get-LSADComputer queries lansweeperdb.dbo.tblADComputer for asset(s) matching the passed parameters. Object is returned with parameters for each column in SQL database. -SQLInstance parameter is used to specify the SQL server where the database exists. #> [CmdletBinding()] param ( [parameter(Mandatory=$false)]$AdcomputerID, [parameter(Mandatory=$false)]$AssetID, [parameter(Mandatory=$false)]$Comment, [parameter(Mandatory=$false)]$Company, [parameter(Mandatory=$false)]$Credentials, [parameter(Mandatory=$false)]$Description, [parameter(Mandatory=$false)]$Location, [parameter(Mandatory=$false)]$OU, [parameter(Mandatory=$false)]$Lastchanged, [parameter(Mandatory=$false)]$LastScheduled, [parameter(Mandatory=$false)]$LastSaved, [parameter(Mandatory=$false)]$MAC, [parameter(Mandatory=$false)]$Memory, [parameter(Mandatory=$false)]$OSCode, [parameter(Mandatory=$false)]$Processor, [parameter(Mandatory=$true)] $SQLInstance, [parameter(Mandatory=$false)]$Scanserver, [parameter(Mandatory=$false)]$SP, [parameter(Mandatory=$false)]$Username, [parameter(Mandatory=$false)]$Userdomain ) foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials") { $ComputerObject = $PSBoundParameters.item($Parameter) try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblADComputers WHERE $Parameter = @Variable" -SqlParameters @{Variable = $ComputerObject} -SQLCredential $Credentials -SqlInstance $SQLInstance}} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} break } } } function Get-LSUser { <# .Description Get-LSUser queries lansweeperdb.dbo.tblUsers for asset(s) matching the passed parameters. Object is returned with parameters for each column in SQL database. -SQLInstance parameter is used to specify the SQL server where the database exists. #> [CmdletBinding()] param ( [parameter(Mandatory=$false)]$AssetID, [parameter(Mandatory=$false)]$Accounttype, [parameter(Mandatory=$false)]$BuiltInAdmin, [parameter(Mandatory=$false)]$Disabled, [parameter(Mandatory=$false)]$Description, [parameter(Mandatory=$false)]$Fullname, [parameter(Mandatory=$false)]$Lockout, [parameter(Mandatory=$false)]$Name, [parameter(Mandatory=$false)]$PasswordChangeable, [parameter(Mandatory=$false)]$PasswordExpires, [parameter(Mandatory=$false)]$PasswordRequired, [parameter(Mandatory=$false)]$SID, [parameter(Mandatory=$false)]$Status, [parameter(Mandatory=$false)]$UserID, [parameter(Mandatory=$false)]$LastChanged, [parameter(Mandatory=$true) ]$SQLInstance, [parameter(Mandatory=$false)]$Credentials ) foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials") { $ComputerObject = $PSBoundParameters.item($Parameter) try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblUsers WHERE $Parameter = @Variable" -SqlParameters @{Variable = $ComputerObject} -SQLCredential $Credentials -SqlInstance $SQLInstance}} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} break } } } function Get-LSComputerObject { [CmdletBinding()] #This function requires that the input be an AssetName in order to locate the computer across multiple tables. #AssetID is used as a universal identifier across tables, even those that do not track AssetName. param ( [parameter(Mandatory=$false) ]$AssetID, [parameter(Mandatory=$false) ]$AssetName, [parameter(Mandatory=$true) ]$SQLInstance, [parameter(Mandatory=$false)]$Credentials ) foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials" -And $Parameter -Like "AssetName") { $AssetsTable = Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblAssets WHERE AssetName = @Variable" -SqlParameters @{Variable = $AssetName} -SQLCredential $Credentials -SqlInstance $SQLInstance} #MyAssetID is assigned for use in the rest of the queries. $MyAssetID = $AssetsTable.AssetID $WholeComputerObject = Invoke-Command -ScriptBlock {Invoke-DbaQuery -File $PSScriptRoot\LSComputerObjectQuery.txt -SqlParameters @{AssetID = $MyAssetID} -SQLCredential $Credentials -SqlInstance $SQLInstance} #Using our new AssetID to query the EncryptableVolumes table and add the results to the DiskTable hashtable EncryptableVolumeStatus $WholeComputerObject $MyAssetID $WholeComputerObject break } elseif ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials" -And $Parameter -Like "AssetID") { $WholeComputerObject = Invoke-Command -ScriptBlock {Invoke-DbaQuery -File $PSScriptRoot\LSComputerObjectQuery.txt -SqlParameters @{AssetID = $AssetID} -SQLCredential $Credentials -SqlInstance $SQLInstance} EncryptableVolumeStatus $WholeComputerObject $WholeComputerObject.AssetID $WholeComputerObject break } } } function Get-LSLinuxSystem { [CmdletBinding()] param ( [parameter(Mandatory=$false)]$AssetID, [parameter(Mandatory=$false)]$Manufacturer, [parameter(Mandatory=$false)]$ProductName, [parameter(Mandatory=$false)]$Serial, [parameter(Mandatory=$false)]$UUID, [parameter(Mandatory=$false)]$NetworkNodtHostName, [parameter(Mandatory=$false)]$KernelName, [parameter(Mandatory=$false)]$KernelRelease, [parameter(Mandatory=$false)]$KernelVersion, [parameter(Mandatory=$false)]$MachineHardwareName, [parameter(Mandatory=$false)]$HardwarePlatform, [parameter(Mandatory=$false)]$OperatingSystem, [parameter(Mandatory=$false)]$OSRelease, [parameter(Mandatory=$false)]$SystemSku, [parameter(Mandatory=$true) ]$SQLInstance, [parameter(Mandatory=$false)]$Credentials ) foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials") { $ComputerObject = $PSBoundParameters.item($Parameter) try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblLinuxSystem WHERE $Parameter = @Variable" -SqlParameters @{Variable = $ComputerObject} -SQLCredential $Credentials -SqlInstance $SQLInstance}} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} break } } } function Get-LSDisks { [CmdletBinding()] param ( [parameter(Mandatory=$false)]$AssetID, [parameter(Mandatory=$false) ]$AssetName, [parameter(Mandatory=$false)]$DriveType, [parameter(Mandatory=$false)]$Filesystem, [parameter(Mandatory=$false)]$VolumeName, [parameter(Mandatory=$false)]$VolumeSerialNumber, [parameter(Mandatory=$true) ]$SQLInstance, [parameter(Mandatory=$false)]$Credentials ) foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials" -And $Parameter -Like "AssetName") { $AssetsTable = Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblAssets WHERE AssetName = @Variable" -SqlParameters @{Variable = $AssetName} -SQLCredential $Credentials -SqlInstance $SQLInstance} $MyAssetID = $AssetsTable.AssetID try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblDiskDrives WHERE AssetID = @Variable" -SqlParameters @{Variable = $MyAssetID} -SQLCredential $Credentials -SqlInstance $SQLInstance}} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} } elseif ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials") { $ComputerObject = $PSBoundParameters.item($Parameter) try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblDiskDrives WHERE $Parameter = @Variable" -SqlParameters @{Variable = $ComputerObject} -SQLCredential $Credentials -SqlInstance $SQLInstance}} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} break } } } function Get-LSLinuxVolumes { [CmdletBinding()] param ( [parameter(Mandatory=$false)]$AssetID, [parameter(Mandatory=$false)]$Type, [parameter(Mandatory=$true) ]$SQLInstance, [parameter(Mandatory=$false)]$Credentials ) foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials") { $ComputerObject = $PSBoundParameters.item($Parameter) try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblLinuxVolumes WHERE $Parameter = @Variable" -SqlParameters @{Variable = $ComputerObject} -SQLCredential $Credentials -SqlInstance $SQLInstance}} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} break } } } function Get-LSWindowsSoftware { [CmdletBinding()] param ( [parameter(Mandatory=$false)]$AssetID, [parameter(Mandatory=$false)]$AssetName, [parameter(Mandatory=$true) ]$SQLInstance, [parameter(Mandatory=$false)]$Credentials ) foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials" -And $Parameter -Like "AssetName") { $AssetsTable = Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "SELECT * FROM lansweeperdb.dbo.tblAssets WHERE AssetName = @Variable" -SqlParameters @{Variable = $AssetName} -SQLCredential $Credentials -SqlInstance $SQLInstance} $MyAssetID = $AssetsTable.AssetID try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -File $PSScriptRoot\LSSoftwareQuery.txt -SqlParameters @{AssetID = $MyAssetID} -SQLCredential $Credentials -SqlInstance $SQLInstance} | Select-Object AssetName, IPAddress, Software, Version} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} } elseif ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials" -And $Parameter -Like "AssetID") { try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -File $PSScriptRoot\LSSoftwareQuery.txt -SqlParameters @{AssetID = $AssetID} -SQLCredential $Credentials -SqlInstance $SQLInstance} | Select-Object AssetName, IPAddress, Software, Version} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} } } } function Get-LSMacSoftware { [CmdletBinding()] param ( [parameter(Mandatory=$false)]$AssetID, [parameter(Mandatory=$false)]$AssetName, [parameter(Mandatory=$true) ]$SQLInstance, [parameter(Mandatory=$false)]$Credentials ) foreach ($Parameter in $PSBoundParameters.keys) { if ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials" -And $Parameter -Like "AssetName") { $AssetsTable = Invoke-Command -ScriptBlock {Invoke-DbaQuery -Query "Select-Object * FROM lansweeperdb.dbo.tblAssets WHERE AssetName = @Variable" -SqlParameters @{Variable = $AssetName} -SQLCredential $Credentials -SqlInstance $SQLInstance} $MyAssetID = $AssetsTable.AssetID try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -File $PSScriptRoot\LSMacSoftwareQuery.txt -SqlParameters @{AssetID = $MyAssetID} -SQLCredential $Credentials -SqlInstance $SQLInstance} | Select-Object AssetName, Model, IPAddress, Software, Version} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} } elseif ($Parameter -NotLike "SQLInstance" -And $Parameter -NotLike "Credentials" -And $Parameter -Like "AssetID") { try {Invoke-Command -ScriptBlock {Invoke-DbaQuery -File $PSScriptRoot\LSMacSoftwareQuery.txt -SqlParameters @{AssetID = $AssetID} -SQLCredential $Credentials -SqlInstance $SQLInstance} | Select-Object AssetName, Model, IPAddress, Software, Version} catch {"Unable to invoke SQL query on remote server. Either the command did not recieve valid input, or dbatools threw an error."} } } } Export-ModuleMember -Function "Get-*" |