Functions/FoldersFiles/Find-PVFile.ps1

Function Find-PVFile {

    <#
    .SYNOPSIS
    Finds a particular file, list of files, password, or list of passwords,
    according to the parameters set.

    .DESCRIPTION
    Exposes the PACLI Function: "FINDFILES"

    .PARAMETER safe
    The name of the Safe containing the file(s) or password(s)
    you are looking for. You can use a wildcard to specify a
    wider range of safenames.

    .PARAMETER folder
    The name of the folder containing the file(s) or password(s)
    to be found.

    .PARAMETER filePattern
    The full name or part of the name of the file(s) or
    password(s) to list. Alternatively, a wildcard can be used in
    this parameter.

    .PARAMETER fileRetrieved
    Whether or not the report will include retrieved files or
    passwords.

    .PARAMETER fileChanged
    Whether or not the report will include modified files or
    passwords.

    .PARAMETER fileNew
    Whether or not the report will include new files or
    passwords.

    .PARAMETER fileLocked
    Whether or not the report will include locked files or
    passwords.

    .PARAMETER fileWithNoMark
    Whether or not the report will include files or passwords
    without an access mark.

    .PARAMETER includeVersions
    Whether or not the report will include previous versions of
    included files or passwords.

    Note: If the value is set to NO, the ‘deletedoption’
    parameter cannot be set to INCLUDE_DELETED.

    .PARAMETER onlyOpenSafes
    Whether or not the report will search only Safes that are
    currently open

    .PARAMETER includeSubFolders
    Whether or not the search will include subfolders.

    .PARAMETER dateLimit
    A specific time duration.
    Possible values are:
        NONE
        BETWEEN which is qualified by [fromdate] and [todate].
        PREVMONTH which is qualified by [prevcount].
        PREVDAY which is qualified by [prevcount].

    .PARAMETER dateActionLimit
    The activity that took place during the period specified in
    [datelimit].
    Possible values are:
        ACCESSEDFILE
        CREATED
        MODIFIED

    .PARAMETER prevCount
    The number of days or months to be included in the report if
    [datelimit] is specified as ‘PREVMONTH’ or ‘PREVDAY’.

    .PARAMETER fromDate
    The first day to be included in the report if [datelimit] is
    specified as ‘BETWEEN’.
    Use the following date format:
        dd/mm/yyyy.

    .PARAMETER toDate
    The last day to be included in the report if [datelimit] is
    specified as ‘BETWEEN’.
    Use the following date format:
        dd/mm/yyyy.

    .PARAMETER searchInAll
    Whether or not the report will only include files or passwords
    that contain the values specified in the ‘searchinallvalues’
    parameter in their Safe, folder or file/password name, or in
    one of their file categories, as specified in the
    ‘searchinallcategorylist’ parameter.

    .PARAMETER searchInAllAction
    The way that the values in the ‘searchinallvalues’ parameter
    will be searched for if the ‘searchinall’ parameter is set to
    ‘YES’.
    Possible values are:
        ‘OR’ – at least one of the values in the list needs to be
        found.
        ‘AND’ – all the values in the list need to be found.

    .PARAMETER searchInAllValues
    A list of values that should be searched for when the
    ‘searchinall’ parameter is set to ‘YES’. The values in the list
    must be separated by the character specified in the
    ‘listseparator’ parameter.

    .PARAMETER searchInAllCategoryList
    A list of category names to search in when the ‘searchinall’
    parameter is set to ‘YES’. The values in the list must be
    separated by the character specified in the ‘listseparator’
    parameter.

    .PARAMETER listSeparator
    A character that will be used to separate the values in the
    ‘searchinallvalues’, ‘searchinallcategorylist’, ‘categoryidlist’,
    and ‘categoryvalues’ parameters. The default value is “,”
    (comma).

    Note: When a string with more than one character is
    specified, only the first character will be used.

    .PARAMETER deletedOption
    Whether or not deleted files will be shown in the report.
    Possible values are:
        INCLUDE_DELETED_WITH_ACCESSMARKS (default value)
        INCLUDE_DELETED
        ONLY_DELETED
        WITHOUT_DELETED

    Note: If the value is set to INCLUDE_DELETED, the
    ‘includeversions’ parameter cannot be set to NO.

    .PARAMETER sizeLimit
    The file or password size limit in KB for the search, based
    on the ‘sizelimittype’ parameter.

    .PARAMETER sizeLimitType
    The type of file or password size-based search.
    Possible
    values are:
        ATLEAST
        ATMOST

    .PARAMETER categoryIDList
    A list of category IDs according to which the values
    specified in the ‘categoryvalues’ parameter will be searched
    for.

    Note: The first value corresponds to the first category, the
    second value to the second category, etc.
    Only files or passwords that contain the specified file
    categories (according to the ‘categorylistaction’ parameter)
    with the specified values will be returned.

    .PARAMETER categoryValues
    A list of values to search for in the file categories specified
    in the ‘categoryidlist’ parameter.

    Note: The first value corresponds to the first category, the
    second value to the second category, etc.
    Only files or passwords that contain the listed file categories
    (according to the ‘categorylistaction’ parameter) with the
    specified values will be returned.

    .PARAMETER categoryListAction
    Specifies how to search for the values in the ‘categoryidlist’
    and ‘categoryvalues’ parameters.
    Possible values are:
        ‘OR’ – at least one of the values in the list needs to be
        found.
        ‘AND’ – all the values in the list need to be found.

    .PARAMETER includeFileCategories
    Whether or not the search will include file categories in the
    output.

    .PARAMETER fileCategoriesSeparator
    Character to be written in the search output to separate the
    file categories. The default value is ‘#’.

    .PARAMETER fileCategoryValuesSeparator
    Character to be written in the search output to separate the
    file categories and their values. The default value is ‘:’.

    .EXAMPLE
    Find-PVFile -safe Reports -folder root

    Finds all files in the root folder of Reports safe.

    .NOTES
    AUTHOR: Pete Maan

    #>


    [CmdLetBinding()]
    param(

        [Parameter(
            Mandatory = $True,
            ValueFromPipelineByPropertyName = $True)]
        [Alias("safename")]
        [string]$safe,

        [Parameter(
            Mandatory = $True,
            ValueFromPipelineByPropertyName = $True)]
        [string]$folder,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [string]$filePattern,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$fileRetrieved,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$fileChanged,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$fileNew,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$fileLocked,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$fileWithNoMark,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$includeVersions,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$onlyOpenSafes,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$includeSubFolders,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [ValidateSet("NONE", "BETWEEN", "PREVMONTH", "PREVDAY")]
        [string]$dateLimit,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [ValidateSet("ACCESSEDFILE", "CREATED", "MODIFIED")]
        [string]$dateActionLimit,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [int]$prevCount,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [datetime]$fromDate,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [datetime]$toDate,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$searchInAll,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [ValidateSet("OR", "AND")]
        [string]$searchInAllAction,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [string]$searchInAllValues,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [string]$searchInAllCategoryList,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [string]$listSeparator,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [ValidateSet("INCLUDE_DELETED_WITH_ACCESSMARKS", "INCLUDE_DELETED", "ONLY_DELETED", "WITHOUT_DELETED")]
        [string]$deletedOption,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [int]$sizeLimit,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [ValidateSet("ATLEAST", "ATMOST")]
        [string]$sizeLimitType,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [string]$categoryIDList,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [string]$categoryValues,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [ValidateSet("OR", "AND")]
        [string]$categoryListAction,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [switch]$includeFileCategories,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [string]$fileCategoriesSeparator,

        [Parameter(
            Mandatory = $False,
            ValueFromPipelineByPropertyName = $True)]
        [string]$fileCategoryValuesSeparator
    )

    PROCESS {

        ("fromDate", "toDate") | ForEach-Object {

            if ($PSBoundParameters.ContainsKey($_)) {

                $PSBoundParameters[$_] = (Get-Date $($PSBoundParameters[$_]) -Format dd/MM/yyyy)

            }

        }

        #execute pacli
        $Return = Invoke-PACLICommand $Script:PV.ClientPath FINDFILES "$($PSBoundParameters | ConvertTo-ParameterString -donotQuote dateLimit,dateActionLimit,prevCount,
                    searchInAllAction,deletedOption,sizeLimit,sizeLimitType,
                        categoryListAction ) OUTPUT (ALL,ENCLOSE)"


        if ($Return.ExitCode -eq 0) {

            #if result(s) returned
            if ($Return.StdOut) {

                #Convert Output to array
                $Results = $Return.StdOut | ConvertFrom-PacliOutput

                #loop through results
                For ($i = 0 ; $i -lt $Results.length ; $i += 32) {

                    #Get Range from array
                    $values = $Results[$i..($i + 32)]

                    #Output Object
                    [PSCustomObject] @{

                        "Filename"                   = $values[0]
                        "Accessed"                   = $values[1]
                        "CreationDate"               = $values[2]
                        "CreatedBy"                  = $values[3]
                        "DeletionDate"               = $values[4]
                        "DeletionBy"                 = $values[5]
                        "LastUsedDate"               = $values[6]
                        "LastUsedBy"                 = $values[7]
                        "LockDate"                   = $values[8]
                        "LockedBy"                   = $values[9]
                        "LockedByGW"                 = $values[10]
                        "Size"                       = $values[11]
                        "History"                    = $values[12]
                        "InternalName"               = $values[13]
                        "Safe"                       = $values[14]
                        "Folder"                     = $values[15]
                        "FileID"                     = $values[16]
                        "LockedByUserID"             = $values[17]
                        "ValidationStatus"           = $values[18]
                        "HumanCreationDate"          = $values[19]
                        "HumanCreatedBy"             = $values[20]
                        "HumanLastUsedDate"          = $values[21]
                        "HumanLastUsedBy"            = $values[22]
                        "HumanLastRetrievedByDate"   = $values[23]
                        "HumanLastRetrievedBy"       = $values[24]
                        "ComponentCreationDate"      = $values[25]
                        "ComponentCreatedBy"         = $values[26]
                        "ComponentLastUsedDate"      = $values[27]
                        "ComponentLastUsedBy"        = $values[28]
                        "ComponentLastRetrievedDate" = $values[29]
                        "ComponentLastRetrievedBy"   = $values[30]
                        "FileCategories"             = $values[31]

                    } | Add-ObjectDetail -TypeName pacli.PoShPACLI.File

                }

            }

        }

    }
}