Public/Get-Person.ps1
|
<# .SYNOPSIS Gets a person. .DESCRIPTION Gets all persons or a single person if a person id is specified. If the result return null, try the parameter "-Verbose" to get more details. .EXAMPLE Get-AccessLevel ComputerName : SERVER LastChanged : 19/10/2017 12:46:39 Path : \\SERVER\root\OnGuard:Lnl_Cardholder.ID=1 PersonID : 1 Server : SERVER SuperClass : Lnl_Person Lastname : Smith SSNO : Firstname : John Credential : Class : Lnl_Cardholder Midname : .LINK https://github.com/erwindevreugd/PSDataConduIT #> function Get-Person { [CmdletBinding()] param ( [Parameter( Position=0, Mandatory=$false, ValueFromPipelineByPropertyName=$true, HelpMessage='The name of the server where the DataConduIT service is running or localhost')] [string]$Server = $Script:Server, [Parameter( Position=1, Mandatory=$false, ValueFromPipelineByPropertyName=$true, HelpMessage='The credentials used to authenticate the user to the DataConduIT service')] [PSCredential]$Credential = $Script:Credential, [Parameter( Mandatory=$false, ValueFromPipelineByPropertyName=$true, HelpMessage='The person id parameter')] [int]$PersonID ) process { $query = "SELECT * FROM Lnl_Person WHERE __CLASS='Lnl_Cardholder'" if($PersonID) { $query += " AND ID=$PersonID" } LogQuery $query $parameters = @{ ComputerName=$Server; Namespace=$Script:OnGuardNamespace; Query=$query } if($Credential -ne $null) { $parameters.Add("Credential", $Credential) } Get-WmiObject @parameters | ForEach-Object { New-Object PSObject -Property @{ Class=$_.__CLASS; SuperClass=$_.__SUPERCLASS; Server=$_.__SERVER; ComputerName=$_.__SERVER; Path=$_.__PATH; Credential=$Credential; PersonID=$_.ID; Firstname=$_.FIRSTNAME; Lastname=$_.LASTNAME; Midname=$_.MIDNAME; LastChanged=ToDateTime $_.LASTCHANGED; SSNO=$_.SSNO; } } } } |